To create a database only if it doesn’t already exist, which clause – McqOptions

MCQOPTIONS

1.	To create a database only if it doesn’t already exist, which clause is used?
A.	IF EXISTS
B.	IF NOT EXISTS
C.	CREATE EXISTS
D.	EXISTS IF
Answer» C. CREATE EXISTS

Discussion

No Comment Found

Related MCQs

Which statement makes changes to the database’s global attributes?
Which statement is used to see the definition for an existing database?
MySQL stores the database character set and collation attributes in the file _________
To create a database only if it doesn’t already exist, which clause is used?
It is not required to have an access privilege for a database before selecting it with ‘USE’.
WHICH_STATEMENT_IS_USED_TO_SEE_THE_DEFINITION_FOR_AN_EXISTING_DATABASE??$
Which_statement_makes_changes_to_the_database‚Äö√Ñ√∂‚àö√ë‚àö¬•s_global_attributes?$#
MySQL stores the database character set and collation attributes in the file ________?
If COLLATE is given without CHARACTER SET, the first part of the collation name gives the character set.
To create a database only if it doesn‚Äö√Ñ√∂‚àö√ë‚àö¬•t already exist, which clause is used?$