Question 1

A shared lock prevents another user from performing DDL or DML operations on the table.

Accepted Answer

A) True 
 B)False

Question 2

A transaction is defined as the set of statements that are committed at one time.

Accepted Answer

A) True 
 B)False

Question 3

The ____________________ command is used to remove rows from a table.

Accepted Answer

The answer of The ____________________ command is used to remove...

Question 4

Data that is being added to a table is specified in the $\underline { \text { VALUES } }$ clause of the INSERT command. _________________________

Accepted Answer

A) True 
 B)False

Question 5

The ____________________ keyword is not included in the INSERT command if the data is being retrieved from another database table.

Accepted Answer

The answer of The ____________________ keyword is not included in...

Question 6

Which of the following statements about the DELETE command is incorrect?

Accepted Answer

A)  The DELETE command applies to an entire row and cannot be applied to specific columns within a row. 
B)  The proper command syntax for the DELETE command is DELETE FROM tablename; 
C)  If you omit the optional WHERE clause, then all the rows in the table will be deleted. 
D)  If you omit the mandatory WHERE clause, an error message will be issued. 
A)  The DELETE command applies to an entire row and cannot be applied to specific columns within a row. 
B)  The proper command syntax for the DELETE command is DELETE FROM tablename; 
C)  If you omit the optional WHERE clause, then all the rows in the table will be deleted. 
D)  If you omit the mandatory WHERE clause, an error message will be issued.

Question 7

When the INSERT command is used to add rows to a table, the column names of the table must be specified.

Accepted Answer

A) True 
 B)False

Question 8

The SELECT .... ____________________ command is used to create a shared lock on a table to prevent other users from making changes in the specified column.

Accepted Answer

The answer of The SELECT .... ____________________ command is used...

Question 9

The SELECT...FOR UPDATE command will automatically obtain a(n) ____________________ lock on the row to be changed.

Accepted Answer

The answer of The SELECT...FOR UPDATE command will automatically obtain...

Question 10

Single-row functions cannot be included in the UPDATE command.

Accepted Answer

A) True 
 B)False

Question 11

Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns?

Accepted Answer

A)  SELECT...LOCK 
B)  SELECT...COMMIT 
C)  SELECT...FOR UPDATE 
D)  SELECT...FOR CHANGE 
A)  SELECT...LOCK 
B)  SELECT...COMMIT 
C)  SELECT...FOR UPDATE 
D)  SELECT...FOR CHANGE

Question 12

If a user has a shared lock on a table, this prevents another user from obtaining a(n) ____________________ lock on the same table.

Accepted Answer

The answer of If a user has a shared lock...

Question 13

When new rows are being added to a table, the actual data being added are listed in the ____ clause.

Accepted Answer

A)  INSERT INTO 
B)  DATA 
C)  VALUES 
D)  ADD 
A)  INSERT INTO 
B)  DATA 
C)  VALUES 
D)  ADD

Question 14

Regarding the INSERT statement, which of the following is correct?

Accepted Answer

A)  Non-numeric data is enclosed in single quotation marks. 
B)  Column names are enclosed in parentheses ( ). 
C)  The data values to be inserted are enclosed in parentheses ( ) after the VALUES keyword. 
D)  all of the above 
A)  Non-numeric data is enclosed in single quotation marks. 
B)  Column names are enclosed in parentheses ( ). 
C)  The data values to be inserted are enclosed in parentheses ( ) after the VALUES keyword. 
D)  all of the above

Question 15

The ____________________ TABLE command is used to prevent other users from making changes to a portion of a table.

Accepted Answer

The answer of The ____________________ TABLE command is used to...

Question 16

The variable name of a substitution variable is preceded by a(n) $\underline { \text { percent sign. } }$_________________________

Accepted Answer

A) True 
 B)False

Question 17

If a user has a shared lock on a table, this will prevent any other user from obtaining a shared or exclusive lock on the same table.

Accepted Answer

A) True 
 B)False

Question 18

The ____________________ keyword can be included in the INSERT command to enter the computer's date into the row when it is added to the table.

Accepted Answer

The answer of The ____________________ keyword can be included in...

Question 19

The MODIFY command can be used to change existing data stored in a table.

Accepted Answer

A) True 
 B)False

Question 20

The VALUES clause is not included with the INSERT command if the data is being retrieved from another table.

Accepted Answer

A) True 
 B)False

A shared lock prevents another user from performing DDL or DML operations on the table.

A transaction is defined as the set of statements that are committed at one time.

The ____________________ command is used to remove rows from a table.

Data that is being added to a table is specified in the $\underline { \text { VALUES } }$ clause of the INSERT command. _________________________

The ____________________ keyword is not included in the INSERT command if the data is being retrieved from another database table.

Which of the following statements about the DELETE command is incorrect?

When the INSERT command is used to add rows to a table, the column names of the table must be specified.

The SELECT .... ____________________ command is used to create a shared lock on a table to prevent other users from making changes in the specified column.

The SELECT...FOR UPDATE command will automatically obtain a(n) ____________________ lock on the row to be changed.

Single-row functions cannot be included in the UPDATE command.

Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns?

If a user has a shared lock on a table, this prevents another user from obtaining a(n) ____________________ lock on the same table.

When new rows are being added to a table, the actual data being added are listed in the ____ clause.

Regarding the INSERT statement, which of the following is correct?

The ____________________ TABLE command is used to prevent other users from making changes to a portion of a table.

The variable name of a substitution variable is preceded by a(n) $\underline { \text { percent sign. } }$ _________________________

If a user has a shared lock on a table, this will prevent any other user from obtaining a shared or exclusive lock on the same table.

The ____________________ keyword can be included in the INSERT command to enter the computer's date into the row when it is added to the table.

The MODIFY command can be used to change existing data stored in a table.

The VALUES clause is not included with the INSERT command if the data is being retrieved from another table.

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

A shared lock prevents another user from performing DDL or DML operations on the table.

A transaction is defined as the set of statements that are committed at one time.

The ____________________ command is used to remove rows from a table.

Data that is being added to a table is specified in the VALUES ‾\underline { \text { VALUES } } VALUES ​ clause of the INSERT command. _________________________

The ____________________ keyword is not included in the INSERT command if the data is being retrieved from another database table.

Which of the following statements about the DELETE command is incorrect?

When the INSERT command is used to add rows to a table, the column names of the table must be specified.

The SELECT .... ____________________ command is used to create a shared lock on a table to prevent other users from making changes in the specified column.

The SELECT...FOR UPDATE command will automatically obtain a(n) ____________________ lock on the row to be changed.

Single-row functions cannot be included in the UPDATE command.

Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns?

If a user has a shared lock on a table, this prevents another user from obtaining a(n) ____________________ lock on the same table.

When new rows are being added to a table, the actual data being added are listed in the ____ clause.

Regarding the INSERT statement, which of the following is correct?

The ____________________ TABLE command is used to prevent other users from making changes to a portion of a table.

The variable name of a substitution variable is preceded by a(n) percent sign. ‾\underline { \text { percent sign. } } percent sign. ​ _________________________

If a user has a shared lock on a table, this will prevent any other user from obtaining a shared or exclusive lock on the same table.

The ____________________ keyword can be included in the INSERT command to enter the computer's date into the row when it is added to the table.

The MODIFY command can be used to change existing data stored in a table.

The VALUES clause is not included with the INSERT command if the data is being retrieved from another table.

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

Data that is being added to a table is specified in the $\underline { \text { VALUES } }$ clause of the INSERT command. _________________________

The variable name of a substitution variable is preceded by a(n) $\underline { \text { percent sign. } }$ _________________________