SAIT Database D&P - Chapter 5(Course - Introduction to Oracle: SQL and PL/SQL Textbook - Oracle 12c: SQL by Joan Casteel (978-1-305-25103-8))Graded A+

A NULL value can be included in the data being added to a table by explicitly entering the word NULL. True 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. False If more than one data value is being added to a table, the values must be separated by parentheses. False A subquery can be used with the INSERT command to enter data from an existing table into the destination table. True If the WHERE clause is omitted from the DELETE command, then all columns from the database table will be dropped. False Data that is being added to a table is specified in the VALUES clause of the INSERT command. True The UPDATE command can be used to change data stored in a table. True When a subquery is used in the INSERT command, the subquery does not have to be enclosed in parentheses. True The VALUES clause of the UPDATE command is used to specify the columns being updated and the new data values. False 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. True The USER_TAB_COLUMNS data dictionary object may be used to identify columns that are assigned an ON NULL clause. True The DROP command can be used to remove rows from an existing table. False 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. False A lock is automatically released when the user issues a transaction control statement such as COMMIT or ROLLBACK. True A(n) exclusive lock prevents other users from changing the data stored in the table. True The LOCK TABLE command can be used to prevent other users from making changes to a table. True After a COMMIT command is executed, the ROLLBACK command will have no affect on the changed data. True A shared lock prevents another user from performing DDL or DML operations on the table. False Single-row functions cannot be included in the UPDATE command. False A shared lock is automatically obtained when the SELECT...FOR UPDATE command is executed. True The VALUES clause is not included with the INSERT command if the data is being retrieved from another table. True When Oracle 12c encounters a substitution variable, the user will be prompted for the actual value to be assigned to the variable. True If non-numeric data is being added to a column, the data must be enclosed in double quotation marks. False The WHERE clause of the DELETE command is used to identify the rows to be deleted from the table. True When does a COMMIT command explicitly occur? ​When the user executes COMMIT;. Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns? ​SELECT...FOR UPDATE