Test: Quiz: Database Transactions

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 (*)
				Correct
		2.	COMMIT saves all outstanding data changes? True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		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.
				Correct
		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 (*)
				Correct
		5.	If Oracle crashes your changes are automatically rolled back. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		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;
				Correct
		7.	When you log out of Oracle, your data changes are automatically rolled back. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct

( Vrei sa traduci ceva?Want to translate something? http://translate.google.ro/# )