C2090-558 Online Practice Questions and Answers

Which command option should be used to resume an interrupted onbar restore?

A. -RETRY

B. -RESTART

C. -REINTIIALZE

D. -BEGIN_AGAIN

Under which of the following conditions does the LAST COMMITTED option have an effect on the COMMITTED READ isolation level?

A. Row level lock

B. Page level locking

C. RAW or unlogged tables

D. Tables containing complex data types

You have a database server environment where all databases use buffered logging. In which two conditions are the logical-log buffers in shared memory flushed to the logical log on disk? (Choose two.)

A. When the buffer is full.

B. When a checkpoint occurs.

C. When a user issues a begin work.

D. When a user commits the transaction.

E. When a user rolls back the transaction.

Assuming the tables and columns mentioned below exist, which of the following SQL statements will return an error?

A. INSERT INTO orders SELECT * FROM new_orders;

B. SELECT company, fname, lname, state FROM customer WHERE state = (SELECT state, zipcode FROM customer WHERE fname = "John");

C. DELETE FROM stock WHERE 0 = (SELECT count(*) FROM manufact WHERE manufact.manu_code = stock.manu_code)

D. UPDATE customer SET (address, city, state, zip) = (SELECT address, city, state, zip FROM newaddr WHERE newaddr.customer_num = customer.customer_num) WHERE customer_num IN (SELECT customer_num FROM newaddr);

From the items listed below, what is the smallest granularity of item which may be restored?

A. a single table

B. a single dbspace

C. an entire instance

D. a set of dbspaces

What functionality is exclusive to ontape (i.e. not present in onbar)?

A. Level 1 Backup of instance

B. Rename spaces during a restore

C. Applying a filter to the backup data

D. Back up the instance to standard out

What is the only isolation level available on an unlogged database?

A. Dirty Read

B. Cursor Stability

C. Committed Read

D. Repeatable Read

Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?

A. Offline

B. On-Line

C. Quiescent

D. Administrative