Oracle Exam 1Z0-497 Topic 6 Question 110 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 110
Topic #: 6

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?

AA CHECK constraint is created on the OID column.

BA NOT NULL constraint is created on the OID column.

CThe ORDERS table is the only object created in the USERS tablespace.

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

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

Show Suggested Answer

Suggested Answer: D

http://docs.oracle.com/cd/E11882_01/server.112/e25789/process.htm#CNCPT1254

(see database writer process (DBW))

by Jenise at Jan 10, 2025, 11:31 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!