nerdexam
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

1Z0-061 question #19 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)
  • A
    79% (15)
  • B
    5% (1)
  • C
    5% (1)
  • E
    11% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice