Question 1

When does a COMMIT command explicitly occur?​

Accepted Answer

A)  ​When the user executes COMMIT;. 
B)  ​When the user issues a DDL command such as CREATE or ALTER TABLE. 
C)  ​When the user executes ROLLBACK;. 
D)  ​When the user exists the system. 
A)  ​When the user executes COMMIT;. 
B)  ​When the user issues a DDL command such as CREATE or ALTER TABLE. 
C)  ​When the user executes ROLLBACK;. 
D)  ​When the user exists the system.

Question 2

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

Accepted Answer

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

Question 3

When the INSERT command is being used to enter data into a non-numeric column,the data must be enclosed in ____.​

Accepted Answer

A)  ​parentheses 
B)  ​double quotation marks 
C)  ​single quotation marks 
D)  ​upper-case letters 
A)  ​parentheses 
B)  ​double quotation marks 
C)  ​single quotation marks 
D)  ​upper-case letters

Question 4

​When does a COMMIT command implicitly occur?

Accepted Answer

A)  ​When the user executes COMMIT;. 
B)  ​When the user issues a DDL command such as CREATE or ALTER TABLE. 
C)  ​When the user executes ROLLBACK;. 
D)  ​When the computer loses power unexpectedly. 
A)  ​When the user executes COMMIT;. 
B)  ​When the user issues a DDL command such as CREATE or ALTER TABLE. 
C)  ​When the user executes ROLLBACK;. 
D)  ​When the computer loses power unexpectedly.

Question 5

The ____ command can be used to view the contents of a record when it is anticipated that the record will need to be modified.It places a shared lock on the record(s)to be changed and prevents any other user from acquiring a lock on the same record(s).​

Accepted Answer

A)  ​SELECT...LOCK TABLE 
B)  ​COMMIT...LOCK TABLE 
C)  ​SELECT...FOR UPDATE 
D)  ​COMMIT...FOR UPDATE 
A)  ​SELECT...LOCK TABLE 
B)  ​COMMIT...LOCK TABLE 
C)  ​SELECT...FOR UPDATE 
D)  ​COMMIT...FOR UPDATE

Question 6

When ____________________ operations are performed,an exclusive lock is automatically placed on the specified table.​

Accepted Answer

The answer of When ____________________ operations are performed,an exclusive lock...

Question 7

____________________ are automatically released when the user exits the system or executes a COMMIT or ROLLBACK command.​

Accepted Answer

The answer of ____________________ are automatically released when the user...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which of the following types of locks permits other users access to unlocked portions of a table?

Accepted Answer

A)  ​shared lock 
B)  ​table lock 
C)  ​exclusive lock 
D)  ​partition lock 
A)  ​shared lock 
B)  ​table lock 
C)  ​exclusive lock 
D)  ​partition lock

Question 10

The ____________________ command is used to "undo" changes that have not yet been committed.​

Accepted Answer

The answer of The ____________________ command is used to "undo"...

Question 11

A value must be provided in an INSERT statement for a virtual column.​

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

A user who is issuing DML commands can save modified data or undo uncommitted changes by issuing ____ statements.​

Accepted Answer

A)  ​transaction control 
B)  ​database control 
C)  ​data manipulation 
D)  ​rollback control 
A)  ​transaction control 
B)  ​database control 
C)  ​data manipulation 
D)  ​rollback control

Question 15

The ROLLBACK command is used to permanently save changed data.​

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  ​The DELETE command applies to an entire row and cannot be applied to specific columns within a row. 
B)  ​The proper command syntax for the DELETE command is DELETE FROM tablename; 
C)  ​If you omit the optional WHERE clause,then all the rows in the table will be deleted. 
D)  ​If you omit the mandatory WHERE clause,an error message will be issued. 
A)  ​The DELETE command applies to an entire row and cannot be applied to specific columns within a row. 
B)  ​The proper command syntax for the DELETE command is DELETE FROM tablename; 
C)  ​If you omit the optional WHERE clause,then all the rows in the table will be deleted. 
D)  ​If you omit the mandatory WHERE clause,an error message will be issued.

Question 17

The ____________________ keyword can be included in the INSERT command to enter the computer's date into the row when it is added to the table.​

Accepted Answer

The answer of The ____________________ keyword can be included in...

Question 18

The USER_TAB_COLUMNS data dictionary object may be used to identify columns that are assigned an ON NULL clause.​

Accepted Answer

A) True 
 B)False

Question 19

What is the difference between a shared and exclusive lock​?

Accepted Answer

A shared lock allows other users to view

Question 20

When new rows are being added to a table,the actual data being added are listed in the ____ clause.​

Accepted Answer

A)  ​INSERT INTO 
B)  ​DATA 
C)  ​VALUES 
D)  ​ADD 
A)  ​INSERT INTO 
B)  ​DATA 
C)  ​VALUES 
D)  ​ADD

When does a COMMIT command explicitly occur?

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

When the INSERT command is being used to enter data into a non-numeric column,the data must be enclosed in ____.

When does a COMMIT command implicitly occur?

The ____ command can be used to view the contents of a record when it is anticipated that the record will need to be modified.It places a shared lock on the record(s)to be changed and prevents any other user from acquiring a lock on the same record(s).

When ____________________ operations are performed,an exclusive lock is automatically placed on the specified table.

____________________ are automatically released when the user exits the system or executes a COMMIT or ROLLBACK command.

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

Which of the following types of locks permits other users access to unlocked portions of a table?

The ____________________ command is used to "undo" changes that have not yet been committed.

A value must be provided in an INSERT statement for a virtual column.

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

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

A user who is issuing DML commands can save modified data or undo uncommitted changes by issuing ____ statements.

The ROLLBACK command is used to permanently save changed data.

Which of the following statements about the DELETE command is incorrect?

The ____________________ keyword can be included in the INSERT command to enter the computer's date into the row when it is added to the table.

The USER_TAB_COLUMNS data dictionary object may be used to identify columns that are assigned an ON NULL clause.

What is the difference between a shared and exclusive lock?

When new rows are being added to a table,the actual data being added are listed in the ____ clause.

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

When does a COMMIT command explicitly occur?​

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

When the INSERT command is being used to enter data into a non-numeric column,the data must be enclosed in ____.​

​When does a COMMIT command implicitly occur?

The ____ command can be used to view the contents of a record when it is anticipated that the record will need to be modified.It places a shared lock on the record(s)to be changed and prevents any other user from acquiring a lock on the same record(s).​

When ____________________ operations are performed,an exclusive lock is automatically placed on the specified table.​

____________________ are automatically released when the user exits the system or executes a COMMIT or ROLLBACK command.​

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

Which of the following types of locks permits other users access to unlocked portions of a table?

The ____________________ command is used to "undo" changes that have not yet been committed.​

A value must be provided in an INSERT statement for a virtual column.​

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

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

A user who is issuing DML commands can save modified data or undo uncommitted changes by issuing ____ statements.​

The ROLLBACK command is used to permanently save changed data.​

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

The ____________________ keyword can be included in the INSERT command to enter the computer's date into the row when it is added to the table.​

The USER_TAB_COLUMNS data dictionary object may be used to identify columns that are assigned an ON NULL clause.​

What is the difference between a shared and exclusive lock​?

When new rows are being added to a table,the actual data being added are listed in the ____ clause.​

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

When does a COMMIT command explicitly occur?

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

When the INSERT command is being used to enter data into a non-numeric column,the data must be enclosed in ____.

When does a COMMIT command implicitly occur?

The ____ command can be used to view the contents of a record when it is anticipated that the record will need to be modified.It places a shared lock on the record(s)to be changed and prevents any other user from acquiring a lock on the same record(s).

When ____________________ operations are performed,an exclusive lock is automatically placed on the specified table.

____________________ are automatically released when the user exits the system or executes a COMMIT or ROLLBACK command.

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

The ____________________ command is used to "undo" changes that have not yet been committed.

A value must be provided in an INSERT statement for a virtual column.

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

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

A user who is issuing DML commands can save modified data or undo uncommitted changes by issuing ____ statements.

The ROLLBACK command is used to permanently save changed data.

Which of the following statements about the DELETE command is incorrect?

The ____________________ keyword can be included in the INSERT command to enter the computer's date into the row when it is added to the table.

The USER_TAB_COLUMNS data dictionary object may be used to identify columns that are assigned an ON NULL clause.

What is the difference between a shared and exclusive lock?

When new rows are being added to a table,the actual data being added are listed in the ____ clause.