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.

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.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter5: Data Manipulation And Transaction Control

Section: Chapter Questions

Problem 12MC

See similar textbooks

Similar questions

Execute a command that undoes the previous deletion.
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
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…
If there is a database by the name StudentMarks in MongoDB then you can use use StudentMarks command to switch that database and start working on this database. But let’s assume that there is no database by the name StudentMarks in MongoDB. In this case if you still prefer use StudentMarks command than can be still OK and create the database and switch to it or would this command cause an error?Explain what happens in both scenarios?
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
(a) Which command makes updates permanent?(b) Which command reverses updates? (c) Which updates are reversed?
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.
Consider the following command:UPDATE order_details SET quantity = quantity --10 What happens if we run this command in MySQL? a.) An error is thrown due to the --. b.) The quantity in the order_details table for all records is decremented by 10. c.) The order_details table has all of the quantity set to the same value as it previously had. d.) The quantity in the order_details table for all records is incremented by 10.
Which of the following statements represents a correctly structured transaction? BEGINUPDATE trackset media_type_id = 1where album_id = 3DELETE FROM playlistWHERE playlist_id = 1INSERT INTO genre (genre_id, name)VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock')COMMIT UPDATE trackset media_type_id = 1where album_id = 3;DELETE FROM playlistWHERE playlist_id = 1;INSERT INTO genre (genre_id, name)VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock');COMMIT; BEGIN;UPDATE trackset media_type_id = 1where album_id = 3;DELETE FROM playlistWHERE playlist_id = 1;INSERT INTO genre (genre_id, name)VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock');COMMIT; BEGIN;COMMIT;UPDATE trackset media_type_id = 1where album_id = 3;DELETE FROM playlistWHERE playlist_id = 1;INSERT INTO genre (genre_id, name)VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock');
Which of the following is true?a. All data in a table can be recovered if the table is dropped with the PURGE option.b. All data in a table can be recovered from the recycle bin if the table is dropped.c. All data in a table is lost if the table is dropped.d. All of the above statements are true.
Write a cron job that executes the command, sudo mysqldump --all-databases at 11:59 pm on Sunday every week of the month.