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
Answer: C
Latest C2090-101 Dumps Valid Version with 106 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund