Home » Oracle » 1z0-497 v.2 » Examine the command:
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.
Correct Answer: BD
Explanation/Reference:
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 theschema 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, thenthe database creates that item in the default tablespace of the owner of the schema containing the table. References:
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
