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

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.
Which Numeric Data type has the largest range?

A. Mediumint

B. Smallint

C. Int

D. Tinyint

Answer & Solution Discuss in Board Save for Later

42.
If the operands are non binary strings, LIKE compares them according to their collation.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

43.
Which clause is used to determine "which column to include in the query sets"?

A. SELECT

B. FROM

C. WHERE

D. ORDER BY

Answer & Solution Discuss in Board Save for Later

44.
Which myisamchk variable represents the size of buffer used to hold index blocks?

A. key_buffer_size

B. read_buffer_size

C. sort_buffer_size

D. write_buffer_size

Answer & Solution Discuss in Board Save for Later

45.
Which command is used in Mysql command line tool to return to window command shell?

A. exit;

B. quit;

C. both exit; and quit;

D. only exit;

Answer & Solution Discuss in Board Save for Later

46.
Select the sequence for how the query mechanism works?

A. Authentication-> DDL->DML->query optimizer->output

B. DDL->DML->query optimizer-> Authentication->output

C. DML->query optimizer-> Authentication-> DDL-> output

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

47.
Which key declares that an index in one table is related to that in another?

A. primary

B. secondary

C. foreign

D. cross

Answer & Solution Discuss in Board Save for Later

48.
The statement that alters an existing event to have the given definition is . . . . . . . .

A. ALTER EVENT

B. ALTER DATABASE

C. ALTER FUNCTION

D. None of the above

Answer & Solution Discuss in Board Save for Later

49.
In 'mysqldump' which option is used to make all tables in the destination databases to use a different storage engine?

A. -next-storage-engine

B. -new-storage-engine

C. -clear-storage-engine

D. -get-storage-engine

Answer & Solution Discuss in Board Save for Later

50.
Which one is the correct declaration for choosing the character set other than default?

A. Varchar(20) character set utf8;

B. Varchar(20);

C. Varchar(20) character set;

D. None of the mentioned

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

41. Which Numeric Data type has the largest range?

Answer & Solution

42. If the operands are non binary strings, LIKE compares them according to their collation.

Answer & Solution

43. Which clause is used to determine "which column to include in the query sets"?

Answer & Solution

44. Which myisamchk variable represents the size of buffer used to hold index blocks?

Answer & Solution

45. Which command is used in Mysql command line tool to return to window command shell?

Answer & Solution

46. Select the sequence for how the query mechanism works?

Answer & Solution

47. Which key declares that an index in one table is related to that in another?

Answer & Solution

48. The statement that alters an existing event to have the given definition is . . . . . . . .

Answer & Solution

49. In 'mysqldump' which option is used to make all tables in the destination databases to use a different storage engine?

Answer & Solution

50. Which one is the correct declaration for choosing the character set other than default?

Answer & Solution

Read More Section(MySQL Miscellaneous)

41.
Which Numeric Data type has the largest range?

42.
If the operands are non binary strings, LIKE compares them according to their collation.

43.
Which clause is used to determine "which column to include in the query sets"?

44.
Which myisamchk variable represents the size of buffer used to hold index blocks?

45.
Which command is used in Mysql command line tool to return to window command shell?

46.
Select the sequence for how the query mechanism works?

47.
Which key declares that an index in one table is related to that in another?

48.
The statement that alters an existing event to have the given definition is . . . . . . . .

49.
In 'mysqldump' which option is used to make all tables in the destination databases to use a different storage engine?

50.
Which one is the correct declaration for choosing the character set other than default?