Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

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 6

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

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 
A)  ​INSERT 
B)  ​INTO 
C)  ​VALUES 
D)  ​none of the above

Question 10

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 
A)  ​COMMIT 
B)  ​COMMIT TABLE 
C)  ​BLOCK 
D)  ​LOCK TABLE

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

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 14

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

Accepted Answer

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

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

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

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

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

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

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

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.

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?

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

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

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?

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

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?

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

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

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

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

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

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

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

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

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

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

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

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? ​

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

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

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?​

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

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?​

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

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

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

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

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

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

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

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

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

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

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.

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?

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

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

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?

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?

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

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

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

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

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