Exam 5: Data Manipulation and Transaction Control

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 INSERT command is used to modify existing data in a row.​

Which of the following clauses of the UPDATE command is optional?​

An ON NULL clause may be used in conjunction with a column's DEFAULT option.​

The SYSDATE keyword cannot be included in the INSERT command,only the UPDATE command.​

The ____________________ command is used to permanently update a table and allow other users to view the changed data.​

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

The effect of which of the following commands can never be reversed by the ROLLBACK command?​

Commands used to modify data are known as DML commands.​

A(n)shared lock prevents other users from obtaining another shared lock on the same table._________________________​

Commands used to modify data are called ____ commands.​

If the WHERE clause is omitted from the DELETE command,then all columns from the database table will be dropped._________________________​

Contents of the PROMOTION table​ ​ -If a new row is added to the PROMOTION table,which of the following will make the change permanent?​

Contents of the PUBLISHER table​ -If a column named SAL_PCT is to be defined to ensure a value of 100 is input if a NULL value is provided when a new row is inserted,which column definition should be used?​

If the ____ clause of the UPDATE command is omitted,then all the rows in the specified table will be changed.​

A shared lock is automatically obtained when the SELECT...FOR UPDATE command is executed.​

The SELECT...FOR UPDATE can be used to create a shared lock._________________________

The BLOCK ACCESS command can be used to prevent other users from updating a specific table.​

Data that is being added to a table is specified in the VALUES clause of the INSERT command._________________________

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