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)- A7% (2)
- B71% (20)
- D18% (5)
- F4% (1)
Topics
#foreign keys#INSERT with subquery#referential integrity#DML
Community Discussion
No community discussion yet for this question.