Multiple choice

Which command is used to make back up copies of database tables?

  1. CREATE INTO

  2. SELECT INTO

  3. CREATE FROM

  4. NONE OF THESE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SELECT INTO is a SQL command (particularly in SQL Server) that creates a new table and populates it with the result set from a query, effectively creating a backup. CREATE INTO and CREATE FROM are not valid SQL syntax for this purpose.

Keep practicing — related questions