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.

When no modes are enabled, what does this SQL statement return?

A. empty value
B. zero
C. a negative value
D. a garbage valueView Answer
Answer» B. zero
Discussion
2.

Which statement can be used to specify the sql_mode system variable at runtime?

A. SPECIFY
B. SET
C. ASSIGN
D. CHANGE
Answer» C. ASSIGN
Discussion
3.

WHICH_STATEMENT_CAN_BE_USED_TO_SPECIFY_THE_SQL_MODE_SYSTEM_VARIABLE_AT_RUNTIME??$

A. SPECIFY
B. SET
C. ASSIGN
D. CHANGE
Answer» C. ASSIGN
Discussion
4.

Which statement can be used to specify the sql_mode system variable at runtime?$

A. SPECIFY
B. SET
C. ASSIGN
D. CHANGE
Answer» C. ASSIGN
Discussion
5.

Which of the following commands sets the SQL mode as TRADITIONAL?

A. –sqlmode=’TRADITIONAL’
B. –sql_mode=’TRADITIONAL’
C. –sql-mode=’TRADITIONAL’
D. –sql.mode=’TRADITIONAL’
Answer» D. ‚Äö√Ñ√∂‚àö√ë‚àö¬®sql.mode=‚Äö√Ñ√∂‚àö√ë‚àö¬•TRADITIONAL‚Äö√Ñ√∂‚àö√ë‚àö¬•
Discussion
6.

MySQL server mode values are case sensitive.

A. True
B. False
Answer» C.
Discussion
7.

Which of these modes is a composite server mode?

A. COMPOSITE
B. COMPOSITE_MODE
C. COMPOSITE_SERVER
D. ANSI
Answer» E.
Discussion
8.

Which mode tells the server to recognize || as the string concatenation operator?

A. PIPES_AS_CONCAT
B. ORS_AS_CONCAT
C. DOUBLE_PIPE_AS_CONCAT
D. LOGIC_OR_AS_CONCAT
Answer» B. ORS_AS_CONCAT
Discussion
9.

Which mode tells the server to recognize double quote as an identifier quoting character?

A. ANSI_DQ
B. ANSI_QUOTES
C. ANSI_RECG_QUOTES
D. ANSI_RECG_DQUOTES
Answer» C. ANSI_RECG_QUOTES
Discussion
10.

How do the STRICT_ALL_TABLES and STRICT_TRANS_TABLES mode values deal with bad data?

A. reject them
B. accept them
C. change them to the closest legal value and accept
D. change them to the closest legal value and reject
Answer» B. accept them
Discussion
11.

Any client in the client/server architecture of MySQL can change how the server behaves in relation to itself without impact on other clients.

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

The system variable in MySQL server that enables to configure the SQL mode is __________

A. sql_config
B. sql_mode
C. sql_server
D. sql_enable
Answer» C. sql_server
Discussion