1. Which of the following will release a look currently held by a user on the HOMEWORK10 table?

A. A commit command is issued

B. A DCL command is issued to end a transaction

C. The user exits the system

D, A rollback command is issued

E. all of the above

F. none of the above

2. Assure that you have added eight new orders to the ORDERS table. Which following is true?

A. Other users can view the new orders as soon as you execute the INSERT INTO command

B. Other users can view the new orders as soon as you issue a ROLLBACK command

C. Other users can view the new orders as soon as you exit the system or execute a COMMIT comman

D. Other users can view only the new orders if they obtain an exclusive lock on the table

3. Which of the following is the standard extension used for a script file?

A. SPT

B. SRT

C. SCRIPT

D. SQL

4. Which is the maximum number of rows that can be deleted from a table at one time?

A. 1

B. 2

C. 3

D. Unlimited

5. Which of the following is a correct statement?

A. If you attempt to add a record that violates a constraint for on the table columns, the valid columns for the new row will be added.

B. A subquery nested in the VALUES clause of an INSERT INTO command can return only one value without generating an Oracle 10g error message

C. If you attempt a record that violates a NOT NULL constraint, a blank space will automatically be inserted in the appropriate column so Oracle 10g can complete the DML operation

D. None of the above statements is correct