Exam 5: Data Manipulation and Transaction Control

When the column names are listed in the INSERT INTO clause of the INSERT command,the order of the names must exactly match the order of the data values in the UPDATE clause._________________________​

Which of the following statements about the INSERT keyword is incorrect?​

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

Explain the difference between an implicit and an explicit COMMIT.​

If one of the data values being entered into a table by the INSERT command violates an existing constraint,the remaining portion of the row will be added,but the data violating the constraint will need to be added at a later time using the UPDATE command.​

A lock is automatically released when the user issues a transaction control statement such as COMMIT or ROLLBACK._________________________​

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

Contents of the PUBLISHER table​ -Based on the contents of the PUBLISHER table,which of the following SQL statements will change the phone number for Printing Is Us to 800-714-8321?​

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

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

When including a subquery in an INSERT command,the syntax of enclosing the subquery in parentheses is mandatory._________________________​

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

Which of the following statements about the UPDATE command is incorrect?​

The ____________________ command is used to change data stored in a table.​

​A subquery can be used with the INSERT command to enter data from an existing table into the destination table.

The DROP command can be used to remove rows from an existing table._________________________

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

When inserting a row into a table,how can you indicate that a row contains a NULL value?​

The UPDATE command can be used to add data to existing rows in a table.​

The column to be updated by the UPDATE command is specified in the ____ clause.​