Zend
200-530 · Question #469
You are using a database named SalesDB to keep all sales records. The SalesDB database contains a table named Orders. You are required to create a new table named OldOrders and transfer all the data…
The correct answer is C. SELECT INTO. See the full explanation below for the reasoning.
Question
You are using a database named SalesDB to keep all sales records. The SalesDB database contains a table named Orders. You are required to create a new table named OldOrders and transfer all the data from the Orders table to the new table. Which of the following statements will you use to accomplish the task?
Options
- AIMPORT INTO
- BINSERT INTO
- CSELECT INTO
- DADD INTO
How the community answered
(58 responses)- A16% (9)
- B9% (5)
- C72% (42)
- D3% (2)
Community Discussion
No community discussion yet for this question.