Examine the following command that is used to create a table:
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 tablepsace and a unique index is created on the OID
column in the SYSTEM tablespace
Exhibit missing
See question 23 !
SQL> CREATE TABLE orders(kid NUMBER(6), PRIMARY KEY, odate DATE, ccode NUMBER(6), oat NUMBER(10,2)) TABLESPACE users;
Sorry, there is a typo in the SQL, it should be:
SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER(6), oat NUMBER(10,2)) TABLESPACE users;
SEE Q23
http://equizzing.com/oracle/which-two-statements-are-true-about-the-effect-of-the-above-command-10/