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

This section includes 13 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.

How many digits is the DECIMAL used for expressions containing only exact values with fractional part?

A. 32
B. 64
C. 65
D. 16
Answer» D. 16
Discussion
2.

What is the precision of BIGINT?

A. 32
B. 64
C. 128
D. 16
Answer» C. 128
Discussion
3.

What is the mantissa in -1.58E5?

A. -1.58
B. 1.58
C. E
D. 5
Answer» B. 1.58
Discussion
4.

How can a view refer to multiple tables?

A. UNION
B. JOIN
C. GROUP
D. SELECT
Answer» C. GROUP
Discussion
5.

abc in the following MySQL statement is ____________

A. row name
B. column name
C. view
D. databaseView Answer
Answer» C. view
Discussion
6.

xyz in the following MySQL statement is __________

A. table
B. column
C. view
D. databaseView Answer
Answer» D. databaseView Answer
Discussion
7.

HOW_CAN_A_VIEW_REFER_TO_MULTIPLE_TABLES??$

A. UNION
B. JOIN
C. GROUP
D. SELECT
Answer» C. GROUP
Discussion
8.

What is the mantissa in -1.58E5?$

A. -1.58
B. 1.58
C. E
D. 5
Answer» D. 5
Discussion
9.

row nam?

A. column name
B. view
C. database
Answer» B. view
Discussion
10.

Which system variable enables mysqld to keep more tables open simultaneously?

A. table_cache
B. max_connect
C. delayed_queue_size
D. max_allowed_packet
Answer» B. max_connect
Discussion
11.

The most important configurable resource for MyISAM is ______________

A. key cache
B. memory cache
C. time cache
D. speed cache
Answer» B. memory cache
Discussion
12.

The storage engine for which the runtime options are always enabled is ______________

A. Falcon
B. FEDERATED
C. InnoDB
D. MEMORY
Answer» E.
Discussion
13.

For which of these storage engines are configuration options always built?

A. Falcon
B. FEDERATED
C. InnoDB
D. MyISAM
Answer» E.
Discussion