MySQL mcq questions and answers | MySQL MCQs Page-8 section-11

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

71.

When no modes are enabled, what does this SQL statement return?

SELECT @@SESSION.sql_mode;

A. empty value

B. zero

C. a negative value

D. a garbage value

Answer & Solution Discuss in Board Save for Later

72.
What causes a replication master server to delete all the binary log files even if they are still in use?

A. RESET MASTER LOGS

B. FLUSH TABLES

C. RELOAD

D. FLUSH LOGS

Answer & Solution Discuss in Board Save for Later

73.
Which of these can be used to generate hash values?

A. MS5()

B. MA5()

C. MF5()

D. MD5()

Answer & Solution Discuss in Board Save for Later

74.

What is x in the following MySQL statement?

DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

A. column name

B. table name

C. server name

D. database name

Answer & Solution Discuss in Board Save for Later

75.
What is the default format for "Date" data type?

A. YYYY-MM-DD

B. MM-YYYY-DD

C. DD-MM-YYYY

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

76.
Which of these is a stored program associated with a schedule?

A. Trigger

B. Event

C. Stored function

D. Stored procedure

Answer & Solution Discuss in Board Save for Later

77.
What is the meaning of "NULL" in Mysql?

A. Not applicable

B. Value not yet known

C. Value undefined

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

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

A. data file

B. index file

C. log file

D. error file

Answer & Solution Discuss in Board Save for Later

79.
The statement that is used to check the status of the event scheduler at runtime is . . . . . . . .

A. SHOW STATUS OF 'event_scheduler'

B. SHOW VARIABLES OF 'event_scheduler'

C. SHOW STATUS LIKE 'event_scheduler'

D. SHOW VARIABLES LIKE 'event_scheduler'

Answer & Solution Discuss in Board Save for Later

80.
The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .

A. -ensure

B. -force

C. -violent

D. -run

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

71.
When no modes are enabled, what does this SQL statement return?

`SELECT @@SESSION.sql_mode;`

Answer & Solution

72.
What causes a replication master server to delete all the binary log files even if they are still in use?

Answer & Solution

73.
Which of these can be used to generate hash values?

Answer & Solution

74.
What is x in the following MySQL statement?

`DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;`

Answer & Solution

75.
What is the default format for "Date" data type?

Answer & Solution

76.
Which of these is a stored program associated with a schedule?

Answer & Solution

77.
What is the meaning of "NULL" in Mysql?

Answer & Solution

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

Answer & Solution

79.
The statement that is used to check the status of the event scheduler at runtime is . . . . . . . .

Answer & Solution

80.
The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

71. When no modes are enabled, what does this SQL statement return? SELECT @@SESSION.sql_mode;

Answer & Solution

72. What causes a replication master server to delete all the binary log files even if they are still in use?

Answer & Solution

73. Which of these can be used to generate hash values?

Answer & Solution

74. What is x in the following MySQL statement? DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

Answer & Solution

75. What is the default format for "Date" data type?

Answer & Solution

76. Which of these is a stored program associated with a schedule?

Answer & Solution

77. What is the meaning of "NULL" in Mysql?

Answer & Solution

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

Answer & Solution

79. The statement that is used to check the status of the event scheduler at runtime is . . . . . . . .

Answer & Solution

80. The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .

Answer & Solution

Read More Section(MySQL Miscellaneous)

71.
When no modes are enabled, what does this SQL statement return?

`SELECT @@SESSION.sql_mode;`

72.
What causes a replication master server to delete all the binary log files even if they are still in use?

73.
Which of these can be used to generate hash values?

74.
What is x in the following MySQL statement?

`DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;`

75.
What is the default format for "Date" data type?

76.
Which of these is a stored program associated with a schedule?

77.
What is the meaning of "NULL" in Mysql?

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

79.
The statement that is used to check the status of the event scheduler at runtime is . . . . . . . .

80.
The option that executes all SQL statements in a SQL script irrespective of the number of errors is . . . . . . . .