What will be the output of the query?

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?

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Ardalan Shahgholi

Ardalan Shahgholi

Msg 102, Level 15, State 1, Line 32
Incorrect syntax near ‘‘’.