nerdexam
Oracle

1Z0-047 · Question #148

View the Exhibit and examine the data in the CUST_DET table. You executed the following multitable INSERT statement: INSERT FIRST WHEN credit_limit >= 5000 THEN INTO cust_1 VALUES(cust_id…

The correct answer is A. CUST_1 table only because CREDIT_LIMIT condition is satisfied. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the data in the CUST_DET table. You executed the following multitable INSERT statement:

INSERT FIRST WHEN credit_limit >= 5000 THEN INTO cust_1 VALUES(cust_id, credit_limit, grade, gender) WHEN grade = THE INTO cust_2 VALUES(cust_id, credit_limit, grade, gender) WHEN gender = THE INTO cust_3 VALUES(cust_id, credit_limit, grade, gender) INTO cust_4 VALUES(cust_id, credit_limit, grade, gender) ELSE INTO cust_5 VALUES(cust_id, credit_limit, grade, gender) SELECT * FROM cust_det; The row will be inserted in________.

Options

  • ACUST_1 table only because CREDIT_LIMIT condition is satisfied
  • BCUST_1 and CUST_2 tables because CREDIT_LIMIT and GRADE conditions are satisfied
  • CCUST_1,CUST_2 and CUST_5 tables because CREDIT_LIMIT and GRADE conditions are satisfied
  • DCUST_1, CUST_2 and CUST_4 tables because CREDIT_LIMIT and GRADE conditions are satisfied

How the community answered

(31 responses)
  • A
    81% (25)
  • B
    3% (1)
  • C
    13% (4)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice