Question

. Which of the following is a command in MySQL for creating a database called 'game_data'?

(a) INSERT DATABASE game_data;
(b) CREATE DATABASE game_data;
(c) MAKE DATABASE game_data;
(d) NEW DATABASE game_data;

Answer 1

The correct option for the following question is option(b) i.e CREATE DATABASE game_data;

Explanation:

The CREATE command is used to create the database in MySQL .The syntax for creating a database is given as

Create database database name ;

Here database name is game_data

So the query is CREATE DATABASE game_data;

Insert command is used for inserting the value into database not for creating the database .so option(a) is wrong .

MAKE and NEW are not any command so these both the option are wrong.

Therefore the correct answer is option(b);