Oracle
1Z0-047 · Question #172
View the Exhibit button and examine the structures of ORDERS and ORDER_ITEMS tables. In the ORDERS table, ORDER_ID is the PRIMARY KEY and in the ORDER_ITEMS table, ORDER_ID and LINE_ITEM_ID form the…
The correct answer is B. CREATE VIEW V4(or_no, or_date, cust_id). See the full explanation below for the reasoning.
Question
View the Exhibit button and examine the structures of ORDERS and ORDER_ITEMS tables. In the ORDERS table, ORDER_ID is the PRIMARY KEY and in the ORDER_ITEMS table, ORDER_ID and LINE_ITEM_ID form the composite primary key. Which view can have all the DML operations performed on it?
Exhibit
Options
- ACREATE VIEW V1
- BCREATE VIEW V4(or_no, or_date, cust_id)
- CCREATE VIEW V3
- DCREATE VIEW V2
How the community answered
(49 responses)- A6% (3)
- B76% (37)
- C14% (7)
- D4% (2)
Community Discussion
No community discussion yet for this question.
