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