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
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;
Thanks. I fixed it.
Every after in a when we opt for blogs that we read. Listed below would be the latest internet sites that we decide on.
Sites of interest we have a link to
usually posts some extremely fascinating stuff like this. If you are new to this site