Which of the following statements places a shared lock on at least a portion of a table

Question:

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

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: