nerdexam
Oracle

1Z0-071 · Question #270

Examine the description of the SALES table: The SALES table has 55,000 rows. Examine this statement: Which two statements are true? (Choose two.)

The correct answer is A. SALES1 has NOT NULL constraints on any selected columns which had those constraints in the D. SALES1 is created with no rows. See the full explanation below for the reasoning.

Question

Examine the description of the SALES table:

The SALES table has 55,000 rows. Examine this statement:

Which two statements are true? (Choose two.)

Exhibit

1Z0-071 question #270 exhibit

Options

  • ASALES1 has NOT NULL constraints on any selected columns which had those constraints in the
  • BSALES1 is created with 55,000 rows.
  • CSALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those
  • DSALES1 is created with no rows.
  • ESALES1 is created with 1 row.

How the community answered

(33 responses)
  • A
    76% (25)
  • B
    15% (5)
  • C
    6% (2)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice