Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 12 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

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

A. all
B. unix only
C. windows only
D. none
Answer» C. windows only
Discussion
2.

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

A. all
B. unix only
C. windows only
D. none
Answer» B. unix only
Discussion
3.

THE_‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚Àւ§SOCKET‚ÄÖ√Ñ√∂‚ÀÖ√Ë‚ÀÖ¬•_PROTOCOL_IS_PERMITTED_ON_WHICH_OPERATING_SYSTEMS??$#

A. all
B. unix only
C. windows only
D. none
Answer» C. windows only
Discussion
4.

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

A. all
B. unix only
C. windows only
D. none
Answer» B. unix only
Discussion
5.

Connections to remote servers always use TCP/IP.

A. True
B. False
Answer» B. False
Discussion
6.

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

A. –localhost
B. –host
C. –hostlocal
D. –connectlocal
Answer» C. ‚Äö√Ñ√∂‚àö√ë‚àö¬®hostlocal
Discussion
7.

Which of the following can be used interchangeably with MYSQL_VERSION_ID?

A. LIBMYSQL_VERSION
B. LIBMYSQL_VERSION_ID
C. MYSQL_VERSION_ID
D. MYSQL_ID
Answer» C. MYSQL_VERSION_ID
Discussion
8.

Which of these can be used in place of MYSQL_SERVER_VERSION?

A. LIBMYSQL_VERSION
B. LIBMYSQL_VERSION_ID
C. MYSQL_VERSION_ID
D. MYSQL_ID
Answer» B. LIBMYSQL_VERSION_ID
Discussion
9.

When linking to a static MySQL C client library, the client library and the client application must use the same compiler option.

A. True
B. False
Answer» B. False
Discussion
10.

mysql_init() returns a _____________

A. integer
B. float
C. structure
D. pointer to a structure
Answer» E.
Discussion
11.

Which header should be included first?

A. my_global.h
B. my_sys.h
C. mysql.h
D. my_local.h
Answer» B. my_sys.h
Discussion
12.

Which library file contains various portability macros and definitions?

A. my_global.h
B. my_sys.h
C. mysql.h
D. my_local.h
Answer» C. mysql.h
Discussion