Multiple choice

How to create a backup copy of table emp called emp_backup in another database called DBEmp_backup.mdb?

  1. CREATE TABLE DBEmp_backup.emp_backup FROM emp

  2. SELECT emp.* INTO emp_backup IN DBEmp_backup.mdb FROM emp

  3. CREATE TABLE emp_backup IN DBEmp_backup.mdb FROM emp

  4. None of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The SELECT...INTO statement is the correct SQL syntax to create a new table in another database from existing data. Options A and C use invalid CREATE TABLE syntax (no FROM clause in this context).

Keep practicing — related questions