Question 1

What will happen if you try to use the INSERT command to insert a NULL value into a column that has been assigned a PRIMARY KEY constraint? ​

Accepted Answer

A)   ​The command will execute because a PRIMARY KEY value can be NULL.
B)   ​An error message is returned and the row is not added to the table.
C)   ​The command will execute because only a UNIQUE constraint forbids NULL values.
D)   ​An error message is returned but the unaffected portion of the row is added to the table.

Question 2

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

Question 3

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 above

Question 4

A table can be locked in SHARE MODE or EXCLUSIVE MODE._________________________​

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

If data is only being added to some of the columns in a table,the names of the columns must be listed in the VALUES clause.​

Accepted Answer

A) True 
 B)False

Question 7

Which of the following keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table?​

Accepted Answer

A)   ​INSERT
B)   ​INTO
C)   ​VALUES
D)   ​none of the above

Question 8

A substitution variable can be identified by the ____________________ symbol that precedes the variable name.​

Accepted Answer

The answer of A substitution variable can be identified by...

Question 9

A(n)exclusive lock is automatically obtained when the user executes the SELECT...FOR UPDATE command._________________________​

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

What is the difference between a standard SELECT statement and a SELECT...FOR UPDATE statement?​

Accepted Answer

The purpose of the standard SELECT state...

Question 12

The LOCK TABLE command can be used to prevent other users from making changes to a table.​

Accepted Answer

A) True 
 B)False

Question 13

The WHERE clause of the DELETE command is used to identify the rows to be deleted from the table.​

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

Which command is used to prevent other users from making changes to a table?

Accepted Answer

A)   ​COMMIT
B)   ​COMMIT TABLE
C)   ​BLOCK
D)   ​LOCK TABLE

Question 16

Which of the following commands is used to add rows to a table?​

Accepted Answer

A)   ​ADD
B)   ​UPDATE
C)   ​INSERT
D)   ​ENTER

Exam 5: Data Manipulation and Transaction Control

The WHERE clause of the DELETE command is used to identify the rows to be deleted from the table.

Correct Answer
verified

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

Correct Answer
verified

What will happen if you try to use the INSERT command to insert a NULL value into a column that has been assigned a PRIMARY KEY constraint?

Correct Answer
verified

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 Answer
verified

Which of the following keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table?

Correct Answer
verified

What is the difference between a standard SELECT statement and a SELECT...FOR UPDATE statement?

Correct Answer
verified
The purpose of the standard SELECT state...
View Answer

If data is only being added to some of the columns in a table,the names of the columns must be listed in the VALUES clause.

Correct Answer
verified

A(n)exclusive lock is automatically obtained when the user executes the SELECT...FOR UPDATE command._________________________

Correct Answer
verified

Which of the following commands is used to add rows to a table?

Correct Answer
verified

Which command is used to prevent other users from making changes to a table?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The LOCK TABLE command can be used to prevent other users from making changes to a table.

Correct Answer
verified

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

Correct Answer
verified

A substitution variable can be identified by the ____________________ symbol that precedes the variable name.

Correct Answer
verified

A table can be locked in SHARE MODE or EXCLUSIVE MODE._________________________

Correct Answer
verified

Exam 5: Data Manipulation and Transaction Control

The WHERE clause of the DELETE command is used to identify the rows to be deleted from the table.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What will happen if you try to use the INSERT command to insert a NULL value into a column that has been assigned a PRIMARY KEY constraint? ​

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

Which of the following keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table?​

Correct AnswerverifiedShow Answer

What is the difference between a standard SELECT statement and a SELECT...FOR UPDATE statement?​

Correct AnswerverifiedThe purpose of the standard SELECT state...View AnswerShow Answer

If data is only being added to some of the columns in a table,the names of the columns must be listed in the VALUES clause.​

Correct AnswerverifiedShow Answer

A(n)exclusive lock is automatically obtained when the user executes the SELECT...FOR UPDATE command._________________________​

Correct AnswerverifiedShow Answer

Which of the following commands is used to add rows to a table?​

Correct AnswerverifiedShow Answer

Which command is used to prevent other users from making changes to a table?

Correct AnswerverifiedShow Answer

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

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

The LOCK TABLE command can be used to prevent other users from making changes to a table.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A substitution variable can be identified by the ____________________ symbol that precedes the variable name.​

Correct AnswerverifiedShow Answer

A table can be locked in SHARE MODE or EXCLUSIVE MODE._________________________​

Correct AnswerverifiedShow Answer

The WHERE clause of the DELETE command is used to identify the rows to be deleted from the table.

Correct Answer
verified

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

Correct Answer
verified

What will happen if you try to use the INSERT command to insert a NULL value into a column that has been assigned a PRIMARY KEY constraint?

Correct Answer
verified

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 Answer
verified

Which of the following keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table?

Correct Answer
verified

What is the difference between a standard SELECT statement and a SELECT...FOR UPDATE statement?

Correct Answer
verified
The purpose of the standard SELECT state...
View Answer

If data is only being added to some of the columns in a table,the names of the columns must be listed in the VALUES clause.

Correct Answer
verified

A(n)exclusive lock is automatically obtained when the user executes the SELECT...FOR UPDATE command._________________________

Correct Answer
verified

Which of the following commands is used to add rows to a table?

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The LOCK TABLE command can be used to prevent other users from making changes to a table.

Correct Answer
verified

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

Correct Answer
verified

A substitution variable can be identified by the ____________________ symbol that precedes the variable name.

Correct Answer
verified

A table can be locked in SHARE MODE or EXCLUSIVE MODE._________________________

Correct Answer
verified