Question 1

After a COMMIT command is executed,the ROLLBACK command will have no affect on the changed data._________________________​

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

When non-numeric data is being added to a table,the data must be enclosed in ____________________ quotation marks.​

Accepted Answer

The answer of When non-numeric data is being added to...

Question 4

When Oracle 12c encounters a substitution variable,the user will be prompted for the actual value to be assigned to the variable.

Accepted Answer

A) True 
 B)False

Question 5

The UPDATE command can be used to change data stored in a table._________________________​

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  ​DELETE 
B)  ​DROP 
C)  ​REMOVE 
D)  ​MODIFY 
A)  ​DELETE 
B)  ​DROP 
C)  ​REMOVE 
D)  ​MODIFY

Question 7

A(n)____________________ lock will allow other users to view the data stored in the table,but it prevents anyone from altering the structure of the table.​

Accepted Answer

The answer of A(n)____________________ lock will allow other users to...

Question 8

A(n)____ in a SQL command instructs Oracle 12c to use a substituted value in place of the variable at the time the command is actually executed.​

Accepted Answer

A)  ​substitution value 
B)  ​substitution clause 
C)  ​substitution variable 
D)  ​substitution condition 
A)  ​substitution value 
B)  ​substitution clause 
C)  ​substitution variable 
D)  ​substitution condition

Question 9

Contents of the PUBLISHER table​
  
-Based on the contents of the PUBLISHER table,which of the following will add a new record to the table?

Accepted Answer

A)  ​INSERT INTO publisher
VALUES ('BOOKS MADE CHEAP','800-111-2222'); 
B)  ​INSERT INTO publisher (pubid,name)
VALUES (6,'BOOKS MADE CHEAP'); 
C)  ​UPDATE publisher
VALUES ('BOOKS MADE CHEAP','800-111-2222'); 
D)  ​UPDATE publisher (pubid,name)
VALUES (6,'BOOKS MADE CHEAP'); 
A)  ​INSERT INTO publisher
VALUES ('BOOKS MADE CHEAP','800-111-2222'); 
B)  ​INSERT INTO publisher (pubid,name)
VALUES (6,'BOOKS MADE CHEAP'); 
C)  ​UPDATE publisher
VALUES ('BOOKS MADE CHEAP','800-111-2222'); 
D)  ​UPDATE publisher (pubid,name)
VALUES (6,'BOOKS MADE CHEAP');

Question 10

​The data being inserted into a table are listed in the ADD clause of the INSERT command.

Accepted Answer

A) True 
 B)False

Question 11

If a table already exists,what command would you issue to add copies of existing rows from one table to the other?​

Accepted Answer

A)  ​INSERT command with an UPDATE clause 
B)  ​INSERT command with a SET clause 
C)  ​INSERT command with a subquery 
D)  ​none of the above 
A)  ​INSERT command with an UPDATE clause 
B)  ​INSERT command with a SET clause 
C)  ​INSERT command with a subquery 
D)  ​none of the above

Question 12

When a subquery is used in the INSERT command,the subquery does not have to be enclosed in parentheses.​

Accepted Answer

A) True 
 B)False

Question 13

When data is being entered into a VARCHAR2 or CHAR column using the INSERT command,the data will be stored in ____.​

Accepted Answer

A)  ​upper-case characters 
B)  ​lower-case characters 
C)  ​the default case setting for the table 
D)  ​the same case used in the INSERT command 
A)  ​upper-case characters 
B)  ​lower-case characters 
C)  ​the default case setting for the table 
D)  ​the same case used in the INSERT command

Question 14

If the WHERE clause of the DELETE command is omitted,then all rows in the referenced table will be removed.​

Accepted Answer

A) True 
 B)False

Question 15

The ____________________ TABLE command is used to prevent other users from making changes to a portion of a table.​

Accepted Answer

The answer of The ____________________ TABLE command is used to...

Question 16

Which of the following is a valid statement?​

Accepted Answer

A)  ​When rows are added to a table,the column names can be omitted if an entry is only being made into the first column. 
B)  ​When rows are added to a table,the column names can be omitted if the values are listed in the same order as the columns are listed in the table. 
C)  ​If rows are being added to a table with the UPDATE command,an entry must be made into each column contained in the table. 
D)  ​none of the above 
A)  ​When rows are added to a table,the column names can be omitted if an entry is only being made into the first column. 
B)  ​When rows are added to a table,the column names can be omitted if the values are listed in the same order as the columns are listed in the table. 
C)  ​If rows are being added to a table with the UPDATE command,an entry must be made into each column contained in the table. 
D)  ​none of the above

Question 17

The duration of a(n)____________________ is defined by when a COMMIT implicitly or explicitly occurs.​

Accepted Answer

The answer of The duration of a(n)____________________ is defined by...

Question 18

Which of the following statements about substitution variables is incorrect?​

Accepted Answer

A)  ​They allow you to add records to a table without issuing the same command again and again. 
B)  ​A substitution variable is identified by an ampersand and the variable name. 
C)  ​When Oracle10g executes a command with a substitution variable,it will prompt the user to enter a value. 
D)  ​The command SET VERIFY OFF will delete all values stored in substitution variables. 
A)  ​They allow you to add records to a table without issuing the same command again and again. 
B)  ​A substitution variable is identified by an ampersand and the variable name. 
C)  ​When Oracle10g executes a command with a substitution variable,it will prompt the user to enter a value. 
D)  ​The command SET VERIFY OFF will delete all values stored in substitution variables.

Question 19

An explicit commit is issued when the user executes a COMMIT; command.​

Accepted Answer

A) True 
 B)False

Question 20

The ____________________ command is used to add data to an existing row in a table.​

Accepted Answer

The answer of The ____________________ command is used to add...

After a COMMIT command is executed,the ROLLBACK command will have no affect on the changed data._________________________

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

When non-numeric data is being added to a table,the data must be enclosed in ____________________ quotation marks.

When Oracle 12c encounters a substitution variable,the user will be prompted for the actual value to be assigned to the variable.

The UPDATE command can be used to change data stored in a table._________________________

Which of the following commands is used to remove rows from a table?

A(n)____________________ lock will allow other users to view the data stored in the table,but it prevents anyone from altering the structure of the table.

A(n)____ in a SQL command instructs Oracle 12c to use a substituted value in place of the variable at the time the command is actually executed.

Contents of the PUBLISHER table -Based on the contents of the PUBLISHER table,which of the following will add a new record to the table?

The data being inserted into a table are listed in the ADD clause of the INSERT command.

If a table already exists,what command would you issue to add copies of existing rows from one table to the other?

When a subquery is used in the INSERT command,the subquery does not have to be enclosed in parentheses.

When data is being entered into a VARCHAR2 or CHAR column using the INSERT command,the data will be stored in ____.

If the WHERE clause of the DELETE command is omitted,then all rows in the referenced table will be removed.

The ____________________ TABLE command is used to prevent other users from making changes to a portion of a table.

Which of the following is a valid statement?

The duration of a(n)____________________ is defined by when a COMMIT implicitly or explicitly occurs.

Which of the following statements about substitution variables is incorrect?

An explicit commit is issued when the user executes a COMMIT; command.

The ____________________ command is used to add data to an existing row in a table.

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

After a COMMIT command is executed,the ROLLBACK command will have no affect on the changed data._________________________​

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

When non-numeric data is being added to a table,the data must be enclosed in ____________________ quotation marks.​

When Oracle 12c encounters a substitution variable,the user will be prompted for the actual value to be assigned to the variable.

The UPDATE command can be used to change data stored in a table._________________________​

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

A(n)____________________ lock will allow other users to view the data stored in the table,but it prevents anyone from altering the structure of the table.​

A(n)____ in a SQL command instructs Oracle 12c to use a substituted value in place of the variable at the time the command is actually executed.​

Contents of the PUBLISHER table​ -Based on the contents of the PUBLISHER table,which of the following will add a new record to the table?

​The data being inserted into a table are listed in the ADD clause of the INSERT command.

If a table already exists,what command would you issue to add copies of existing rows from one table to the other?​

When a subquery is used in the INSERT command,the subquery does not have to be enclosed in parentheses.​

When data is being entered into a VARCHAR2 or CHAR column using the INSERT command,the data will be stored in ____.​

If the WHERE clause of the DELETE command is omitted,then all rows in the referenced table will be removed.​

The ____________________ TABLE command is used to prevent other users from making changes to a portion of a table.​

Which of the following is a valid statement?​

The duration of a(n)____________________ is defined by when a COMMIT implicitly or explicitly occurs.​

Which of the following statements about substitution variables is incorrect?​

An explicit commit is issued when the user executes a COMMIT; command.​

The ____________________ command is used to add data to an existing row in a table.​

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

After a COMMIT command is executed,the ROLLBACK command will have no affect on the changed data._________________________

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

When non-numeric data is being added to a table,the data must be enclosed in ____________________ quotation marks.

The UPDATE command can be used to change data stored in a table._________________________

Which of the following commands is used to remove rows from a table?

A(n)____________________ lock will allow other users to view the data stored in the table,but it prevents anyone from altering the structure of the table.

A(n)____ in a SQL command instructs Oracle 12c to use a substituted value in place of the variable at the time the command is actually executed.

Contents of the PUBLISHER table -Based on the contents of the PUBLISHER table,which of the following will add a new record to the table?

The data being inserted into a table are listed in the ADD clause of the INSERT command.

If a table already exists,what command would you issue to add copies of existing rows from one table to the other?

When a subquery is used in the INSERT command,the subquery does not have to be enclosed in parentheses.

When data is being entered into a VARCHAR2 or CHAR column using the INSERT command,the data will be stored in ____.

If the WHERE clause of the DELETE command is omitted,then all rows in the referenced table will be removed.

The ____________________ TABLE command is used to prevent other users from making changes to a portion of a table.

Which of the following is a valid statement?

The duration of a(n)____________________ is defined by when a COMMIT implicitly or explicitly occurs.

Which of the following statements about substitution variables is incorrect?

An explicit commit is issued when the user executes a COMMIT; command.

The ____________________ command is used to add data to an existing row in a table.