Consider the following transactions, the statement rollback to savepoint M1 discards which operation ? DELETE INSERT Savepoint M1 UPDATE Savepoint M2 Rollback to Savepoint M1 O a. UPDATE O b. INSERT O c. DELETE O d. SAVEPOINT Which of the commands below will save the changes permanently after executing the below transactions? Update student set marks=90; Savepoint A; Delete from student; Savepoint B; O a. Grant O b. Commit O c. Revoke O d. Rollback

Consider the following transactions, the statement rollback to savepoint M1 discards which operation ? DELETE INSERT Savepoint M1 UPDATE Savepoint M2 Rollback to Savepoint M1 O a. UPDATE O b. INSERT O c. DELETE O d. SAVEPOINT Which of the commands below will save the changes permanently after executing the below transactions? Update student set marks=90; Savepoint A; Delete from student; Savepoint B; O a. Grant O b. Commit O c. Revoke O d. Rollback

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter5: Data Manipulation And Transaction Control

Section: Chapter Questions

Problem 1MC: Which of the following is a correct statement? a. A commit is issued implicitly when a user exits...

See similar textbooks

Similar questions

You issued the following command: DROP TABLE BOOKS; Which combination of three three statements are true? A. All uncommitted transactions are committed. B. All indexes and constraints defined on the table being dropped are also dropped. C. Sequences used in the Books table becomes invalid. D. The space used by the Books table is reclaimed immediately. E. The Books table can be recovered using the rollback command. F. The Books table is moved to the recycle bin. 1. A,B,F 2. A,C,F 3. A,D,E 4. B,C,D
Which of the following releases a lock currently held by a user on the HOMEWORK10 table?a. A COMMIT command is issued.b. A DDL command is issued to end a transaction.c. The user exits the system.d. A ROLLBACK command is issued.e. all of the abovef. none of the above
Which statement is not correct? The goal of batch controls is to endure that during processing a. Transactions are not omitted b. Transactions are processed more than once c. Transactions are not added d. An audit trial is created
Assume you have added eight new orders to the ORDERS table. Which of the 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 command.d. Other users can view the new orders only if they place an exclusive lock on the table.
Which of the following statements represents a correctly structured transaction? a.) BEGIN;COMMIT;insert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip');UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11; b.) BEGINinsert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip');UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11;COMMIT; c.) BEGINinsert into album (artist_id, title, album_id) values (1, 'My Album', 348)insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip')UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11COMMIT d.) BEGIN;insert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert…
Which of the following statements is true?a. A gap can appear in a sequence created with the NOCACHE option if the system crashes before a user can commit a transaction.b. Any unassigned sequence values appears in the USER_SEQUENCE data dictionary table as unassigned.c. Only the user who creates a sequence is allowed to delete it.d. Only the user who created a sequence is allowed to use the value enerated by the sequence.
You accidentally deleted all the orders in the ORDERS table. How can the error be corrected after a COMMIT command has been issued?a. ROLLBACK;b. ROLLBACK COMMIT;c. REGENERATE RECORDS orders;d. None of the above restores the deleted orders
75. ______________ rolls back all transactions that were incomplete at the time of crash. a. Analysis pass b. Redo pass c. Undo pass d. None of the mentioned
16. Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read? a. Nonrepeatable read b. Phantom read c. Dirty read d. Consistent read
30. A shared lock allows which of the following types of transactions to occur? a. Delete b. Insert c. Read d. Update
Which of the following has no partial dependencies but can contain transitive dependencies? a. unnormalized data b. 1NF c. 2NF d. 3NF
Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.