Exam 1z0-051 topic 1 question 127 discussion

Actual exam question from Oracle's 1z0-051

Question #: 127
Topic #: 1

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cus_last_name column having value
Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and
CREDIT_LIMIT is 600?

A. INSERT INTO orders VALUES (l.'10-mar-2007\ 'direct'. (SELECT customeridFROM customersWHERE cust_last_iiame='Roberts' ANDcredit_limit=600). 1000);
B. INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer idFROM customersWHERE cust_last_iiame='Roberts' ANDredit_limit=600).order_total)VALUES(L'10-mar-2007'. 'direct', &&customer_id, 1000):
C. INSERT INTO(SELECT o.order_id. o.order_date.o.order_modex.customer_id. o.ordertotalFROM orders o. customers cWHERE o.customer_id = c.customeridAND c.cust_la$t_name-RoberTs' ANDc.credit_liinit=600)VALUES (L'10-mar-2007\ 'direct'.( SELECT customer_idFROM customersWHERE cust_last_iiame='Roberts' ANDcredit_limit=600). 1000);
D. INSERT INTO orders (order_id.order_date.order_mode.(SELECT customer_idFROM customersWHERE cust_last_iiame='Roberts' ANDcredit_limit=600).order_total)VALUES(l.'10-mar-2007\ 'direct'. &customer_id. 1000):

Show Suggested Answer

Suggested Answer: A 🗳️

by [deleted] at April 4, 2025, 7:02 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!