MySQL MCQs with answers Page - 2

Here, you will find a collection of MCQ questions on MySQL. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 831.35K Points
Coach

Q. The ‘SOCKET’ protocol is permitted on which operating systems?

  • (A) windows only
  • (B) unix only
  • (C) all
  • (D) All of above

A

Admin • 831.35K Points
Coach

Q. The –protocol value ‘TCP’ runs on which operating systems?

  • (A) windows only
  • (B) unix only
  • (C) all
  • (D) All of above

A

Admin • 831.35K Points
Coach

Q. Connections to remote servers always use TCP/IP.

  • (A) False
  • (B) True
  • (C) NA
  • (D) NA

A

Admin • 831.35K Points
Coach

Q. Which option is supplied to ensure TCP/IP connection to local server?

  • (A) –connectlocal
  • (B) –hostlocal
  • (C) –localhost
  • (D) –host

A

Admin • 831.35K Points
Coach

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

A

Admin • 831.35K Points
Coach

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

A

Admin • 831.35K Points
Coach

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

A

Admin • 831.35K Points
Coach

Q. mysql_init() returns a _____________.

  • (A) float
  • (B) structure
  • (C) pointer to a structure
  • (D) integer

A

Admin • 831.35K Points
Coach

Q. Which header should be included first?

  • (A) mysql.h
  • (B) my_global.h
  • (C) my_local.h
  • (D) my_sys.h

A

Admin • 831.35K Points
Coach

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

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.