Which two statements are true about the execution of the command?

Examine the command:
SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccodeNUMBER
(6), oamt NUMBER (10, 2)) TABLESPACEusers ;
Which two statements are true about the execution of the command?

Examine the command:
SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccodeNUMBER
(6), oamt NUMBER (10, 2)) TABLESPACEusers ;
Which two statements are true about the execution of the command?

A.
A CHECK constraint is created on the OIDcolumn.

B.
A NOT NULL constraint is created on the OIDcolumn.

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *