Q.1
For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______________
  • a) –multiple-transaction
  • b) –single-transaction
  • c) –double-transaction
  • d) –no-transaction
Q.2
To reload a delimited text data file use ______________
  • a) mysqldump
  • b) mysqld
  • c) mysqlimport
  • d) mysqlnaive
Q.3
Replication enables data from one MySQL database server to be copied to one or more MySQL database servers.
  • a) True
  • b) False
Q.4
SBR replication is ______________
  • a) Statement based
  • b) Row based
  • c) Column based
  • d) Table based
Q.5
The library file that contains various portability macros and definitions is ______________
  • a) my_global.h
  • b) my_sys.h
  • c) mysql.h
  • d) my_local.h
Q.6
The header that should be included first is ______________
  • a) my_global.h
  • b) my_sys.h
  • c) mysql.h
  • d) my_local.h
Q.7
Which of the following use ‘NULL’ to indicate failure? mysql_init(), mysql_real_connect()
  • a) 0
  • b) 1
  • c) 2
  • d) 3
Q.8
Which of the following does not return a value? mysql_close(), mysql_init, mysql_real_connect
  • a) 0
  • b) 1
  • c) 2
  • d) 3
Q.9
What is the general statement-issuing routine?
  • a) mysql_real_query()
  • b) mysql_query_real()
  • c) mysql_image_query()
  • d) mysql_query_image()
Q.10
The most restrictive among the following is ______________ mysql_query(), mysql_real_query()
  • a) mysql_query()
  • b) mysql_real_query()
  • c) same
  • d) machine dependent
0 h : 0 m : 1 s