Which two statements are true about the effect of the above command?

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.)

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.)

A.
The ORDERS table and a unique index are created in the USERS tablespace

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

C.
The ORDERS table is created in the USERS tablepsace and a unique index is created on the OID column in the SYSTEM tablespace

D.
A CHECK constraint is created on the OID column

E.
A NOT NULL constraint is created on the OID column



Leave a Reply 1

Your email address will not be published. Required fields are marked *


networkmanagers

networkmanagers

I agree with the answer. AE