Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)   ​ADD
B)   ​UPDATE
C)   ​INSERT
D)   ​ENTERE) A) and D)
F) B) and C)

Question 3

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 aboveE) None of the above
F) A) and B)

Question 4

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 5

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) A) and D)
F) A) and C)

Question 6

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) None of the above
F) A) and B)

Question 7

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) B) and C)
F) A) and D)

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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.E) B) and D)
F) All of the above

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)   ​parenthesesE) B) and C)
F) C) and D)

Question 11

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) None of the above
F) A) and B)

Question 12

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 13

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 TABLEE) A) and B)
F) A) and D)

Question 14

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 15

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 16

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

Accepted Answer

A) True 
 B)False

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

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

Correct Answer
verified

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

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

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

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

Correct Answer
verified

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

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

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

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

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

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

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow 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

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

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

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

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

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

Correct Answer
verified

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

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

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

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

Correct Answer
verified

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

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

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

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

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