Oracle
1Z0-047 · Question #2
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…
The correct answer is C. the multitable INSERT command. See the full explanation below for the reasoning.
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
How the community answered
(62 responses)- A11% (7)
- B3% (2)
- C79% (49)
- D6% (4)
Community Discussion
No community discussion yet for this question.