Explore topic-wise MCQs in Mysql.

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

1.

Accessing data from which of these is faster?
memory, disk

A. same speed
B. machine dependent
C. memory
D. disk
E. None of these
Answer» D. disk
Discussion
2.

Which is more efficient?
LOAD DATA, INSERT

A. same
B. indeterminate
C. LOAD DATA
D. INSERT
E. None of these
Answer» D. INSERT
Discussion
3.

The option which delays index flushing for slave server is _________________.

A. key-delay-write=NONE
B. key-write-delay=NONE
C. delay-write-key=ALL
D. delay-key-write=ALL
E. None of these
Answer» E. None of these
Discussion
4.

Which option turns on the extended-insert?

A. op
B. optimize
C. opt
D. opti
E. None of these
Answer» D. opti
Discussion
5.

Without LOCAL, LOAD DATA is _________________.

A. same speed
B. more efficient
C. arbitrary
D. less efficient
E. None of these
Answer» C. arbitrary
Discussion
6.

The system variable to maintain InnoDB log buffer size is _________________.

A. innodb_buffer_log_size
B. log_buffer_innodb_size
C. innodb_log_buffer_size
D. buffer_log_innodb_size
E. None of these
Answer» D. buffer_log_innodb_size
Discussion
7.

In MySQL, the default size of the key buffer in MB is _________________.

A. 32
B. 16
C. 8
D. 4
E. None of these
Answer» D. 4
Discussion
8.

To reactivate indexes the command used is _________________.

A. ENABLE INDEXES
B. ENABLE KEYS
C. DISABLE INDEXES
D. DISABLE KEYS
E. None of these
Answer» C. DISABLE INDEXES
Discussion
9.

TO enable the compressed client/server protocol the option is _________________.

A. restrict
B. reduce
C. enable
D. compress
E. None of these
Answer» E. None of these
Discussion
10.

To determine whether query cache is supported by the server the variable is _________________.

A. query_cache_have
B. have_query_cache
C. cache_query_have
D. have_cache_query
E. None of these
Answer» C. cache_query_have
Discussion