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

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

51.
What produces result sets?

A. View

B. SELECT

C. Stored function

D. Trigger

Answer & Solution Discuss in Board Save for Later

52.
Which command is used to redefined the mysql delimiter?

A. redefine_delim

B. delim_redefine

C. delimiter

D. redefine

Answer & Solution Discuss in Board Save for Later

53.
How is the binary log rotated?

A. FLUSH LOGS

B. ROTATE LOGS

C. FLUSH BINLOG

D. ROTATE BINLOG

Answer & Solution Discuss in Board Save for Later

54.
The place where the server stores its databases and status files are called the data directory.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

55.
Which script initializes the data directory during installation?

A. mysql_install_db

B. mysql_install_dbm

C. mysql_init_db

D. mysql_init_dbm

Answer & Solution Discuss in Board Save for Later

56.
The mode used to turn off the special meaning of backslash and treat it as an ordinary character is . . . . . . . .

A. NO_ESCAPES_SLASH

B. NO_ESCAPES_BACKSLASH

C. NO_BACKSLASH_ESCAPES

D. NO_BACKSLASH_ESCAPE

Answer & Solution Discuss in Board Save for Later

57.
Which of the following columns is not returned by 'OPTIMIZE TABLE'?

A. Table

B. Op

C. Msg_type

D. Msg_txt

Answer & Solution Discuss in Board Save for Later

58.
What is the name of the format file for a table named my_tbl?

A. my_tbl.fmt

B. my_tbl.frm

C. my_tbl.fmr

D. my_tbl.ftm

Answer & Solution Discuss in Board Save for Later

59.
The Perl DBI is . . . . . . . .

A. database inheritance

B. database integrity

C. database interface

D. database isolation

Answer & Solution Discuss in Board Save for Later

60.
Select odd one out?

A. Equality Conditions

B. Inequality Conditions

C. Range condition

D. Between

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

51. What produces result sets?

Answer & Solution

52. Which command is used to redefined the mysql delimiter?

Answer & Solution

53. How is the binary log rotated?

Answer & Solution

54. The place where the server stores its databases and status files are called the data directory.

Answer & Solution

55. Which script initializes the data directory during installation?

Answer & Solution

56. The mode used to turn off the special meaning of backslash and treat it as an ordinary character is . . . . . . . .

Answer & Solution

57. Which of the following columns is not returned by 'OPTIMIZE TABLE'?

Answer & Solution

58. What is the name of the format file for a table named my_tbl?

Answer & Solution

59. The Perl DBI is . . . . . . . .

Answer & Solution

60. Select odd one out?

Answer & Solution

Read More Section(MySQL Miscellaneous)

51.
What produces result sets?

52.
Which command is used to redefined the mysql delimiter?

53.
How is the binary log rotated?

54.
The place where the server stores its databases and status files are called the data directory.

55.
Which script initializes the data directory during installation?

56.
The mode used to turn off the special meaning of backslash and treat it as an ordinary character is . . . . . . . .

57.
Which of the following columns is not returned by 'OPTIMIZE TABLE'?

58.
What is the name of the format file for a table named my_tbl?

59.
The Perl DBI is . . . . . . . .

60.
Select odd one out?