MySQL mcq questions and answers | MySQL MCQs Page-4 section-12

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6 Section 7 Section 8 Section 9 Section 10 Section 11 Section 12

31.
Using indexes optimizes query performance.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

32.
A FULLTEXT index cannot be created for multiple columns.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

33.
The keyword used with UNION that retains duplicate rows is . . . . . . . .

A. ALL

B. NARROW

C. STRICT

D. DISTINCT

Answer & Solution Discuss in Board Save for Later

34.
Which is the command to move the cursor to the beginning of line in mysql input editor?

A. Ctrl-E

B. Ctrl-D

C. Esc-a

D. Ctrl-A

Answer & Solution Discuss in Board Save for Later

35.

The number of tables for which DELAYED works is . . . . . . . .

MyISAM, MEMORY, ARCHIVE, BLACKHOLE

A. 1

B. 2

C. 3

D. 4

Answer & Solution Discuss in Board Save for Later

36.
The option that specifies the data directory location at server startup is . . . . . . . .

A. -data

B. -data_dir

C. -data-dir

D. -datadir

Answer & Solution Discuss in Board Save for Later

37.
Which command is used to display all the existing tables in a database?

A. SHOW TABLES

B. SHOW TABLE

C. SHOW

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

38.

Which of these is more restrictive?

mysql_query(), mysql_real_query()

A. mysql_query()

B. mysql_real_query()

C. same

D. machine dependent

Answer & Solution Discuss in Board Save for Later

39.
It is required to have an access privilege for a database before selecting it with 'USE'.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

40.
Which statement makes changes to the database's global attributes?

A. CHANGE

B. ALTER

C. ALTERNATE

D. UPDATE

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9

31.
Using indexes optimizes query performance.

Answer & Solution

32.
A FULLTEXT index cannot be created for multiple columns.

Answer & Solution

33.
The keyword used with UNION that retains duplicate rows is . . . . . . . .

Answer & Solution

34.
Which is the command to move the cursor to the beginning of line in mysql input editor?

Answer & Solution

35.
The number of tables for which DELAYED works is . . . . . . . .

`MyISAM, MEMORY, ARCHIVE, BLACKHOLE`

Answer & Solution

36.
The option that specifies the data directory location at server startup is . . . . . . . .

Answer & Solution

37.
Which command is used to display all the existing tables in a database?

Answer & Solution

38.
Which of these is more restrictive?

`mysql_query(), mysql_real_query()`

Answer & Solution

39.
It is required to have an access privilege for a database before selecting it with 'USE'.

Answer & Solution

40.
Which statement makes changes to the database's global attributes?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

31. Using indexes optimizes query performance.

Answer & Solution

32. A FULLTEXT index cannot be created for multiple columns.

Answer & Solution

33. The keyword used with UNION that retains duplicate rows is . . . . . . . .

Answer & Solution

34. Which is the command to move the cursor to the beginning of line in mysql input editor?

Answer & Solution

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

Answer & Solution

36. The option that specifies the data directory location at server startup is . . . . . . . .

Answer & Solution

37. Which command is used to display all the existing tables in a database?

Answer & Solution

38. Which of these is more restrictive? mysql_query(), mysql_real_query()

Answer & Solution

39. It is required to have an access privilege for a database before selecting it with 'USE'.

Answer & Solution

40. Which statement makes changes to the database's global attributes?

Answer & Solution

Read More Section(MySQL Miscellaneous)

31.
Using indexes optimizes query performance.

32.
A FULLTEXT index cannot be created for multiple columns.

33.
The keyword used with UNION that retains duplicate rows is . . . . . . . .

34.
Which is the command to move the cursor to the beginning of line in mysql input editor?

35.
The number of tables for which DELAYED works is . . . . . . . .

`MyISAM, MEMORY, ARCHIVE, BLACKHOLE`

36.
The option that specifies the data directory location at server startup is . . . . . . . .

37.
Which command is used to display all the existing tables in a database?

38.
Which of these is more restrictive?

`mysql_query(), mysql_real_query()`

39.
It is required to have an access privilege for a database before selecting it with 'USE'.

40.
Which statement makes changes to the database's global attributes?