Examine these facts about a database. 　　---1.The database defaul

Examine these facts about a database. 　　---1.The database default tabpespace 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: 　　SQL> CREATE TABLE emp (eno NUMBER, ename VARCHAR2(20.. 　　TABLESPACE TBS1; 　　Table created. 　　SQL> CREATE INDEX emp_inx ON emp(eno. TABLESPACE USERS; Index created. 　　SQL> INSERT INTO emp VALUES (NULL,’Alan’.; 　　What will be the outcome of the INSERT operation and why?

A.It will fail because an indexed column cannot have NULL values.

B.A row will be inserted into EMP and an index entry will be made into EMP_IDX.

C.It will fail because USER1 has no quota on USERS.

D.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 an USERS.

E.A row will be inserted into EMP but no index entry will be made into EXP_IDX.

正确答案是C