Oracle
1Z0-071 · Question #137
Examine the structure of the SALES table. Examine this statement: Which two statements are true about the SALES1 table? (Choose two.)
The correct answer is B. It will have NOT NULL constraints on the selected columns which had those constraints in the D. It is created with no rows. See the full explanation below for the reasoning.
Question
Examine the structure of the SALES table. Examine this statement:
Which two statements are true about the SALES1 table? (Choose two.)
Exhibits
Options
- AIt will not be created because the column-specified names in the SELECT and CREATE TABLE
- BIt will have NOT NULL constraints on the selected columns which had those constraints in the
- CIt will not be created because of the invalid WHERE clause.
- DIt is created with no rows.
- EIt has PRIMARY KEY and UNIQUE constraints on the selected columns which had those
How the community answered
(32 responses)- A13% (4)
- B78% (25)
- C6% (2)
- E3% (1)
Community Discussion
No community discussion yet for this question.