SQL -Structured Query Language - SQL View - Delete View Quiz

Show entries

Search:

#	Quiz
1 Discuss	Delete View A _________ consists of a sequence of query and/or update statements. 1] Transaction 2] Commit 3] Rollback 4] Flashback Solution
10 Discuss	Delete View ______ will undo all statements up to commit? 1] Transaction 2] Flashback 3] Rollback 4] Abort Solution
2 Discuss	Delete View Which of the following makes the transaction permanent in the database? 1] View 2] Commit 3] Rollback 4] Flashback Solution
3 Discuss	Delete View In order to undo the work of transaction after last commit which one should be used? 1] View 2] Commit 3] Rollback 4] Flashback Solution
4 Discuss	Delete View Consider the following action: `TRANSACTION..... Commit; ROLLBACK;` What does Rollback do? 1] Undoes the transactions before commit 2] Clears all transactions 3] Redoes the transactions before commit 4] No action Solution
5 Discuss	Delete View In case of any shut down during transaction before commit which of the following statement is done automatically? 1] View 2] Commit 3] Rollback 4] Flashback Solution
6 Discuss	Delete View In order to maintain the consistency during transactions, database provides 1] Commit 2] Atomic 3] Flashback 4] Retain Solution
7 Discuss	Delete View Transaction processing is associated with everything below except 1] Conforming an action or triggering a response 2] Producing detail summary or exception report 3] Recording a business activity 4] Maintaining a data Solution
8 Discuss	Delete View A transaction completes its execution is said to be 1] Committed 2] Aborted 3] Rolled back 4] Failed Solution
9 Discuss	Delete View Which of the following is used to get back all the transactions back after rollback? 1] Commit 2] Rollback 3] Flashback 4] Redo Solution
#	Quiz

Showing 1 to 10 of 10 entries

About Fresherbell

Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique

Important Links

Don't hesitate to give us a call or send us a contact form message

Terms & Conditions
Privacy Policy
Contact Us

Social Media