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.

In a single table (with 10 columns) join query the number of values needed to examine per column is __________.

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

Suppose Person is a table consisting of 8 rows and Employee is a table consisting of 6 rows, the number of combinations through which the search is performed is __________.SELECT Person.i1, Employee.i2 FROM Person INNER JOIN Employee WHERE Person.i1 = Employee.i2;

A. 1
B. 14
C. 48
D. 84
E. None of these
Answer» D. 84
Discussion
3.

How many of the following shared tablespaces is bound by the OS file size limit?MyISAM, InnoDB, TRANSACTION

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

In a single table (with 10 columns) join query the number of values needed to examine per column is __________.

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

The data rows of a MyISAM table are stored in __________.

A. log file
B. error file
C. data file
D. index file
E. None of these
Answer» D. index file
Discussion
6.

The maximum number of indexes on MyISAM table is __________.

A. more than 1
B. 0
C. 1
D. 2
E. None of these
Answer» B. 0
Discussion
7.

Suppose Person is a table consisting of 8 rows and Employee is a table consisting of 6 rows, the number of combinations through which the search is performed is __________.

A. 1
B. 14
C. 48
D. 84
E. None of these
Answer» D. 84
Discussion
8.

The slow query log is written as __________.

A. text
B. graph
C. numbers
D. image
E. None of these
Answer» B. graph
Discussion
9.

For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is __________.

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

If a column contains 7 values and 6 distinct values, the cardinality is __________.

A. 6
B. 7
C. 1
D. 13
E. None of these
Answer» B. 7
Discussion