Examine the command:
SQL> CREATE TABLE orders(oid NUMBER (6) PRIMARY KEY, odato DATE, ccode NUMBER (6), oamt
NUMBER (10, 2)) TABLESPACE users ;
Which two statements are true about the execution of the command?
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 OID column
in the SYSTEM tablespace.
Explanation:
B: A NOT NULL constraint is put on the primary key.
D:
* To enable a unique or primary key constraint, you must have the privileges necessary to create an index on
the table. You need these privileges because Oracle Database creates an index on the columns of the unique
or primary key in the schema containing the table.
* TABLESPACE Specify the tablespace in which Oracle Database creates the table, object table OIDINDEX,
partition, LOB data segment, LOB index segment, or index-organized table overflow data segment. If you omit
TABLESPACE, then the database creates that item in the default tablespace of the owner of the schema
containing the table.