Question 1

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

Accepted Answer

INSERT

Question 2

Which of the following commands is used to modify existing data in a table?

Accepted Answer

UPDATE

Question 3

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

Accepted Answer

UPDATE

Question 4

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

Accepted Answer

LOCK TABLE

Question 5

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

Accepted Answer

DELETE

Question 6

Which keyword permanently saves changed data in a table?

Accepted Answer

COMMIT

Question 7

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

Accepted Answer

SELECT...FOR UPDATE

Question 8

Which of the following commands allows a user to undo uncommitted changes to data?

Accepted Answer

ROLLBACK

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

Oracle11g does not allow column names to be omitted from the INSERT INTO clause.

Question 11

When the INSERT command is being used to enter data into a non-numeric column, the data must be enclosed in ____

Accepted Answer

single quotation marks

Question 12

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

Accepted Answer

the same case used in the INSERT command

Question 13

Use the ____ keyword to enter the computer's date as a data value in the INSERT command.

Accepted Answer

SYSTDATE

Question 14

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

Accepted Answer

In the VALUES clause, include the keyword NULL in the position where the value should be listed XX

Question 15

Which of the following keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table?

Accepted Answer

VALUES

Question 16

What will happen if you try to use the INSERT command to insert a NULL value into a column that has been assigned a PRIMARY KEY constraint?

Accepted Answer

An error message is returned and the row is not added to the table.

Question 17

Which of the following is not a valid SQL command?

Accepted Answer

INSERT INTO acctmantableAS (SELECT amid, amname, amedate, regionFROM acctmanagerWHERE amedate <= SYSDATE);

Question 18

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

Accepted Answer

INSERT command with a subquery

Question 19

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

Accepted Answer

WHERE XX

Question 20

The row(s) to be updated by the UPDATE command is specified by the ____ clause.

Accepted Answer

SET XX

Question 21

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

Accepted Answer

WHERE

Question 22

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

Accepted Answer

WHERE

Question 23

Which of the following statements about the UPDATE command is incorrect?

Accepted Answer

The mandatory WHERE clause identifies the specific row(s) to be changed by the UPDATE command.

Question 24

Which of the following is not a valid SQL command?

Accepted Answer

UPDATE acctmanager SET amname = UPPER(amname) WHERE amid = 'J500'; XX

Question 25

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

SIBSTITUTION VARIABLE

Question 26

Which of the following statements about substitution variables is incorrect?

Accepted Answer

The command SET VERIFY OFF will delete all values stored in substitution variables.

Question 27

When does a COMMIT command explicitly occur?

Accepted Answer

When the user executes COMMIT;.

Question 28

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

Accepted Answer

transaction control

Question 29

When does a COMMIT command implicitly occur?

Accepted Answer

When the user issues a DDL command such as CREATE or ALTER TABLE.

Question 30

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

Accepted Answer

CREATE TABLE ALTER TABLECOMMIT

Question 31

Which of the following statements about the DELETE command is incorrect?

Accepted Answer

If you omit the mandatory WHERE clause, an error message will be issued. XX

Question 32

The ____ command will prevent two users from trying to make changes to the same table at the same time.

Accepted Answer

LOCK TABLE

Question 33

Which of the following types of locks permits other users access to unlocked portions of a table?

Accepted Answer

SHARED LOCK

Question 34

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

SELECT...FOR UPDATE

Question 35

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

Accepted Answer

Exclusive Lock

Question 36

A lock arising from a SELECT...FOR UPDATE command will be released when

Accepted Answer

a COMMIT command is executed

Question 37

Based on the contents of the PROMOTION table, which of the following will correctly change the value assigned to the MAXRETAIL column for Free Shipping to 75.00?

Accepted Answer

UPDATE promotion SET maxretail = 75WHERE gift = 'FREE SHIPPING';

Question 38

Which of the following SQL statements will insert a new row into the PROMOTION table?

Accepted Answer

INSERT INTO promotion (gift, minretail, maxretail)VALUES ('FREE BOOK', 75.01, 89.99);

Question 39

Which of the following commands will delete only publisher 4 from the PUBLISHER table?

Accepted Answer

DELETE FROM publisher WHERE pubid = 4

Question 40

Which of the following is a valid statement?

Accepted Answer

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

Question 41

Regarding the INSERT statement, which of the following is correct?

Accepted Answer

Non-numeric data is enclosed in single quotation marks.Column names are enclosed in parentheses ( ).The data values to be inserted are enclosed in parentheses ( ) after the VALUES keyword.* all of the above XX

Question 42

Which of the following statements about COMMIT and ROLLBACK commands is incorrect?

Accepted Answer

All DML commands (INSERT, UPDATE, DELETE) are explicitly committed and cannot be rolled back.All DDL commands (CREATE, TRUNCATE, ALTER TABLE) are explicitly committed and cannot be rolled back.A ROLLBACK command will reverse all DML operations performed since the last COMMIT was performed.*all of the above

Question 43

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

UPDATE publisher SET phone = '800-714-8321'WHERE pubid = 1;

LAB_CHAPTER_5_QUIZ

Unlock all answers in this set

Haven't found what you need?