nerdexam
Oracle

1Z0-082 · Question #134

View the Exhibit and examine the description of the tables. You execute this SQL statement: Which three statements are true?

The correct answer is B. The sales table has five foreign keys. C. A product can have a different unit price at different times. E. The statement will execute successfully and a new row will be inserted into the sales table. See the full explanation below for the reasoning.

SQL and PL/SQL

Question

View the Exhibit and examine the description of the tables. You execute this SQL statement:

Which three statements are true?

Options

  • AThe statement will fall if a row already exists in the sales table for product 23.
  • BThe sales table has five foreign keys.
  • CA product can have a different unit price at different times.
  • DA customer can exist in many countries.
  • EThe statement will execute successfully and a new row will be inserted into the sales table.
  • FThe statement will fail because a subquery may not be contained in a values clause.

How the community answered

(28 responses)
  • A
    7% (2)
  • B
    71% (20)
  • D
    18% (5)
  • F
    4% (1)

Topics

#foreign keys#INSERT with subquery#referential integrity#DML

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice