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

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.
Which of these grant table scope columns is case insensitive?

A. Host

B. User

C. Password

D. Db

Answer & Solution Discuss in Board Save for Later

32.
The option that supplies the pathname to root directory of MySQL installation is . . . . . . . .

A. -basedir

B. -datadir

C. -port

D. -socket

Answer & Solution Discuss in Board Save for Later

33.
Which among the following operators is/are belongs to "Equality conditions"?

A. <>

B. !=

C. =

D. >/<

Answer & Solution Discuss in Board Save for Later

34.
What is the durability property of transactions?

A. statements form a logic unit

B. database remains consistent

C. one transaction does not affect the other

D. transaction effects are recorded permanently

Answer & Solution Discuss in Board Save for Later

35.
The disk data that the FILES table in INFORMATION_SCHEMA stores is . . . . . . . .

A. NDB

B. NBD

C. NBK

D. NCD

Answer & Solution Discuss in Board Save for Later

36.
Prior to MySQL 6.0, utf8 was . . . . . . . .

A. 3 bytes

B. 4 bytes

C. 8 bytes

D. 9 bytes

Answer & Solution Discuss in Board Save for Later

37.
Which Clause is used to sort the stored data in alphabetical order?

A. ORDER by CLAUSE

B. MODIFY

C. ALTER

D. UPDATE

Answer & Solution Discuss in Board Save for Later

38.
Triggers and events are invoked automatically by the server.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

39.
Which of these is also known as a virtual table?

A. SCHEMA

B. DATABASE

C. JOIN

D. VIEW

Answer & Solution Discuss in Board Save for Later

40.
Which of these can be used in place of MYSQL_SERVER_VERSION?

A. LIBMYSQL_VERSION

B. LIBMYSQL_VERSION_ID

C. MYSQL_VERSION_ID

D. MYSQL_ID

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

MySQL mcq questions and answers | MySQL MCQs

31. Which of these grant table scope columns is case insensitive?

Answer & Solution

32. The option that supplies the pathname to root directory of MySQL installation is . . . . . . . .

Answer & Solution

33. Which among the following operators is/are belongs to "Equality conditions"?

Answer & Solution

34. What is the durability property of transactions?

Answer & Solution

35. The disk data that the FILES table in INFORMATION_SCHEMA stores is . . . . . . . .

Answer & Solution

36. Prior to MySQL 6.0, utf8 was . . . . . . . .

Answer & Solution

37. Which Clause is used to sort the stored data in alphabetical order?

Answer & Solution

38. Triggers and events are invoked automatically by the server.

Answer & Solution

39. Which of these is also known as a virtual table?

Answer & Solution

40. Which of these can be used in place of MYSQL_SERVER_VERSION?

Answer & Solution

Read More Section(MySQL Miscellaneous)

31.
Which of these grant table scope columns is case insensitive?

32.
The option that supplies the pathname to root directory of MySQL installation is . . . . . . . .

33.
Which among the following operators is/are belongs to "Equality conditions"?

34.
What is the durability property of transactions?

35.
The disk data that the FILES table in INFORMATION_SCHEMA stores is . . . . . . . .

36.
Prior to MySQL 6.0, utf8 was . . . . . . . .

37.
Which Clause is used to sort the stored data in alphabetical order?

38.
Triggers and events are invoked automatically by the server.

39.
Which of these is also known as a virtual table?

40.
Which of these can be used in place of MYSQL_SERVER_VERSION?