Examine these facts about a database:
1.The database default tablespace is USERS
2.DEFERRED_SEGMENT_CREATION IS TRUE
3.The default tablespace of USER1 is tbs1 4. USER1 has only these privileges:
CREATE SESSION
CREATE TABLE
UNLIMITED quota on tbs1
Examine these commands executed by USER1:
What will be the outcome of the INSERT operation and why?
A. A row will be inserted into EMP and an index entry will be inserted into a virtual column of EMP because USER1 has no quota on USERS
B. It will fail because an indexed column cannot have NULL values
C. It will fail because USER1 has no quota on USERS
D. A row will be inserted into EMP but no index entry will be made into EMP_IDX
E. A row will be inserted into EMP and an index entry will be made into EMP_IDX
|
Download Printable PDF. VALID exam to help you PASS. |
 |