MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Mysql Database
Mysql Basic
Quiz 1
1
2
3
4
5
6
7
8
9
10
Q.1
Calculations involving numbers are faster than those involving string.
a) True
b) False
Q.2
To convert an int to string, the function is _________________
a) INET_ATON()
b) INET_NTOA()
c) INET_ITOS()
d) INET_STOI()
Q.3
To convert a string to an int, the function is _________________
a) INET_ATON()
b) INET_NTOA()
c) INET_ITOS()
d) INET_STOI()
Q.4
To maintain performance of tables having variable length rows, which statement is used?
a) MAINTAIN TABLE
b) BALANCE TABLE
c) ADJUST TABLE
d) OPTIMIZE TABLE
Q.5
Which of these columns are faster?
a) same
b) variable length
c) fixed length
d) indeterminate
Q.6
Which of these take more space?
a) variable length
b) same
c) fixed length
d) indeterminate
Q.7
To minimize disk I/O, which of these should be chosen?
a) CHAR
b) VARCHAR
c) CHAR & VARCHAR
d) Either CHAR or VARCHAR
Q.8
Avoiding NULL in columns may make queries simpler.
a) True
b) False
Q.9
Which of these can be used to generate hash values?
a) MS5()
b) MA5()
c) MF5()
d) MD5()
Q.10
IP numbers can be represented as _________________
a) both integers and a string
b) a string but not integers
c) integers but not a string
d) neither a string nor integers
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