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 it is 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.
Msg 102, Level 15, State 1, Line 32
Incorrect syntax near ‘‘’.