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.

Which table is preferred when there are many updates?

A. MyISAM
B. InnoDB
C. MEMORY
D. MERGE
Answer» C. MEMORY
Discussion
2.

The use of table level locks is always useful in MyISAM tables.

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

Find the odd one out in terms of scheduling policies.

A. MyISAM
B. InnoDB
C. MEMORY
D. MERGE
Answer» C. MEMORY
Discussion
4.

The number of tables for which DELAYED works is _________________

A. 1
B. 2
C. 3
D. 4View Answer
Answer» E.
Discussion
5.

The number of tables among the following for which HIGH_PRIORITY have an effect are _________________

A. 0
B. 1
C. 2
D. 3View Answer
Answer» E.
Discussion
6.

To how many of these does the LOW_PRIORITY modifier apply to?

A. 1
B. 2
C. 3
D. 4View Answer
Answer» E.
Discussion
7.

How many of the following implement the default scheduling property of MySQL?

A. 0
B. 1
C. 2
D. 3View Answer
Answer» E.
Discussion
8.

THE_USE_OF_TABLE_LEVEL_LOCKS_IS_ALWAYS_USEFUL_IN_MYISAM_TABLES.?$

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

Which table is preferred when there are many updates?$

A. MyISAM
B. InnoDB
C. MEMORY
D. MERGE
Answer» C. MEMORY
Discussion
10.

Find the odd one out in terms of scheduling policies?

A. MyISAM
B. InnoDB
C. MEMORY
D. MERGE
Answer» C. MEMORY
Discussion
11.

Reading from a table does not change it.

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

Which statement issues a lock on tables?

A. ISSUE LOCK
B. LOCK ISSUE
C. LOCK TABLES
D. ISSUE LOCKS
Answer» D. ISSUE LOCKS
Discussion
13.

Which of these has higher priority?

A.
B. writes
C. reads
Answer» B. writes
Discussion