Which of the following Big SQL statements is valid?

Which of the following Big SQL statements is valid?
A . CREATE TABLE t1 WITH CS;
B . WITH t1 AS (…)
(SELECT * FROM t1 WITH RR USE AND KEEP SHARE LOCKS)
UNION ALL
(SELECT * FROM t1 WITH UR);
C . SELECT deptno, deptname, mgrno FROM t1
WHERE admrdept =‘A00’
FOR READ ONLY WITH RS USE AND KEEP EXCLUSIVE LOCKS
D . ALTER TABLE t1 ALTER COLUMN deptname SET DATA TYPE VARCHAR(100) USE AND KEEP UPDATE LOCKS

View Answer

Answer: C