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

Get Premium 1Z0-497 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Rodrigo

7 days ago

The correct answers are B and D. The OID column has a PRIMARY KEY constraint, which implies a NOT NULL constraint. And the table and a unique index are both created in the USERS tablespace.

upvoted 0 times

...

Benton

13 days ago

Hmm, that makes sense too. I guess we need to carefully consider all the options before selecting the correct answer.

upvoted 0 times

...

Lai

15 days ago

I disagree, I believe option E is correct because the table is created in the USERS tablespace and a unique index is created in the SYSTEM tablespace.

upvoted 0 times

...

Benton

17 days ago

I think option D is correct because a unique index is created in the USERS tablespace.

upvoted 0 times

...