Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns?​

Accepted Answer

A)   ​SELECT...LOCK
B)   ​SELECT...COMMIT
C)   ​SELECT...FOR UPDATE
D)   ​SELECT...FOR CHANGEE) A) and B)
F) All of the above

Question 3

Commands used to modify data are known as DML commands.​

Accepted Answer

A) True 
 B)False

Question 4

Contents of the PUBLISHER table​
 
-If a column named SAL_PCT is to be defined to ensure a value of 100 is input if a NULL value is provided when a new row is inserted,which column definition should be used?​

Accepted Answer

A)   ​SAL_PCT NULL 100 DEFAULT.
B)   ​SAL_PCT DEFAULT ON NULL 100.
C)   ​SAL_PCT DEFAULT 100.
D)   ​SAL_PCT ON NULL 100.E) None of the above
F) B) and C)

Question 5

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) E) All of the above
F) None of the above

Question 6

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

Accepted Answer

A)   ​UPDATE
B)   ​SET
C)   ​WHERE
D)   ​none of the aboveE) A) and B)
F) C) and D) C

Question 7

A(n)shared lock prevents other users from obtaining another shared lock on the same table._________________________​

Accepted Answer

A) True 
 B)False

Question 8

The SET clause of the UPDATE command is used to identify the column(s)being updated.​

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

The SELECT ....____________________ command is used to create a shared lock on a table to prevent other users from making changes in the specified column.​

Accepted Answer

FOR UPDATE​

Question 11

The effect of which of the following commands can never be reversed by the ROLLBACK command?​

Accepted Answer

A)   ​CREATE TABLE
B)   ​ALTER TABLE
C)   ​COMMIT
D)   ​all of the aboveE) B) and D)
F) B) and C)

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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.E) A) and B)
F) B) and C)

Question 14

Data that is being added to a table is specified in the VALUES clause of the INSERT command._________________________

Accepted Answer

A) True 
 B)False

Question 15

A shared lock is automatically obtained when the SELECT...FOR UPDATE command is executed.​

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False  False

Question 17

The SELECT...FOR UPDATE can be used to create a shared lock._________________________

Accepted Answer

A) True 
 B)False

Question 18

If the ____ clause of the UPDATE command is omitted,then all the rows in the specified table will be changed.​

Accepted Answer

A)   ​UPDATE
B)   ​SET
C)   ​WHERE
D)   ​none of the aboveE) None of the above
F) C) and D)

Question 19

An ON NULL clause may be used in conjunction with a column's DEFAULT option.​

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Data Manipulation and Transaction Control

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

Correct AnswerverifiedShow Answer

Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns?​

Correct AnswerverifiedShow Answer

Commands used to modify data are known as DML commands.​

Correct AnswerverifiedShow Answer

Contents of the PUBLISHER table​ -If a column named SAL_PCT is to be defined to ensure a value of 100 is input if a NULL value is provided when a new row is inserted,which column definition should be used?​

Correct AnswerverifiedShow Answer

Commands used to modify data are called ____ commands.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

A(n)shared lock prevents other users from obtaining another shared lock on the same table._________________________​

Correct AnswerverifiedShow Answer

The SET clause of the UPDATE command is used to identify the column(s)being updated.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The SELECT ....____________________ command is used to create a shared lock on a table to prevent other users from making changes in the specified column.​

Correct AnswerverifiedFOR UPDATE​

The effect of which of the following commands can never be reversed by the ROLLBACK command?​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Data that is being added to a table is specified in the VALUES clause of the INSERT command._________________________

Correct AnswerverifiedShow Answer

A shared lock is automatically obtained when the SELECT...FOR UPDATE command is executed.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

The SELECT...FOR UPDATE can be used to create a shared lock._________________________

Correct AnswerverifiedShow Answer

If the ____ clause of the UPDATE command is omitted,then all the rows in the specified table will be changed.​

Correct AnswerverifiedShow Answer

An ON NULL clause may be used in conjunction with a column's DEFAULT option.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

Which keywords create a shared lock on a table to prevent another user from making changes to data in specified columns?

Correct Answer
verified

Commands used to modify data are known as DML commands.

Correct Answer
verified

Contents of the PUBLISHER table -If a column named SAL_PCT is to be defined to ensure a value of 100 is input if a NULL value is provided when a new row is inserted,which column definition should be used?

Correct Answer
verified

Commands used to modify data are called ____ commands.

Correct Answer
verified

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

Correct Answer
verified
C

A(n)shared lock prevents other users from obtaining another shared lock on the same table._________________________

Correct Answer
verified

The SET clause of the UPDATE command is used to identify the column(s)being updated.

Correct Answer
verified

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

Correct Answer
verified

The SELECT ....____________________ command is used to create a shared lock on a table to prevent other users from making changes in the specified column.

Correct Answer
verified
FOR UPDATE

The effect of which of the following commands can never be reversed by the ROLLBACK command?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

A shared lock is automatically obtained when the SELECT...FOR UPDATE command is executed.

Correct Answer
verified

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

Correct Answer
verified
False

Correct Answer
verified

If the ____ clause of the UPDATE command is omitted,then all the rows in the specified table will be changed.

Correct Answer
verified

An ON NULL clause may be used in conjunction with a column's DEFAULT option.

Correct Answer
verified

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

Correct Answer
verified