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