Question

Which keyword is used to create a table as a temporary copy of itself?

(a) TEMP

(b) TEMPO

(c) TEMPR

(d) TEMPORARY

This question was posed to me at a job interview.

This intriguing question comes from Creating, Dropping, Indexing and Altering Tables topic in division Using SQL to Manage Data of MySQL

Answer 1

Correct option is (d) TEMPORARY

To explain: The ‘CREATE TABLE’ clause has a very vast formal format, although its usage is extremely simple and intuitive. One of the many ways is to create a table as a temporary copy of itself.