Explore topic-wise MCQs in Mysql.

This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.

1.

To how many of these does the LOW_PRIORITY modifier apply to?
DELETE, INSERT, LOAD DATA, REPLACE

A. 4
B. 3
C. 2
D. 1
E. None of these
Answer» B. 3
2.

How many of the following implement the default scheduling property of MySQL?
MyISAM, MERGE, MEMORY

A. 3
B. 2
C. 1
D. 0
E. None of these
Answer» B. 2
3.

Which of these has higher priority?
writes, reads

A. reads
B. same priority
C. machine dependent
D. writes
E. None of these
Answer» E. None of these
4.

The number of tables among the following for which HIGH_PRIORITY have an effect are _________________.
MyISAM, MEMORY, MERGE

A. 3
B. 2
C. 1
D. 0
E. None of these
Answer» B. 2
5.

The number of tables for which DELAYED works is _________________.
MyISAM, MEMORY, ARCHIVE, BLACKHOLE

A. 4
B. 3
C. 2
D. 1
E. None of these
Answer» B. 3
6.

The number of tables for which DELAYED works is _________________.

A. 4
B. 3
C. 2
D. 1
E. None of these
Answer» B. 3
7.

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

A. 3
B. 2
C. 1
D. 0
E. None of these
Answer» B. 2