Explore topic-wise MCQs in Mysql.

This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.

1.

It is not required to have an access privilege for a database before selecting it with USE .

A. False
B. True
C. NA
D. NA
E. NA
Answer» B. True
Discussion
2.

MySQL stores the database character set and collation attributes in the file _________.

A. db.opt
B. dp.opt
C. db.zip
D. db.sv
E. None of these
Answer» B. dp.opt
Discussion
3.

To create a database only if it doesn t already exist, which clause is used?

A. EXISTS IF
B. CREATE EXISTS
C. IF NOT EXISTS
D. IF EXISTS
E. None of these
Answer» D. IF EXISTS
Discussion
4.

The file created by the server to store the database attributes is __________.

A. db.cls
B. db.otp
C. dp.zip
D. db.opt
E. None of these
Answer» E. None of these
Discussion