Oracle
1Z0-071 · Question #203
Evaluate the following SQL commands: The command to create a table fails. Identify the reason for the SQL statement failure.
The correct answer is D. You cannot use SYSDATE in the condition of a CHECK constraint. See the full explanation below for the reasoning.
Question
Evaluate the following SQL commands:
The command to create a table fails. Identify the reason for the SQL statement failure.
Exhibit
Options
- AYou cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO
- BYou cannot use the BETWEEN clause in the condition of a CHECK constraint.
- CYou cannot use the NEXTVAL sequence value as a DEFAULT value for a column.
- DYou cannot use SYSDATE in the condition of a CHECK constraint.
How the community answered
(15 responses)- A13% (2)
- B7% (1)
- D80% (12)
Community Discussion
No community discussion yet for this question.