MySQL mcq questions and answers | MySQL MCQs Page-7 section-7

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

61.
Which of the following characters is illegal in naming an unquoted identifier in SQL?

A. _

B. $

C. 2

D. .

Answer & Solution Discuss in Board Save for Later

62.
What loads data files into tables?

A. mysqldump

B. mysqladmin

C. mysqlimport

D. mysqlexport

Answer & Solution Discuss in Board Save for Later

63.
The slow query log is written as . . . . . . . .

A. numbers

B. text

C. image

D. graph

Answer & Solution Discuss in Board Save for Later

64.
Multiple MySQL servers can be easily run on the same machine.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

65.
Where does MySQL Enterprise Backup record details of each backup?

A. history_backup

B. backup_history

C. backlog_history

D. history_backlog

Answer & Solution Discuss in Board Save for Later

66.
Which log does the event scheduler log to?

A. error

B. record

C. library

D. update

Answer & Solution Discuss in Board Save for Later

67.

The default scheduling property of MySQL is implemented by how many of these?

MyISAM, MERGE, MEMORY

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

68.
Which spatial datatype is used to store a curve?

A. GEOMETRY

B. POINT

C. LINESTRING

D. POLYGON

Answer & Solution Discuss in Board Save for Later

69.
The comma operator can also be used to join tables.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

70.
What returns a result to the client?

A. Stored functions

B. Stored procedures

C. Triggers

D. Events

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

61.
Which of the following characters is illegal in naming an unquoted identifier in SQL?

Answer & Solution

62.
What loads data files into tables?

Answer & Solution

63.
The slow query log is written as . . . . . . . .

Answer & Solution

64.
Multiple MySQL servers can be easily run on the same machine.

Answer & Solution

65.
Where does MySQL Enterprise Backup record details of each backup?

Answer & Solution

66.
Which log does the event scheduler log to?

Answer & Solution

67.
The default scheduling property of MySQL is implemented by how many of these?

`MyISAM, MERGE, MEMORY`

Answer & Solution

68.
Which spatial datatype is used to store a curve?

Answer & Solution

69.
The comma operator can also be used to join tables.

Answer & Solution

70.
What returns a result to the client?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

61. Which of the following characters is illegal in naming an unquoted identifier in SQL?

Answer & Solution

62. What loads data files into tables?

Answer & Solution

63. The slow query log is written as . . . . . . . .

Answer & Solution

64. Multiple MySQL servers can be easily run on the same machine.

Answer & Solution

65. Where does MySQL Enterprise Backup record details of each backup?

Answer & Solution

66. Which log does the event scheduler log to?

Answer & Solution

67. The default scheduling property of MySQL is implemented by how many of these? MyISAM, MERGE, MEMORY

Answer & Solution

68. Which spatial datatype is used to store a curve?

Answer & Solution

69. The comma operator can also be used to join tables.

Answer & Solution

70. What returns a result to the client?

Answer & Solution

Read More Section(MySQL Miscellaneous)

61.
Which of the following characters is illegal in naming an unquoted identifier in SQL?

62.
What loads data files into tables?

63.
The slow query log is written as . . . . . . . .

64.
Multiple MySQL servers can be easily run on the same machine.

65.
Where does MySQL Enterprise Backup record details of each backup?

66.
Which log does the event scheduler log to?

67.
The default scheduling property of MySQL is implemented by how many of these?

`MyISAM, MERGE, MEMORY`

68.
Which spatial datatype is used to store a curve?

69.
The comma operator can also be used to join tables.

70.
What returns a result to the client?