Oracle
1Z0-071 · Question #282
View the Exhibit and examine the description of the tables. You execute this SQL statement: Which three statements are true? (Choose three.)
The correct answer is A. The statement will execute successfully and a new row will be inserted into the SALES table. E. A customer can exist in many countries. F. The SALES table has five foreign keys. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the description of the tables. You execute this SQL statement:
Which three statements are true? (Choose three.)
Exhibits
Options
- AThe statement will execute successfully and a new row will be inserted into the SALES table.
- BA product can have a different unit price at different times.
- CThe statement will fail because a subquery may not be contained in a VALUES clause.
- DThe statement will fail if a row already exists in the SALES table for product 23.
- EA customer can exist in many countries.
- FThe SALES table has five foreign keys.
How the community answered
(54 responses)- A76% (41)
- B4% (2)
- C13% (7)
- D7% (4)
Community Discussion
No community discussion yet for this question.