Zend
ZF-100-500 · Question #157
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 t able named OldOrders and transfer all the…
The correct answer is D. 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 t able 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
- CADD INTO
- DSELECT INTO
How the community answered
(31 responses)- A3% (1)
- B10% (3)
- C3% (1)
- D84% (26)
Community Discussion
No community discussion yet for this question.