Question 1

After a COMMIT command is executed, the $\underline {  \text { ROLLBACK }  }$command will have no affect on the changed data. _________________________

Accepted Answer

A) True 
 B)False

Question 2

The row(s)  to be updated by the UPDATE command is specified by the ____ clause.

Accepted Answer

A)   UPDATE
B)   SET
C)   WHERE
D)   COLE) C) and D)
F) B) and D)

Question 3

When the INSERT command is being used to enter data into a non-numeric column, the data must be enclosed in ____.

Accepted Answer

A)   parentheses
B)   double quotation marks
C)   single quotation marks
D)   upper-case lettersE) None of the above
F) B) and C)

Question 4

____________________ are automatically released when the user exits the system or executes a COMMIT or ROLLBACK command.

Accepted Answer

The answer of ____________________ are automatically released when the user...

Question 5

The $\underline { \text { COMMIT } }$ command is used to add new rows to a table. _________________________

Accepted Answer

A) True 
 B)False

Question 6

Contents of the PROMOTION table
 
-Based on the contents of the PROMOTION table, which of the following will correctly change the value assigned to the MAXRETAIL column for Free Shipping to 75.00?

Accepted Answer

A)   INSERT INTO promotion (maxretail) VALUES (75) WHERE gift = 'FREE SHIPPING';
B)   UPDATE promotion (maxretail) SET = 75WHERE gift = 'FREE SHIPPING';
C)   UPDATE promotionSET maxretail = 75WHERE gift = 'FREE SHIPPING';
D)   none of the aboveE) B) and D)
F) C) and D)

Question 7

When does a COMMIT command implicitly occur?

Accepted Answer

A)   When the user executes COMMIT;.
B)   When the user issues a DDL command such as CREATE or ALTER TABLE.
C)   When the user executes ROLLBACK;.
D)   When the computer loses power unexpectedly.E) B) and D)
F) B) and C)

Question 8

If more than one data value is being added to a table, the values must be separated by$\underline {\text { parentheses. } }$_________________________

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is not a valid SQL command?

Accepted Answer

A)   UPDATE acctmanager SET amedate = SYSDATE WHERE amid = 'J500';
B)   UPDATE acctmanager SET amname = UPPER(amname) ;
C)   UPDATE acctmanager SET amname = UPPER(amname)  WHERE amid = 'J500';
D)   UPDATE acctmanager WHERE amid = 'J500';E) B) and D)
F) None of the above

Question 10

The data values being added to a table with the INSERT command must be listed in the ____________________ clause.

Accepted Answer

The answer of The data values being added to a...

Question 11

A lock is automatically released when the user issues a transaction control statement such as COMMIT or $\underline { \text { ROLLBACK } }$. _________________________

Accepted Answer

A) True 
 B)False

Question 12

When the column names are listed in the INSERT INTO clause of the INSERT command, the order of the names must exactly match the order of the data values in the $\underline { \text { UPDATE } }$ clause. _________________________

Accepted Answer

A) True 
 B)False

Question 13

Contents of the PROMOTION table
 
-Based on the contents of the PROMOTION table, which of the following commands will delete only the row for the Free Bookmark from the table?

Accepted Answer

A)   DELETE FROM promotion;
B)   DELETE gift FROM promotion;
C)   DELETE gift FROM promotion WHERE gift = 'BOOKMARKER';
D)   DELETE FROM promotion WHERE gift = 'BOOKMARKER';E) All of the above
F) C) and D)

Question 14

Use the ____ keyword to enter the computer's date as a data value in the INSERT command.

Accepted Answer

A)   SYSTEMDATE
B)   DATE
C)   SYSDATE
D)   COMPDATEE) B) and D)
F) None of the above

Question 15

When does a COMMIT command explicitly occur?

Accepted Answer

A)   When the user executes COMMIT;.
B)   When the user issues a DDL command such as CREATE or ALTER TABLE.
C)   When the user executes ROLLBACK;.
D)   When the user exists the system.E) C) and D)
F) B) and C)

Question 16

A lock arising from a SELECT...FOR UPDATE command will be released when ____.

Accepted Answer

A)   a COMMIT command is executed
B)   a ROLLBACK command is executed
C)   an implicit commit occurs
D)   all of the aboveE) C) and D)
F) B) and D)

Question 17

Which of the following types of locks permits other users access to unlocked portions of a table?

Accepted Answer

A)   shared lock
B)   table lock
C)   exclusive lock
D)   partition lockE) A) and D)
F) None of the above

Question 18

______________________________ commands are used to modify data.

Accepted Answer

DML
Data m...

Question 19

If more than one column is listed in the INSERT INTO clause, the column names must be separated by ____.

Accepted Answer

A)   commas
B)   single quotation marks
C)   double quotation marks
D)   parenthesesE) A) and B)
F) A) and C)

Question 20

$\underline {\text { Transaction control }}$statements are used to either save modified data or to undo changes before they are committed. _________________________

Accepted Answer

A) True 
 B)False

Exam 5: Data Manipulation and Transaction Control

When does a COMMIT command implicitly occur?

Correct AnswerverifiedShow Answer

A lock arising from a SELECT...FOR UPDATE command will be released when ____.

Correct AnswerverifiedShow Answer

Contents of the PROMOTION table -Based on the contents of the PROMOTION table, which of the following commands will delete only the row for the Free Bookmark from the table?

Correct AnswerverifiedShow Answer

Which of the following is not a valid SQL command?

Correct AnswerverifiedShow Answer

Which of the following types of locks permits other users access to unlocked portions of a table?

Correct AnswerverifiedShow Answer

When the column names are listed in the INSERT INTO clause of the INSERT command, the order of the names must exactly match the order of the data values in the UPDATE ‾\underline { \text { UPDATE } } UPDATE ​ clause. _________________________

Correct AnswerverifiedShow Answer

____________________ are automatically released when the user exits the system or executes a COMMIT or ROLLBACK command.

Correct AnswerverifiedShow Answer

The data values being added to a table with the INSERT command must be listed in the ____________________ clause.

Correct AnswerverifiedShow Answer

______________________________ commands are used to modify data.

Correct AnswerverifiedDMLData m...View AnswerShow Answer

After a COMMIT command is executed, the ROLLBACK ‾\underline { \text { ROLLBACK } } ROLLBACK ​ command will have no affect on the changed data. _________________________

Correct AnswerverifiedShow Answer

The COMMIT ‾\underline { \text { COMMIT } } COMMIT ​ command is used to add new rows to a table. _________________________

Correct AnswerverifiedShow Answer

The row(s) to be updated by the UPDATE command is specified by the ____ clause.

Correct AnswerverifiedShow Answer

A lock is automatically released when the user issues a transaction control statement such as COMMIT or ROLLBACK ‾\underline { \text { ROLLBACK } } ROLLBACK ​ . _________________________

Correct AnswerverifiedShow Answer

If more than one data value is being added to a table, the values must be separated by parentheses. ‾\underline {\text { parentheses. } } parentheses. ​ _________________________

Correct AnswerverifiedShow Answer

Transaction control ‾\underline {\text { Transaction control }} Transaction control ​ statements are used to either save modified data or to undo changes before they are committed. _________________________

Correct AnswerverifiedShow Answer

When the INSERT command is being used to enter data into a non-numeric column, the data must be enclosed in ____.

Correct AnswerverifiedShow Answer

Use the ____ keyword to enter the computer's date as a data value in the INSERT command.

Correct AnswerverifiedShow Answer

Contents of the PROMOTION table -Based on the contents of the PROMOTION table, which of the following will correctly change the value assigned to the MAXRETAIL column for Free Shipping to 75.00?

Correct AnswerverifiedShow Answer

If more than one column is listed in the INSERT INTO clause, the column names must be separated by ____.

Correct AnswerverifiedShow Answer

When does a COMMIT command explicitly occur?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

When the column names are listed in the INSERT INTO clause of the INSERT command, the order of the names must exactly match the order of the data values in the $\underline { \text { UPDATE } }$ clause. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
DML
Data m...
View Answer

After a COMMIT command is executed, the $\underline { \text { ROLLBACK } }$ command will have no affect on the changed data. _________________________

Correct Answer
verified

The $\underline { \text { COMMIT } }$ command is used to add new rows to a table. _________________________

Correct Answer
verified

Correct Answer
verified

A lock is automatically released when the user issues a transaction control statement such as COMMIT or $\underline { \text { ROLLBACK } }$ . _________________________

Correct Answer
verified

If more than one data value is being added to a table, the values must be separated by $\underline {\text { parentheses. } }$ _________________________

Correct Answer
verified

$\underline {\text { Transaction control }}$ statements are used to either save modified data or to undo changes before they are committed. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified