MySQL MCQs with answers Page - 2

Dear candidates you will find MCQ questions of MySQL here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

📊 MySQL
Q. The ‘SOCKET’ protocol is permitted on which operating systems?
  • (A) windows only
  • (B) unix only
  • (C) all
  • (D) All of above
💬 Discuss
✅ Correct Answer: (B) unix only
📊 MySQL
Q. The –protocol value ‘TCP’ runs on which operating systems?
  • (A) windows only
  • (B) unix only
  • (C) all
  • (D) All of above
💬 Discuss
✅ Correct Answer: (C) all
📊 MySQL
Q. Connections to remote servers always use TCP/IP.
  • (A) False
  • (B) True
  • (C) NA
  • (D) NA
💬 Discuss
✅ Correct Answer: (B) True
📊 MySQL
Q. Which option is supplied to ensure TCP/IP connection to local server?
  • (A) –connectlocal
  • (B) –hostlocal
  • (C) –localhost
  • (D) –host
💬 Discuss
✅ Correct Answer: (D) –host
📊 MySQL
Q. Which of the following can be used interchangeably with MYSQL_VERSION_ID?
  • (A) LIBMYSQL_VERSION_ID
  • (B) MYSQL_VERSION_ID
  • (C) MYSQL_ID
  • (D) LIBMYSQL_VERSION
💬 Discuss
✅ Correct Answer: (A) LIBMYSQL_VERSION_ID
📊 MySQL
Q. Which of these can be used in place of MYSQL_SERVER_VERSION?
  • (A) LIBMYSQL_VERSION_ID
  • (B) MYSQL_ID
  • (C) LIBMYSQL_VERSION
  • (D) MYSQL_VERSION_ID
💬 Discuss
✅ Correct Answer: (C) LIBMYSQL_VERSION
📊 MySQL
Q. When linking to a static MySQL C client library, the client library and the client application must use the same compiler option.
  • (A) False
  • (B) True
  • (C) NA
  • (D) NA
💬 Discuss
✅ Correct Answer: (B) True
📊 MySQL
Q. mysql_init() returns a _____________.
  • (A) float
  • (B) structure
  • (C) pointer to a structure
  • (D) integer
💬 Discuss
✅ Correct Answer: (C) pointer to a structure
📊 MySQL
Q. Which header should be included first?
  • (A) mysql.h
  • (B) my_global.h
  • (C) my_local.h
  • (D) my_sys.h
💬 Discuss
✅ Correct Answer: (B) my_global.h
📊 MySQL
Q. Which library file contains various portability macros and definitions?
  • (A) mysql.h
  • (B) my_local.h
  • (C) my_sys.h
  • (D) my_global.h
💬 Discuss
✅ Correct Answer: (C) my_sys.h

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play