Oracle
1Z0-047 · Question #2
1Z0-047 Question #2: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #2. The question stem and answer options stay visible for context.
Question
You need to load information about new customers from the NEW_CUST table into the tables CUST and CUST_SPECIAL If a new customer has a credit limit greater than 10,000, then the details have to be inserted into CUST_SPECIAL All new customer details have to be inserted into the CUST table. Which technique should be used to load the data most efficiently?
Options
- Aexternal table
- Bthe MERGE command
- Cthe multitable INSERT command
- DINSERT using WITH CHECK OPTION
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.