MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Mysql Database
Tough Mysql
Quiz 1
1
2
3
4
5
6
7
8
9
Q.1
The error log file has a suffix ______________
a) .err
b) .er
c) .error
d) .log
Q.2
The option which finds the startup options supported by the server through mysqld is ______________
a) –verbose
b) –vertex
c) –startup
d) –shutdown
Q.3
Server startup can also be done by the ______________
a) option file
b) log file
c) error file
d) system file
Q.4
It is required to have an access privilege for a database before selecting it with ‘USE’.
a) True
b) False
Q.5
The keyword used to create a database is __________
a) CREATE
b) SET
c) SETUP
d) LINK
Q.6
Which file is created by the server to store the database attributes?
a) db.otp
b) dp.zip
c) db.opt
d) db.cls
Q.7
What is the default storage engine?
a) EXAMPLE
b) ARCHIVE
c) MyISAM
d) NDB
Q.8
The name of the format file for a table named my_tbl is __________
a) my_tbl.fmt
b) my_tbl.frm
c) my_tbl.fmr
d) my_tbl.ftm
Q.9
In the CREATE TABLE statement, the engine name specified is case insensitive.
a) True
b) False
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page