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.

Which of the following is used on Solaris?

A. gcc
B. clang
C. Sun Studio
D. FreeBSD
Answer» D. FreeBSD
2.

The static C library client in Windows is _____________

A. mysqlclient.lib
B. mysqlclient.lb
C. mysqlclient.lm
D. myclient.lib
Answer» B. mysqlclient.lb
3.

THE_STATIC_C_LIBRARY_CLIENT_IN_WINDOWS_IS______________?$

A. mysqlclient.lib
B. mysqlclient.lb
C. mysqlclient.lm
D. myclient.lib
Answer» B. mysqlclient.lb
4.

Which of the following is used on Solaris?$

A. gcc
B. clang
C. Sun Studio
D. FreeBSD
Answer» D. FreeBSD
5.

Which of these has a smaller memory footprint?

A.
B. Perl
C. PHP
Answer» C. PHP
6.

What can be used as an alternative to mysqlconfig?

A. pkg-config
B. dkg-config
C. rkg-config
D. qkg-config
Answer» B. dkg-config
7.

On Unix, linking uses dynamic libraries by default.

A. True
B. False
Answer» B. False
8.

The MySQL clients are linked with _____________

A. -lmysqlclient
B. -cmysqlclient
C. -dmysqlclient
D. -vmysqlclient
Answer» B. -cmysqlclient
9.

Which flag is used to compile client programs that use MySQL header files?

A. -O
B. -I
C. -U
D. -A
Answer» C. -U
10.

Which file can be used to execute multiple compile statements?

A. makefile
B. dofile
C. putfile
D. pushfile
Answer» B. dofile
11.

The option for specifying the executable name while compiling with gcc is _____________

A. -e
B. -o
C. -a
D. -b
Answer» C. -a
12.

Which option is necessary to compile a C program havin math functions?

A. -lm
B. -ln
C. -lp
D. -lq
Answer» B. -ln