Oracle 11G OCP 1Z0-052 164

（164）Examine the command that is used to create a table:

SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER(6), oamt NUMBER(10,2)) TABLESPACE users;

Which two statements are true about the effect of the above command? (Choose two.)

A. A CHECK constraint is created on the OID column.

B. A NOT NULL constraint is created on the OID column.

C. The ORDERS table is the only object created in the USERS tablespace.  

D. The ORDERS table and a unique index are created in the USERS tablespace.

E. The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.

答案：（B、D）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1225859/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1225859/