nerdexam
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

1Z0-047 question #172 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)
  • A
    6% (3)
  • B
    76% (37)
  • C
    14% (7)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice