OE and SCOTT are the users in the database. The ORDERS table is own by OE. Evaluate the statements issued by the DBA in the following sequence: CREATE ROLE RI; GRANT SELECT, INSERT ON oe.orders TO RI; GRANT RI TO scott; GRANT SELECT ON oe.orders TO scott; REVOKE SELECT ON oe.orders FROM scott; What would be the outcome after executing the statements?
A. SCOTT would be able to query the OE.ORDERS table.
B. SCOTT would not be able to query the OE.ORDERS table.
C. The REVOKE statement would remove the SELECT privilege from SCOTT as well as from the role RI.
D. The REVOKE statement would give an error because the SELECT privilege has been granted to the role RI.
查看答案
EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?
A. UPDATE empdet SET ename ='Amit' WHERE empno = 1234;
B. DELETE FROM empdet WHERE ename LIKE'J%';
CREATE VIEW empvu AS SELECT * FROM empdet;
D. CREATE INDEX empdet idx ON empdet(empno);
What does sessions__user in a resource limit set?
A. No. of Concurrent Sessions for the database.
B. No. of Sessions Per User.
C. No. of Processes Per User
D. None of the above
What value sets the no activity time before a user is disconnected?
A. CONNECT-TIME
B. DISCONNECT-TIME
C. IDLE TIME
D. None of the above
Which of the following statements is incorrect when used with ALTER USER usera?
ADD QUOTA 5M
B. IDENTIFIED BY usera
C. DEFAULT TABLESPACE SYSTEM
D. None of the above
微信支付 
支付宝支付