Mark works as a Database Designer for Reon Inc. He is assigned the task to create a database for the
company. He issues the following query to create the database.
CREATE DATABASE ‘24342’
What will be the output of the query?
A.
A database will be created.
B.
An error will be generated stating that a database name must begin with an alphabet and all the alphabets
should be in uppercase.
C.
An error will be generated stating that a database name must begin with an alphabet.
D.
An error will be generated stating that a database name should be a combination of numerals and
alphabets.
Explanation:
A database name can begin with a digit, provided itis enclosed within single quotes. The digits within quotes
are treated as a string. It is not necessary that all the alphabets in a database name should be in uppercase.