047-q1，
QUESTION 1
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 acredit 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?
A. external table
B. the MERGE command
C. the multitable INSERTcommand
D. INSERTusing WITH CHECK OPTION
Answer:C
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。