Oracle
1Z0-061 · Question #19
Examine the structure of the sales table: Evaluate the following create table statement: Which two statements are true about the creation of the SALES1 table?
The correct answer is A. The SALES1 table is created with no rows but only a structure. D. The SALES1 table would have not null and unique constraints on the specified columns. See the full explanation below for the reasoning.
Question
Examine the structure of the sales table:
Evaluate the following create table statement:
Which two statements are true about the creation of the SALES1 table?
Exhibit
Options
- AThe SALES1 table is created with no rows but only a structure.
- BThe SALES1 table would have primary key and unique constraints on the specified columns.
- CThe SALES1 table would not be created because of the invalid where clause.
- DThe SALES1 table would have not null and unique constraints on the specified columns.
- EThe SALES1 table would not be created because column-specified names in the select and create
How the community answered
(19 responses)- A79% (15)
- B5% (1)
- C5% (1)
- E11% (2)
Community Discussion
No community discussion yet for this question.
