Examine the following 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.)

Question

Examine the following 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.)

Accepted Answer

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

Answer

A. A CHECK constraint is created on the OID column

Answer

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

Answer

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

1Z0-052 Question #25: Real Exam Question with Answer & Explanation

Question

Options

Community Discussion