Question

To create a database only if it doesn’t already exist, which clause is used?

(a) IF EXISTS

(b) IF NOT EXISTS

(c) CREATE EXISTS

(d) EXISTS IF

The question was asked during an interview for a job.

Question is from Selecting, Creating, Dropping and Altering Databases in division Using SQL to Manage Data of MySQL

Answer 1

The correct choice is (b) IF NOT EXISTS

Best explanation: The ‘CREATE DATABASE’ statement supports many optional values. To create a database named ‘my_db’ only if it doesn’t already exist, we write ‘CREATE DATABASE IF NOT EXISTS my_db’.