MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Mysql Database
Tricky Mysql
Quiz 1
1
2
3
4
5
6
7
8
9
10
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
1
2
3
4
5
6
7
8
9
10
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