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

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

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



Leave a Reply 5

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


Sam

Sam

Command is missing, it should be:

SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode
NUMBER (6), oamt NUMBER(10,2)) TABLESPACE users;

admin

admin

Thanks. I fixed it.

Google

Google

Every after in a when we opt for blogs that we read. Listed below would be the latest internet sites that we decide on.

SEO services in Lahore

SEO services in Lahore

Sites of interest we have a link to

youtubemp3download3- Youtube to mp3 converter

youtubemp3download3- Youtube to mp3 converter

usually posts some extremely fascinating stuff like this. If you are new to this site