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?

Question

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?

Accepted Answer

B. A NOT NULL constraint is created on the OIDcolumn. D. The ORDERS table and a unique index are created in the USERS tablespace.

Answer

A. A CHECK constraint is created on the OIDcolumn.

Answer

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

Answer

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

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…

Question

Options

How the community answered

Community Discussion