Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The ____________________ command is used to add new rows to a table.​

Accepted Answer

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

Question 3

When the UPDATE command is used to change existing data values,the ____________________ clause is used to specify the new data value and the column being changed.​

Accepted Answer

The answer of When the UPDATE command is used to...

Question 4

Which of the following commands allows a user to "undo" uncommitted changes to data?​

Accepted Answer

A)  ​UNDO 
B)  ​ROLLBACK 
C)  ​UNCOMMIT 
D)  ​UNLOCK 
A)  ​UNDO 
B)  ​ROLLBACK 
C)  ​UNCOMMIT 
D)  ​UNLOCK

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The rows to be deleted from a table are identified by the ____________________ clause of the DELETE command.​

Accepted Answer

The answer of The rows to be deleted from a...

Question 7

If the WHERE clause is omitted from the UPDATE command,then all columns in the table will be changed.​

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

If a(n)____________________ clause is not included in the UPDATE command,then all rows in the table will be changed.​

Accepted Answer

The answer of If a(n)____________________ clause is not included in...

Question 11

The ____ command will prevent two users from trying to make changes to the same table at the same time.​

Accepted Answer

A)  ​SHARED LOCK 
B)  ​EXCLUSIVE LOCK 
C)  ​LOCK TABLE 
D)  ​TABLE LOCK 
A)  ​SHARED LOCK 
B)  ​EXCLUSIVE LOCK 
C)  ​LOCK TABLE 
D)  ​TABLE LOCK

Question 12

A(n)exclusive lock prevents other users from changing the data stored in the table._________________________​

Accepted Answer

A) True 
 B)False

Question 13

If no value is assigned to a column when a row is added to a table,the column will contain a NULL value.​

Accepted Answer

A) True 
 B)False

Question 14

A deadlock occurs when two users hold shared locks on portions of a table that are needed to complete the transaction of the other user.​

Accepted Answer

A) True 
 B)False

Question 15

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 16

Which of the following will allow a user to enter a NULL value using the INSERT command?​

Accepted Answer

A)  ​Omit the column from the column list in the INSERT INTO clause. 
B)  ​Substitute two single quotation marks in the VALUES clause in the position of the column that is to be assigned the NULL value. 
C)  ​Use the NULL keyword. 
D)  ​all of the above 
A)  ​Omit the column from the column list in the INSERT INTO clause. 
B)  ​Substitute two single quotation marks in the VALUES clause in the position of the column that is to be assigned the NULL value. 
C)  ​Use the NULL keyword. 
D)  ​all of the above

Question 17

The ____________________ command will reverse all DML operators performed since the last COMMIT was performed.​

Accepted Answer

The answer of The ____________________ command will reverse all DML...

Question 18

The variable name of a substitution variable is preceded by a(n)percent sign._________________________​

Accepted Answer

A) True 
 B)False

Question 19

If more than one data value is being added to a table,the values must be separated by parentheses._________________________​

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

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

The ____________________ command is used to add new rows to a table.

When the UPDATE command is used to change existing data values,the ____________________ clause is used to specify the new data value and the column being changed.

Which of the following commands allows a user to "undo" uncommitted changes to data?

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

The rows to be deleted from a table are identified by the ____________________ clause of the DELETE command.

If the WHERE clause is omitted from the UPDATE command,then all columns in the table will be changed.

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

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 a(n)____________________ clause is not included in the UPDATE command,then all rows in the table will be changed.

The ____ command will prevent two users from trying to make changes to the same table at the same time.

A(n)exclusive lock prevents other users from changing the data stored in the table._________________________

If no value is assigned to a column when a row is added to a table,the column will contain a NULL value.

A deadlock occurs when two users hold shared locks on portions of a table that are needed to complete the transaction of the other user.

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

Which of the following will allow a user to enter a NULL value using the INSERT command?

The ____________________ command will reverse all DML operators performed since the last COMMIT was performed.

The variable name of a substitution variable is preceded by a(n)percent sign._________________________

If more than one data value is being added to a table,the values must be separated by parentheses._________________________

The ____________________ command is used to remove rows from a 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 transaction is defined as the set of statements that are committed at one time.​

The ____________________ command is used to add new rows to a table.​

When the UPDATE command is used to change existing data values,the ____________________ clause is used to specify the new data value and the column being changed.​

Which of the following commands allows a user to "undo" uncommitted changes to data?​

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

The rows to be deleted from a table are identified by the ____________________ clause of the DELETE command.​

If the WHERE clause is omitted from the UPDATE command,then all columns in the table will be changed.​

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

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 a(n)____________________ clause is not included in the UPDATE command,then all rows in the table will be changed.​

The ____ command will prevent two users from trying to make changes to the same table at the same time.​

A(n)exclusive lock prevents other users from changing the data stored in the table._________________________​

If no value is assigned to a column when a row is added to a table,the column will contain a NULL value.​

A deadlock occurs when two users hold shared locks on portions of a table that are needed to complete the transaction of the other user.​

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

Which of the following will allow a user to enter a NULL value using the INSERT command?​

The ____________________ command will reverse all DML operators performed since the last COMMIT was performed.​

The variable name of a substitution variable is preceded by a(n)percent sign._________________________​

If more than one data value is being added to a table,the values must be separated by parentheses._________________________​

The ____________________ command is used to remove rows from a 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

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

The ____________________ command is used to add new rows to a table.

When the UPDATE command is used to change existing data values,the ____________________ clause is used to specify the new data value and the column being changed.

Which of the following commands allows a user to "undo" uncommitted changes to data?

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

The rows to be deleted from a table are identified by the ____________________ clause of the DELETE command.

If the WHERE clause is omitted from the UPDATE command,then all columns in the table will be changed.

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

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 a(n)____________________ clause is not included in the UPDATE command,then all rows in the table will be changed.

The ____ command will prevent two users from trying to make changes to the same table at the same time.

A(n)exclusive lock prevents other users from changing the data stored in the table._________________________

If no value is assigned to a column when a row is added to a table,the column will contain a NULL value.

A deadlock occurs when two users hold shared locks on portions of a table that are needed to complete the transaction of the other user.

Which of the following will allow a user to enter a NULL value using the INSERT command?

The ____________________ command will reverse all DML operators performed since the last COMMIT was performed.

The variable name of a substitution variable is preceded by a(n)percent sign._________________________

If more than one data value is being added to a table,the values must be separated by parentheses._________________________

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