Question 1

Which of the following statements about COMMIT and ROLLBACK commands is incorrect?

Accepted Answer

A)  All DML commands (INSERT, UPDATE, DELET
E)  are explicitly committed and cannot be rolled back. 
B)  All DDL commands (CREATE, TRUNCATE, ALTER TABL
E)  are explicitly committed and cannot be rolled back. 
C)  A ROLLBACK command will reverse all DML operations performed since the last COMMIT was performed. 
D)  all of the above 
A)  All DML commands (INSERT, UPDATE, DELET
E)  are explicitly committed and cannot be rolled back. 
B)  All DDL commands (CREATE, TRUNCATE, ALTER TABL
E)  are explicitly committed and cannot be rolled back. 
C)  A ROLLBACK command will reverse all DML operations performed since the last COMMIT was performed. 
D)  all of the above

Question 2

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 3

If a table already exists, what command would you issue to add copies of existing rows from one table to the other?

Accepted Answer

A)  INSERT command with an UPDATE clause 
B)  INSERT command with a SET clause 
C)  INSERT command with a subquery 
D)  none of the above 
A)  INSERT command with an UPDATE clause 
B)  INSERT command with a SET clause 
C)  INSERT command with a subquery 
D)  none of the above

Question 4

The SET clause of the UPDATE command is used to identify the column(s) being updated.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

A)  DELETE 
B)  DROP 
C)  REMOVE 
D)  MODIFY 
A)  DELETE 
B)  DROP 
C)  REMOVE 
D)  MODIFY

Question 7

Which of the following commands is used to modify existing data in a table?

Accepted Answer

A)  ADD 
B)  UPDATE 
C)  INSERT 
D)  MODIFY 
A)  ADD 
B)  UPDATE 
C)  INSERT 
D)  MODIFY

Question 8

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

The $\underline { \text { VALUES } }$clause of the UPDATE command is used to specify the columns being updated and the new data values. _________________________

Accepted Answer

A) True 
 B)False

Question 11

When including a subquery in an INSERT command, the syntax of enclosing the subquery in parentheses is$\underline { \text { nandatory } }$ _________________________

Accepted Answer

A) True 
 B)False

Question 12

The$\underline {\text { WHERE }  }$clause of the UPDATE command is used to specify exactly which rows should be changed. _________________________

Accepted Answer

A) True 
 B)False

Question 13

Rows can be deleted from a table using the ____________________ command.

Accepted Answer

The answer of Rows can be deleted from a table...

Question 14

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 15

A(n) $\underline { \text { exclusive } }$ lock is automatically obtained when the user executes the SELECT...FOR UPDATE command. _________________________

Accepted Answer

A) True 
 B)False

Question 16

If the WHERE clause of the DELETE command is omitted, then all rows in the referenced table will be removed.

Accepted Answer

A) True 
 B)False

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

What is the difference between a shared and exclusive lock?

Accepted Answer

A shared lock allows other users to view

Question 19

Contents of the PUBLISHER table
  
-Which of the following commands will delete only publisher 4 from the PUBLISHER table?

Accepted Answer

A)  DELETE FROM publisher; 
B)  DELETE pubid = 4 FROM publisher; 
C)  DROP FROM publisher WHERE pubid = 4; 
D)  DELETE FROM publisher WHERE pubid = 4; 
A)  DELETE FROM publisher; 
B)  DELETE pubid = 4 FROM publisher; 
C)  DROP FROM publisher WHERE pubid = 4; 
D)  DELETE FROM publisher WHERE pubid = 4;

Question 20

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

Accepted Answer

The purpose of the standard SELECT state

Which of the following statements about COMMIT and ROLLBACK commands is incorrect?

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

If a table already exists, what command would you issue to add copies of existing rows from one table to the other?

The SET clause of the UPDATE command is used to identify the column(s) being updated.

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

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

Which of the following commands is used to modify existing data in 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 keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table?

The $\underline { \text { VALUES } }$ clause of the UPDATE command is used to specify the columns being updated and the new data values. _________________________

When including a subquery in an INSERT command, the syntax of enclosing the subquery in parentheses is $\underline { \text { nandatory } }$ _________________________

The $\underline {\text { WHERE } }$ clause of the UPDATE command is used to specify exactly which rows should be changed. _________________________

Rows can be deleted from a table using the ____________________ command.

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

A(n) $\underline { \text { exclusive } }$ lock is automatically obtained when the user executes the SELECT...FOR UPDATE command. _________________________

If the WHERE clause of the DELETE command is omitted, then all rows in the referenced table will be removed.

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

What is the difference between a shared and exclusive lock?

Contents of the PUBLISHER table -Which of the following commands will delete only publisher 4 from the PUBLISHER table?

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

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

Which of the following statements about COMMIT and ROLLBACK commands is incorrect?

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

If a table already exists, what command would you issue to add copies of existing rows from one table to the other?

The SET clause of the UPDATE command is used to identify the column(s) being updated.

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

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

Which of the following commands is used to modify existing data in 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 keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table?

The VALUES ‾\underline { \text { VALUES } } VALUES ​ clause of the UPDATE command is used to specify the columns being updated and the new data values. _________________________

When including a subquery in an INSERT command, the syntax of enclosing the subquery in parentheses is nandatory ‾\underline { \text { nandatory } } nandatory ​ _________________________

The WHERE ‾\underline {\text { WHERE } } WHERE ​ clause of the UPDATE command is used to specify exactly which rows should be changed. _________________________

Rows can be deleted from a table using the ____________________ command.

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

A(n) exclusive ‾\underline { \text { exclusive } } exclusive ​ lock is automatically obtained when the user executes the SELECT...FOR UPDATE command. _________________________

If the WHERE clause of the DELETE command is omitted, then all rows in the referenced table will be removed.

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

What is the difference between a shared and exclusive lock?

Contents of the PUBLISHER table -Which of the following commands will delete only publisher 4 from the PUBLISHER table?

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

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 $\underline { \text { VALUES } }$ clause of the UPDATE command is used to specify the columns being updated and the new data values. _________________________

When including a subquery in an INSERT command, the syntax of enclosing the subquery in parentheses is $\underline { \text { nandatory } }$ _________________________

The $\underline {\text { WHERE } }$ clause of the UPDATE command is used to specify exactly which rows should be changed. _________________________

A(n) $\underline { \text { exclusive } }$ lock is automatically obtained when the user executes the SELECT...FOR UPDATE command. _________________________