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