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

This section includes 14 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 file that can be used to execute multiple compile statements is _________________

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

Which option is used for specifying the executable name while compiling with gcc?

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

The option that is necessary to compile a C program having math functions is _____________

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

The MySQL double dashed comment style is the same as the SQL standard.

A. True
B. False
Answer» C.
5.

Which of these is not a comment specifying construct?

A. #
B. /* */
C.
D. !#
Answer» E.
6.

WHICH_OPTION_IS_USED_FOR_SPECIFYING_THE_EXECUTABLE_NAME_WHILE_COMPILING_WITH_GCC??$

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

The_file_that_can_be_used_to_execute_multiple_compile_statements_is__________________$

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

The option that is necessary to compile a C program having math functions is ____________?

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

The option that executes all SQL statements in a SQL script irrespective of the number of errors is _____________

A. –force
B. –run
C. –ensure
D. –violent
Answer» B. ‚Äö√Ñ√∂‚àö√ë‚àö¬®run
10.

Input handling can be customized with MySQL.

A. True
B. False
Answer» C.
11.

What does ‘mysql_query()’ return on failure?$

A. 0
B. 1
C. -1
D. a non-zero value
Answer» E.
12.

The statement that exits a labeled flow-control construct is _____________

A. DESCRIBE
B. LEAVE
C. LOOP
D. RETURN
Answer» C. LOOP
13.

What sets the association between one or more MyISAM tables and the named key cache?

A. BEGIN
B. CACHE INDEX
C. ALTER DATABASE
D. ALTER EVENT
Answer» C. ALTER DATABASE
14.

The MySQL double dashed comment style is same as the SQL standard.

A. True
B. False
Answer» C.