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 • 833.24K 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 • 833.24K 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 • 833.24K Points
Coach

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

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

A

Admin • 833.24K 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 • 833.24K 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 • 833.24K 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 • 833.24K 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 • 833.24K Points
Coach

Q. mysql_init() returns a _____________.

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

A

Admin • 833.24K 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 • 833.24K 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