Question 1

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)  COMPDATE 
A)  SYSTEMDATE 
B)  DATE 
C)  SYSDATE 
D)  COMPDATE

Question 2

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 3

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 above 
A)  a COMMIT command is executed 
B)  a ROLLBACK command is executed 
C)  an implicit commit occurs 
D)  all of the above

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 letters 
A)  parentheses 
B)  double quotation marks 
C)  single quotation marks 
D)  upper-case letters

Question 6

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 7

____________________ 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 8

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. 
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.

Question 9

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

Accepted Answer

A)  UPDATE 
B)  SET 
C)  WHERE 
D)  COL 
A)  UPDATE 
B)  SET 
C)  WHERE 
D)  COL

Question 10

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 11

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 12

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 = 75
WHERE gift = 'FREE SHIPPING'; 
C)  UPDATE promotion
SET maxretail = 75
WHERE gift = 'FREE SHIPPING'; 
D)  none of the above 
A)  INSERT INTO promotion (maxretail)
VALUES (75)
WHERE gift = 'FREE SHIPPING'; 
B)  UPDATE promotion (maxretail)
SET = 75
WHERE gift = 'FREE SHIPPING'; 
C)  UPDATE promotion
SET maxretail = 75
WHERE gift = 'FREE SHIPPING'; 
D)  none of the above

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'; 
A)  DELETE FROM promotion; 
B)  DELETE gift FROM promotion; 
C)  DELETE gift FROM promotion WHERE gift = 'BOOKMARKER'; 
D)  DELETE FROM promotion WHERE gift = 'BOOKMARKER';

Question 14

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 15

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)  parentheses 
A)  commas 
B)  single quotation marks 
C)  double quotation marks 
D)  parentheses

Question 16

$\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

Question 17

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'; 
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';

Question 18

______________________________ commands are used to modify data.

Accepted Answer

DML
Data m

Question 19

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 lock 
A)  shared lock 
B)  table lock 
C)  exclusive lock 
D)  partition lock

Question 20

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. 
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.

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

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. _________________________

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

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

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

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

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

When does a COMMIT command explicitly occur?

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

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

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

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?

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?

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

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

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

Which of the following is not a valid SQL command?

______________________________ commands are used to modify data.

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

When does a COMMIT command implicitly occur?

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 5: Data Manipulation and Transaction Control

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

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. _________________________

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

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

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

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

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

When does a COMMIT command explicitly occur?

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

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

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

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?

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?

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

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

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

Which of the following is not a valid SQL command?

______________________________ commands are used to modify data.

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

When does a COMMIT command implicitly occur?

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

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. _________________________

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

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

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

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

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