Question 1

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 D

Question 2

Which keyword permanently saves changed data in a table?

Accepted Answer

A)  COMMIT 
B)  SAVE 
C)  UPDATE 
D)  ADD 
A)  COMMIT 
B)  SAVE 
C)  UPDATE 
D)  ADD A

Question 3

A substitution variable can be identified by the ____________________ symbol that precedes the variable name.

Accepted Answer

&
ampersand

Question 4

A table can be locked in $\underline { \text { SHARE MODE } }$ or EXCLUSIVE MODE. _________________________

Accepted Answer

A) True 
 B)False

Question 5

Which of the following statements about the INSERT keyword is incorrect?

Accepted Answer

A)  The keywords INSERT INTO are followed by the table name. 
B)  The VALUES clause identifies the data values that will be inserted into the table... 
C)  Oracle11g does not allow column names to be omitted from the INSERT INTO clause.. 
D)  If more than one column is listed, column names must be separated by commas., 
A)  The keywords INSERT INTO are followed by the table name. 
B)  The VALUES clause identifies the data values that will be inserted into the table... 
C)  Oracle11g does not allow column names to be omitted from the INSERT INTO clause.. 
D)  If more than one column is listed, column names must be separated by commas.,

Question 6

A subquery can be used with the INSERT command to enter data from an existing table into the destination table.

Accepted Answer

A) True 
 B)False

Question 7

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 8

When inserting a row into a table, how can you indicate that a row contains a NULL value?

Accepted Answer

A)  In the VALUES clause, substitute two single quotation marks for the NULL value. 
B)  In the VALUES clause, include the keyword NULL in the position where the value should be listed. 
C)  In the VALUES clause, include a blank space in the position where the value should be listed. 
D)  both a and b 
A)  In the VALUES clause, substitute two single quotation marks for the NULL value. 
B)  In the VALUES clause, include the keyword NULL in the position where the value should be listed. 
C)  In the VALUES clause, include a blank space in the position where the value should be listed. 
D)  both a and b

Question 9

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

Question 10

If data is only being added to some of the columns in a table, the names of the columns must be listed in the VALUES clause.

Accepted Answer

A) True 
 B)False

Question 11

Which command is used to prevent other users from making changes to a table?

Accepted Answer

A)  COMMIT 
B)  COMMIT TABLE 
C)  BLOCK 
D)  LOCK TABLE 
A)  COMMIT 
B)  COMMIT TABLE 
C)  BLOCK 
D)  LOCK TABLE

Question 12

If no value is assigned to a column when a row is added to a table, the column will contain a NULL value.

Accepted Answer

A) True 
 B)False

Question 13

When Oracle11g 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 14

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

Accepted Answer

A) True 
 B)False

Question 15

A $\underline { \text { 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 16

Commands used to modify data are known as DML commands.

Accepted Answer

A) True 
 B)False

Question 17

If a(n) ____________________ clause is not included in the UPDATE command, then all rows in the table will be changed.

Accepted Answer

The answer of If a(n) ____________________ clause is not included...

Question 18

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 19

A COMMIT is $\underline {  \text { explicitly }  }$ issued when the user exits SQL*Plus. _________________________

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

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

Which keyword permanently saves changed data in a table?

A substitution variable can be identified by the ____________________ symbol that precedes the variable name.

A table can be locked in $\underline { \text { SHARE MODE } }$ or EXCLUSIVE MODE. _________________________

Which of the following statements about the INSERT keyword is incorrect?

A subquery can be used with the INSERT command to enter data from an existing table into the destination table.

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

When inserting a row into a table, how can you indicate that a row contains a NULL value?

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

If data is only being added to some of the columns in a table, the names of the columns must be listed in the VALUES clause.

Which command is used to prevent other users from making changes to a table?

If no value is assigned to a column when a row is added to a table, the column will contain a NULL value.

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

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

A $\underline { \text { NULL} }$ value can be included in the data being added to a table by explicitly entering the word NULL. _________________________

Commands used to modify data are known as DML commands.

If a(n) ____________________ clause is not included in the UPDATE command, then all rows in the table will be changed.

Which of the following is a valid statement?

A COMMIT is $\underline { \text { explicitly } }$ issued when the user exits SQL*Plus. _________________________

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

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 data is being entered into a VARCHAR2 or CHAR column using the INSERT command, the data will be stored in ____.

Which keyword permanently saves changed data in a table?

A substitution variable can be identified by the ____________________ symbol that precedes the variable name.

A table can be locked in SHARE MODE ‾\underline { \text { SHARE MODE } } SHARE MODE ​ or EXCLUSIVE MODE. _________________________

Which of the following statements about the INSERT keyword is incorrect?

A subquery can be used with the INSERT command to enter data from an existing table into the destination table.

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

When inserting a row into a table, how can you indicate that a row contains a NULL value?

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

If data is only being added to some of the columns in a table, the names of the columns must be listed in the VALUES clause.

Which command is used to prevent other users from making changes to a table?

If no value is assigned to a column when a row is added to a table, the column will contain a NULL value.

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

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

A NULL‾\underline { \text { NULL} } NULL​ value can be included in the data being added to a table by explicitly entering the word NULL. _________________________

Commands used to modify data are known as DML commands.

If a(n) ____________________ clause is not included in the UPDATE command, then all rows in the table will be changed.

Which of the following is a valid statement?

A COMMIT is explicitly ‾\underline { \text { explicitly } } explicitly ​ issued when the user exits SQL*Plus. _________________________

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

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

A table can be locked in $\underline { \text { SHARE MODE } }$ or EXCLUSIVE MODE. _________________________

A $\underline { \text { NULL} }$ value can be included in the data being added to a table by explicitly entering the word NULL. _________________________

A COMMIT is $\underline { \text { explicitly } }$ issued when the user exits SQL*Plus. _________________________