OCP-1Z0-052-V8.02-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 OIDcolumn in the SYSTEM tablespace.

Answer: BD

答案解析：

A。在oid 列上不是check约束，是主键约束。

B。在oid 列上有主键约束，主键约束包含唯一约束和非空约束，故正确。

C。因为在oid 列上有主键索引，故会自动创建唯一索引，故对象不只ORDERS 表，还有一个索引。

D。默认情况下，users是用户创建对象默认的表空间，所以创建的表和索引都放在users表空间里。

E。ORDERS 被创建在USERS表空间，唯一性索引页被创建在USERS表空间，而不是SYSTEM表空间。

所以选BD.