MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Mysql Database
Mysql Assessment
Quiz 1
1
2
3
4
5
6
7
8
9
Q.1
What enables encrypted connections to be established?
a) exec_stmt_ssl
b) exec_ssl_stmt
c) exec_stmnt_ssl
d) exec_ssl_stmnt
Q.2
The exec_stmt_ssl is written in _______________
a) C++
b) C
c) Python
d) Perl
Q.3
On failure, ‘mysql_query()’ returns _______________
a) 0
b) 1
c) -1
d) a non-zero value
Q.4
Input handling cannot be customized with MySQL.
a) True
b) False
Q.5
By default, MySQL does not clip out of range numeric values to the nearest fit value.
a) True
b) False
Q.6
Which mode prevents MySQL to perform full checking of date parts?
a) PREVENT_DATE_CHECK
b) STOP_DATES_CHECK
c) ALLOW_DATES_INVALID
d) ALLOW_INVALID_DATES
Q.7
Which statement is used to determine the storage engine for individual tables?
a) SHOW TABLE STATUS
b) SHOW DEFAULT STATUS
c) SHOW STATUS OF TABLE
d) SHOW STATUS TABLE
Q.8
Which table in the ‘INFORMATION_SCHEMA’ stores information about storage engines and server plugins?
a) ENGINES, PLUGINS
b) FILES, PLUGINS
c) PLUGINS, STATISTICS
d) ENGINES, FILES
Q.9
How many of the following is (are) considered as a special character by ‘mysql_real_escape_string()’?
a) 3
b) 1
c) 2
d) 0
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