Oracle

1Z0-071 · Question #105

You execute the SQL statement: What is the outcome?

The correct answer is A. It fails because the NOT NULL and DEFAULT options cannot be combined for the same column. See the full explanation below for the reasoning.

Question

You execute the SQL statement:

What is the outcome?

Exhibit

1Z0-071 question #105 exhibit

Options

AIt fails because the NOT NULL and DEFAULT options cannot be combined for the same column.
BIt succeeds and CITY can contain only `SEATTLE' or null for all rows.
CIt fails because the condition for the CNAMES constraint is not valid.
DIt succeeds and an index is crated for CITIZEN_ID.

How the community answered

(29 responses)

A
79% (23)
B
3% (1)
C
7% (2)
D
10% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-071 Practice