先試後買

A. DECLARE my_cur CURSOR FOR SELECT * FROM orders GROUP BY 1 FOR UPDATE;

B. DECLARE my_cur CURSOR FOR SELECT * FROM orders WHERE order_date <= today - 30 FOR UPDATE;

C. DECLARE my_cur CURSOR FOR SELECT * FROM orders, customer FOR UPDATE;

D. DECLARE my_cur CURSOR FOR SELECT * FROM orders ORDER BY 1 FOR UPDATE;

A. A user with DBA privilege can alter, drop, or rename any database object.

B. Owner of a table can transfer ownership to another user.

C. RESOURCE privilege has all the capabilities of a CONNECT privilege.

D. User Informix can grant DBA privilege to a role.

E. A user would need RESOURCE privilege to run SET SESSION AUTHORIZATION statement.

A. All rows from customer table will be retrieved into cust_temp table.

B. A locking error.

C. Error indicating Temp table (cust_temp) already exists.

D. SELECT query will wait till SESSION_1 has ended.

A. 4

B. 6

C. 2

D. 3

A. REPEATABLE READ

B. DIRTY READ

C. COMMITTED READ

D. CURSOR STABILITY

A. It checks for locks after returning a row.

B. It checks for locks before returning a row.

C. It does not check for locks.

D. It locks all rows examined.

A. exclusive lock

B. implicit lock

C. promotable lock

D. shared lock

A. Lock the table in exclusive mode for the whole transaction OR use repeatable read isolation level for the whole transaction.

B. Lock the table in shared mode for the whole transaction OR use committed read isolation level for the whole transaction.

C. Lock the table in exclusive mode for the whole transaction OR use committed read isolation level for the whole transaction.

D. Lock the table in shared mode for the whole transaction OR use repeatable read isolation level for the whole transaction.

A. Hold

B. Persistent

C. Scroll

D. Fetch