Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE * FROM homework10; b. DELETE *.* FROM homework10; c. DELETE FROM homework10; d. DELETE FROM homework10 WHERE amid …
Which of the following statements deletes all rows in the HOMEWORK10 table?
a. DELETE * FROM homework10;
b. DELETE *.* FROM homework10;
c. DELETE FROM homework10;
d. DELETE FROM homework10 WHERE amid = ‘*’;
e. Both c and d delete all rows in the HOMEWORK10 table.
5. Which of the following statements places a shared lock on at least a portion of a table
named HOMEWORK10?
a. SELECT * FROM homework10 WHERE col2 IS NULL FOR UPDATE;
b. INSERT INTO homework10 (col1, col2, col3) VALUES (‘A’, ‘B’, ‘C’);
c. UPDATE homework10 SET col3 = NULL WHERE col1 = ‘A’;
d. UPDATE homework10 SET col3 = LOWER (col3) WHERE col1 = ‘A’;
e. all of the above
6. Assuming the HOMEWORK10 table has three columns (Col1, Col2, and Col3, in this
order), which of the following commands stores a NULL value in Col3 of the
HOMEWORK10 table?
a. INSERT INTO homework10 VALUES (‘A’, ‘B’, ‘C’);
b. INSERT INTO homework10 (col3, col1, col2) VALUES (NULL, ‘A’, ‘B’);
c. INSERT INTO homework10 VALUES (NULL, ‘A’, ‘B’);
d. UPDATE homework10 SET col1 = col3;
7. Which of the following symbols designates a substitution variable?
a. &
b. $
c. #
d. –
8. Which of the following input values results in a successful INSERT of O’hara?
a. ‘O^
hara’
b. ‘O’ ‘hara’ (two single quotes following the O)
c. ‘O”hara’ (a double quote following the O)
d. Data values can’t contain quotes.
9. Which of the following commands locks the HOMEWORK10 table in EXCLUSIVE mode?
a. LOCK TABLE homework10 EXCLUSIVELY;
b. LOCK TABLE homework10 IN EXCLUSIVE MOD
OR