Question 1

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

Accepted Answer

ampersand

Question 2

When DDL operations are performed,Oracle 12c will automatically place a(n)shared lock on the table._________________________

Accepted Answer

exclusive

Question 3

A(n)exclusive lock is automatically obtained when the user executes the SELECT...FOR UPDATE command._________________________

Accepted Answer

shared

Question 4

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

Accepted Answer

rows

Question 5

A(n)implicit commit is issued when the user enters and executes COMMIT; in SQL*Plus._________________________

Accepted Answer

explicit

Question 6

A table can be locked in SHARE MODE or EXCLUSIVE MODE._________________________

Accepted Answer

A table can indeed be locked in SHARE MODE or EXCLUSIVE MODE. SHARE MODE allows multiple sessions to read the table simultaneously, while EXCLUSIVE MODE allows only one session to read or write to the table at a time.

Question 7

The SYSDATE keyword can be used in the INSERT command to enter the computer's system date when adding a row to a table._________________________

Accepted Answer

The SYSDATE keyword is used to insert the system date and time when adding a row to a table.

Question 8

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

Accepted Answer

optional

Question 9

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

Accepted Answer

The INSERT command is used to add new rows to a table. ADD, UPDATE, and ENTER are not valid commands for adding rows to a table in SQL.

Question 10

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

Accepted Answer

An exclusive lock prevents any other users from accessing or modifying the data in the table.

Question 11

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

Accepted Answer

exclusive

Question 12

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

Accepted Answer

VALUES

Question 13

If the SET clause of the UPDATE command is omitted,then all rows in the table will be updated with the new data value._________________________

Accepted Answer

WHERE

Question 14

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

Accepted Answer

When a transaction is committed or rolled back, the lock on the resources accessed by the transaction is released.

Question 15

The WHERE clause of the UPDATE command is used to specify exactly which rows should be changed._________________________

Accepted Answer

The WHERE clause is used to filter the rows to be updated based on certain conditions specified, making it possible to change only certain rows in a table. Therefore, the statement "The WHERE clause of the UPDATE command is used to specify exactly which rows should be changed" is true.

Question 16

A COMMIT is explicitly issued when the user exits SQL*Plus._________________________

Accepted Answer

implicitly

Question 17

Transaction control statements are used to either save modified data or to undo changes before they are committed._________________________

Accepted Answer

Transaction control statements such as COMMIT and ROLLBACK are used to control the changes made to data and either save or undo them before they are committed to the database.

Question 18

A NULL value can be included in the data being added to a table by explicitly entering the word NULL._________________________

Accepted Answer

True, NULL can be explicitly entered into a table as a value.

Question 19

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

Accepted Answer

The UPDATE command is used to modify existing data in a table. It allows you to update one or more rows in a table, and you can specify which columns and values you want to update. The other options are not used for modifying existing data in a table. ADD is used to add new columns to a table, INSERT is used to add new rows to a table, and MODIFY is not a valid SQL command.

Question 20

The VALUES clause of the UPDATE command is used to specify the columns being updated and the new data values._________________________

Accepted Answer

SET

Quiz 5: Data Manipulation and Transaction Control

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

When DDL operations are performed,Oracle 12c will automatically place a(n)shared lock on the table._________________________​

A(n)exclusive lock is automatically obtained when the user executes the SELECT...FOR UPDATE command._________________________​

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

A(n)implicit commit is issued when the user enters and executes COMMIT; in SQL*Plus._________________________​

A table can be locked in SHARE MODE or EXCLUSIVE MODE._________________________​

The SYSDATE keyword can be used in the INSERT command to enter the computer's system date when adding a row to a table._________________________​

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

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

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

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

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

If the SET clause of the UPDATE command is omitted,then all rows in the table will be updated with the new data value._________________________​

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

The WHERE clause of the UPDATE command is used to specify exactly which rows should be changed._________________________​

A COMMIT is explicitly issued when the user exits SQL*Plus._________________________​

Transaction control statements are used to either save modified data or to undo changes before they are committed._________________________​

A NULL value can be included in the data being added to a table by explicitly entering the word NULL._________________________​