Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
Section 1
1.You need not worry about controlling your transactions. Oracle does it all for you. True or False?Mark for Review (1) Points
True
False (*)
2.COMMIT saves all outstanding data changes? True or False?Mark for Review (1) Points
True (*)
False
3.Examine the following Statement: INSERT INTO emps SELECT * FROM employees; -- 107 rows inserted. SAVEPOINT Ins_Done; CREATE INDEX emp_lname_idx ON employees(last_name); UPDATE emps SET last_name = 'Smith'; What happens if you issue a Rollback statement?Mark for Review (1) Points
The update of last_name is undone, but the insert was committed by the CREATE INDEX statement. (*)
Both the UPDATE and the INSERT will be rolled back.
The INSERT is undone but the UPDATE is committed
Nothing happens.
4.As soon as UserA has entered data into a table UserB has privileges to see, UserB can see that data. True or False?Mark for Review (1) Points
True
False (*)
5.If Oracle crashes your changes are automatically rolled back. True or False?Mark for Review (1) Points
True (*)
False
6.Examine the following statements: INSERT INTO emps SELECT * FROM employees; -- 107 rows inserted. SAVEPOINT Ins_Done; DELETE employees; -- 107 rows deleted SAVEPOINT Del_Done; UPDATE emps SET last_name = 'Smith'; How would you undo the last Update only?Mark for Review (1) Points
Rollback update;
Rollback to savepoint Del_Done; (*)
There is nothing you can do.
Commit until Del_Done;
7.When you log out of Oracle, your data changes are automatically rolled back. True or False?Mark for Review (1) Points
True
False (*)