Question

Which statement is used to select a default database?

(a) USE

(b) CREATE

(c) DROP

(d) SCHEMA

This question was addressed to me at a job interview.

This key question is from Selecting, Creating, Dropping and Altering Databases in chapter Using SQL to Manage Data of MySQL

Answer 1

The correct answer is (a) USE

To elaborate: MySQL has the facility to use various statements specifically at the database level. For selecting a default database, the keyword or clause used is the ‘USE’ statement.