Question 1

The$\underline { \text { UPDATE } }$command can be used to change data stored in a table. _________________________

Accepted Answer

A) True 
 B)False

Question 2

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 3

When data is added to a database table, it is automatically converted to upper-case letters.

Accepted Answer

A) True 
 B)False

Question 4

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

Question 5

Contents of the PUBLISHER table
  
-Based on the contents of the PUBLISHER table, which of the following SQL statements will change the phone number for Printing Is Us to 800-714-8321?

Accepted Answer

A)  UPDATE publisher REPLACE phone WITH '800-714-8321'
WHERE pubid = 1; 
B)  UPDATE publisher REPLACE phone = '800-714-8321'
WHERE pubid = 1; 
C)  UPDATE publisher SET phone = '800-714-8321'
WHERE pubid = 1; 
D)  none of the above 
A)  UPDATE publisher REPLACE phone WITH '800-714-8321'
WHERE pubid = 1; 
B)  UPDATE publisher REPLACE phone = '800-714-8321'
WHERE pubid = 1; 
C)  UPDATE publisher SET phone = '800-714-8321'
WHERE pubid = 1; 
D)  none of the above

Question 6

Contents of the PROMOTION table
  
-If a new row is added to the PROMOTION table, which of the following will make the change permanent?

Accepted Answer

A)  COMMIT; 
B)  UPDATE; 
C)  ROLLBACK; 
D)  The change is permanent when the command is executed. 
A)  COMMIT; 
B)  UPDATE; 
C)  ROLLBACK; 
D)  The change is permanent when the command is executed.

Question 7

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 8

A(n) ____ lock will prevent any DDL operations from being performed on the locked table.

Accepted Answer

A)  shared 
B)  exclusive 
C)  partial 
D)  partitioned 
A)  shared 
B)  exclusive 
C)  partial 
D)  partitioned

Question 9

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 10

The column to be updated by the UPDATE command is specified in the ____ clause.

Accepted Answer

A)  UPDATE 
B)  SET 
C)  WHERE 
D)  COL 
A)  UPDATE 
B)  SET 
C)  WHERE 
D)  COL

Question 11

The ROLLBACK command is used to permanently save changed data.

Accepted Answer

A) True 
 B)False

Question 12

When DDL operations are performed, Oracle11g will automatically place a(n) $\underline {\text { shared } }$ lock on the table. _________________________

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

If the WHERE clause is omitted from the UPDATE command, then all columns in the table will be changed.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ____ in a SQL command instructs Oracle11g 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 16

Which of the following clauses of the UPDATE command is optional?

Accepted Answer

A)  UPDATE 
B)  SET 
C)  WHERE 
D)  none of the above 
A)  UPDATE 
B)  SET 
C)  WHERE 
D)  none of the above

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

The INSERT command is used to modify existing data in a row.

Accepted Answer

A) True 
 B)False

Question 19

The BLOCK ACCESS command can be used to prevent other users from updating a specific table.

Accepted Answer

A) True 
 B)False

Question 20

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

The $\underline { \text { UPDATE } }$ command can be used to change data stored in a table. _________________________

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

When data is added to a database table, it is automatically converted to upper-case letters.

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

Contents of the PUBLISHER table -Based on the contents of the PUBLISHER table, which of the following SQL statements will change the phone number for Printing Is Us to 800-714-8321?

Contents of the PROMOTION table -If a new row is added to the PROMOTION table, which of the following will make the change permanent?

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

A(n) ____ lock will prevent any DDL operations from being performed on the locked table.

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

The column to be updated by the UPDATE command is specified in the ____ clause.

The ROLLBACK command is used to permanently save changed data.

When DDL operations are performed, Oracle11g will automatically place a(n) $\underline {\text { shared } }$ lock on the table. _________________________

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

If the WHERE clause is omitted from the UPDATE command, then all columns in the table will be changed.

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

Which of the following clauses of the UPDATE command is optional?

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

The INSERT command is used to modify existing data in a row.

The BLOCK ACCESS command can be used to prevent other users from updating a specific table.

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

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

The UPDATE ‾\underline { \text { UPDATE } } UPDATE ​ command can be used to change data stored in a table. _________________________

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

When data is added to a database table, it is automatically converted to upper-case letters.

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

Contents of the PUBLISHER table -Based on the contents of the PUBLISHER table, which of the following SQL statements will change the phone number for Printing Is Us to 800-714-8321?

Contents of the PROMOTION table -If a new row is added to the PROMOTION table, which of the following will make the change permanent?

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

A(n) ____ lock will prevent any DDL operations from being performed on the locked table.

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

The column to be updated by the UPDATE command is specified in the ____ clause.

The ROLLBACK command is used to permanently save changed data.

When DDL operations are performed, Oracle11g will automatically place a(n) shared ‾\underline {\text { shared } } shared ​ lock on the table. _________________________

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

If the WHERE clause is omitted from the UPDATE command, then all columns in the table will be changed.

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

Which of the following clauses of the UPDATE command is optional?

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

The INSERT command is used to modify existing data in a row.

The BLOCK ACCESS command can be used to prevent other users from updating a specific table.

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

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

The $\underline { \text { UPDATE } }$ command can be used to change data stored in a table. _________________________

When DDL operations are performed, Oracle11g will automatically place a(n) $\underline {\text { shared } }$ lock on the table. _________________________

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