MySQL mcq questions and answers | MySQL MCQs Page-4 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

31.
MySQL client runs on the machine containing the databases and servers connect to the client over a network.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

32.
Which mode does not remove trailing spaces when CHAR values are retrieved?

A. PAD_CHAR_TO_FULL_LENGTH

B. TO_FULL_LENGTH_CHAR_PAD

C. CHAR_PAD_TO_FULL_LENGTH

D. PAD_CHAR_TO_LENGTH

Answer & Solution Discuss in Board Save for Later

33.
If an integer column is used for the values in range 1 to 99999, the best suitable datatype is . . . . . . . .

A. MEDIUMINT SIGNED

B. MEDIUMINT UNSIGNED

C. SMALLINT SIGNED

D. SMALLINT UNSIGNED

Answer & Solution Discuss in Board Save for Later

34.
The mantissa in -1.58E5 is . . . . . . . .

A. -1.58

B. 1.58

C. E

D. 5

Answer & Solution Discuss in Board Save for Later

35.
The protocol CGI is . . . . . . . .

A. computer graphics interface

B. common graphics interface

C. computer gateway interface

D. common gateway interface

Answer & Solution Discuss in Board Save for Later

36.
What represents a 'tuple' in a relational database?

A. Table

B. Row

C. Column

D. Object

Answer & Solution Discuss in Board Save for Later

37.
Which of these is defined to execute when the table is modified only?

A. Stored functions

B. Stored procedures

C. Triggers

D. Events

Answer & Solution Discuss in Board Save for Later

38.
Which mode is used to turn off the special meaning of backslash and treat it as an ordinary character?

A. NO_ESCAPES_SLASH

B. NO_ESCAPES_BACKSLASH

C. NO_BACKSLASH_ESCAPES

D. NO_BACKSLASH_ESCAPE

Answer & Solution Discuss in Board Save for Later

39.
Before MySQL 5.1.6 which privilege was required to create and drop triggers?

A. PRIVILEGE

B. TRIGGER

C. SUPER

D. MACRO

Answer & Solution Discuss in Board Save for Later

40.
Which of these exports table definitions and contents?

A. mysqldump

B. mysqladmin

C. mysqlimport

D. mysqlexport

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. MySQL client runs on the machine containing the databases and servers connect to the client over a network.

Answer & Solution

32. Which mode does not remove trailing spaces when CHAR values are retrieved?

Answer & Solution

33. If an integer column is used for the values in range 1 to 99999, the best suitable datatype is . . . . . . . .

Answer & Solution

34. The mantissa in -1.58E5 is . . . . . . . .

Answer & Solution

35. The protocol CGI is . . . . . . . .

Answer & Solution

36. What represents a 'tuple' in a relational database?

Answer & Solution

37. Which of these is defined to execute when the table is modified only?

Answer & Solution

38. Which mode is used to turn off the special meaning of backslash and treat it as an ordinary character?

Answer & Solution

39. Before MySQL 5.1.6 which privilege was required to create and drop triggers?

Answer & Solution

40. Which of these exports table definitions and contents?

Answer & Solution

Read More Section(MySQL Miscellaneous)

31.
MySQL client runs on the machine containing the databases and servers connect to the client over a network.

32.
Which mode does not remove trailing spaces when CHAR values are retrieved?

33.
If an integer column is used for the values in range 1 to 99999, the best suitable datatype is . . . . . . . .

34.
The mantissa in -1.58E5 is . . . . . . . .

35.
The protocol CGI is . . . . . . . .

36.
What represents a 'tuple' in a relational database?

37.
Which of these is defined to execute when the table is modified only?

38.
Which mode is used to turn off the special meaning of backslash and treat it as an ordinary character?

39.
Before MySQL 5.1.6 which privilege was required to create and drop triggers?

40.
Which of these exports table definitions and contents?