MySQL mcq questions and answers | MySQL MCQs Page-5 section-6

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

41.

What is the significance of "ORDER BY emp_id ASC" in the following MySQL command?

SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id ASC;

A. Data of emp_id will be sorted in descending order

B. Data of emp_id will be sorted in ascending order

C. Data of emp_id will be sorted in either ascending or descending order

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

42.
Which is the header that should be included first?

A. my_global.h

B. my_sys.h

C. mysql.h

D. my_local.h

Answer & Solution Discuss in Board Save for Later

43.
The number of files that each end of a client/server connection including SSL support use to set up secure communications is . . . . . . . .

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

44.
INFORMATION_SCHEMA is not based on the SQL standard.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

45.
The Audit_log_events system variable is of type . . . . . . . .

A. string

B. integer

C. float

D. double

Answer & Solution Discuss in Board Save for Later

46.
In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment column is 12 and that row is deleted, the next value generated is . . . . . . . .

A. 12

B. 13

C. 1

D. 14

Answer & Solution Discuss in Board Save for Later

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

A. -delay-write-key=ALL

B. -delay-key-write=ALL

C. -key-write-delay=NONE

D. -key-delay-write=NONE

Answer & Solution Discuss in Board Save for Later

48.
INT2 maps to MySQL type . . . . . . . .

A. TINYINT

B. SMALLINT

C. MEDIUMINT

D. BIGINT

Answer & Solution Discuss in Board Save for Later

49.
When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns . . . . . . . .

A. -1

B. 0

C. 1

D. 2

Answer & Solution Discuss in Board Save for Later

50.
Which of these types store the longest length of strings?

A. CHAR

B. VARCHAR

C. TINYTEXT

D. TEXT

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

41.
What is the significance of "ORDER BY emp_id ASC" in the following MySQL command?

`SELECT emp_id, fname, lname FROM person ORDER BY emp_id ASC;`

Answer & Solution

42.
Which is the header that should be included first?

Answer & Solution

43.
The number of files that each end of a client/server connection including SSL support use to set up secure communications is . . . . . . . .

Answer & Solution

44.
INFORMATION_SCHEMA is not based on the SQL standard.

Answer & Solution

45.
The Audit_log_events system variable is of type . . . . . . . .

Answer & Solution

46.
In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment column is 12 and that row is deleted, the next value generated is . . . . . . . .

Answer & Solution

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

Answer & Solution

48.
INT2 maps to MySQL type . . . . . . . .

Answer & Solution

49.
When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns . . . . . . . .

Answer & Solution

50.
Which of these types store the longest length of strings?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

41. What is the significance of "ORDER BY emp_id ASC" in the following MySQL command? SELECT emp_id, fname, lname FROM person ORDER BY emp_id ASC;

Answer & Solution

42. Which is the header that should be included first?

Answer & Solution

43. The number of files that each end of a client/server connection including SSL support use to set up secure communications is . . . . . . . .

Answer & Solution

44. INFORMATION_SCHEMA is not based on the SQL standard.

Answer & Solution

45. The Audit_log_events system variable is of type . . . . . . . .

Answer & Solution

46. In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment column is 12 and that row is deleted, the next value generated is . . . . . . . .

Answer & Solution

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

Answer & Solution

48. INT2 maps to MySQL type . . . . . . . .

Answer & Solution

49. When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns . . . . . . . .

Answer & Solution

50. Which of these types store the longest length of strings?

Answer & Solution

Read More Section(MySQL Miscellaneous)

41.
What is the significance of "ORDER BY emp_id ASC" in the following MySQL command?

`SELECT emp_id, fname, lname FROM person ORDER BY emp_id ASC;`

42.
Which is the header that should be included first?

43.
The number of files that each end of a client/server connection including SSL support use to set up secure communications is . . . . . . . .

44.
INFORMATION_SCHEMA is not based on the SQL standard.

45.
The Audit_log_events system variable is of type . . . . . . . .

46.
In a MyISAM table, if the maximum value of an AUTO_INCREMENT increment column is 12 and that row is deleted, the next value generated is . . . . . . . .

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

48.
INT2 maps to MySQL type . . . . . . . .

49.
When no AUTO_INCREMENT value has been generated during the current connection, LAST_INSERT_ID() returns . . . . . . . .

50.
Which of these types store the longest length of strings?