Oracle
1Z0-071 · Question #230
Examine the following SQL commands: Which statement is true regarding the execution of the above SQL commands?
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #230. The question stem and answer options stay visible for context.
Using DDL Statements to Create and Manage Tables
Question
Examine the following SQL commands:
Which statement is true regarding the execution of the above SQL commands?
Exhibit
Options
- ABoth commands execute successfully.
- BThe first CREATE TABLE command generates an error because the NULL constraint is not valid.
- CThe second CREATE TABLE command generates an error because the CHECK constraint is not
- DThe first CREATE TABLE command generates an error because CHECK and PRIMARY KEY
- EThe first CREATE TABLE command generates an error because the column PROD_ID cannot be
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#CREATE TABLE#NULL constraint#CHECK constraint#PRIMARY KEY