Question 1

Commands used to modify data are called ____ commands.

Accepted Answer

A)  data control language (DCL) 
B)  data manipulation language (DML) 
C)  data modification language (DML) 
D)  data definition language (DDL) 
A)  data control language (DCL) 
B)  data manipulation language (DML) 
C)  data modification language (DML) 
D)  data definition language (DDL)

Question 2

The SYSDATE keyword cannot be included in the INSERT command, only the UPDATE command.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following will allow a user to enter a NULL value using the INSERT command?

Accepted Answer

A)  Omit the column from the column list in the INSERT INTO clause. 
B)  Substitute two single quotation marks in the VALUES clause in the position of the column that is to be assigned the NULL value. 
C)  Use the NULL keyword. 
D)  all of the above 
A)  Omit the column from the column list in the INSERT INTO clause. 
B)  Substitute two single quotation marks in the VALUES clause in the position of the column that is to be assigned the NULL value. 
C)  Use the NULL keyword. 
D)  all of the above

Question 4

Explain the difference between an implicit and an explicit COMMIT.

Accepted Answer

An explicit COMMIT occurs when

Question 5

Which of the following is not a valid SQL command?

Accepted Answer

A)  INSERT INTO acctmantable
SELECT amid, amname, amedate, region
FROM acctmanager
WHERE amedate <= SYSDATE; 
B)  INSERT INTO acctmantable
(SELECT amid, amname, amedate, region
FROM acctmanager
WHERE amedate <= SYSDAT
E) ; 
C)  INSERT INTO acctmantable
AS (SELECT amid, amname, amedate, region
FROM acctmanager
WHERE amedate <= SYSDAT
E) ; 
D)  none of the above 
A)  INSERT INTO acctmantable
SELECT amid, amname, amedate, region
FROM acctmanager
WHERE amedate <= SYSDATE; 
B)  INSERT INTO acctmantable
(SELECT amid, amname, amedate, region
FROM acctmanager
WHERE amedate <= SYSDAT
E) ; 
C)  INSERT INTO acctmantable
AS (SELECT amid, amname, amedate, region
FROM acctmanager
WHERE amedate <= SYSDAT
E) ; 
D)  none of the above

Question 6

A(n) $\underline {\text { implicit } }$commit is issued when the user enters and executes COMMIT; in SQL*Plus. _________________________

Accepted Answer

A) True 
 B)False

Question 7

The $\underline { \text { DROP } }$ command can be used to remove rows from an existing table. _________________________

Accepted Answer

A) True 
 B)False

Question 8

The LOCK TABLE command can be used to prevent other users from making changes to a table.

Accepted Answer

A) True 
 B)False

Question 9

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.

Accepted Answer

A) True 
 B)False

Question 10

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 11

Which of the following commands is used to add data to an existing row in a table?

Accepted Answer

A)  ADD 
B)  UPDATE 
C)  INSERT 
D)  MODIFY 
A)  ADD 
B)  UPDATE 
C)  INSERT 
D)  MODIFY

Question 12

A(n) $\underline { \text { exclusive lock } }$prevents other users from changing the data stored in the table. _________________________

Accepted Answer

A) True 
 B)False

Commands used to modify data are called ____ commands.

The SYSDATE keyword cannot be included in the INSERT command, only the UPDATE command.

Which of the following will allow a user to enter a NULL value using the INSERT command?

Explain the difference between an implicit and an explicit COMMIT.

Which of the following is not a valid SQL command?

A(n) $\underline {\text { implicit } }$ commit is issued when the user enters and executes COMMIT; in SQL*Plus. _________________________

The $\underline { \text { DROP } }$ command can be used to remove rows from an existing table. _________________________

The LOCK TABLE command can be used to prevent other users from making changes to a table.

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.

Which of the following statements about substitution variables is incorrect?

Which of the following commands is used to add data to an existing row in a table?

A(n) $\underline { \text { exclusive lock } }$ prevents other users from changing the data stored in the 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

Commands used to modify data are called ____ commands.

The SYSDATE keyword cannot be included in the INSERT command, only the UPDATE command.

Which of the following will allow a user to enter a NULL value using the INSERT command?

Explain the difference between an implicit and an explicit COMMIT.

Which of the following is not a valid SQL command?

A(n) implicit ‾\underline {\text { implicit } } implicit ​ commit is issued when the user enters and executes COMMIT; in SQL*Plus. _________________________

The DROP ‾\underline { \text { DROP } } DROP ​ command can be used to remove rows from an existing table. _________________________

The LOCK TABLE command can be used to prevent other users from making changes to a table.

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.

Which of the following statements about substitution variables is incorrect?

Which of the following commands is used to add data to an existing row in a table?

A(n) exclusive lock ‾\underline { \text { exclusive lock } } exclusive lock ​ prevents other users from changing the data stored in the 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

A(n) $\underline {\text { implicit } }$ commit is issued when the user enters and executes COMMIT; in SQL*Plus. _________________________

The $\underline { \text { DROP } }$ command can be used to remove rows from an existing table. _________________________

A(n) $\underline { \text { exclusive lock } }$ prevents other users from changing the data stored in the table. _________________________