MySQL mcq questions and answers | MySQL MCQs Page-8 section-9

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

71.
In which mode is the indicator of the presence/absence of a word in search used?

A. Natural language

B. Boolean mode

C. Query expansion

D. Cross mode

Answer & Solution Discuss in Board Save for Later

72.
The column not returned by 'OPTIMIZE TABLE' is . . . . . . . .

A. Table

B. Msg_txt

C. Op

D. Msg_type

Answer & Solution Discuss in Board Save for Later

73.

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command?

SELECT emp_id
FROM person
ORDER BY emp_id DESC;

A. {9, 7, 6, 4, 3, 1, 2}

B. {1, 2, 3, 4, 6, 7, 9}

C. {2, 1, 3, 4, 6, 7, 9}

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

74.
MySQL provides a date type that has an optional time part.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

75.
There is a startup penalty for a standalone interpreter.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

76.
"CREATE TABLE ..." command is used to create which type of table in Mysql?

A. Permanent Tables

B. Virtual tables

C. Temporary tables

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

77.
What sets the association between one or more MyISAM tables and the named key cache?

A. BEGIN

B. CACHE INDEX

C. ALTER DATABASE

D. ALTER EVENT

Answer & Solution Discuss in Board Save for Later

78.

The one that is more restrictive is . . . . . . . .

mysql_query(), mysql_real_query()

A. mysql_query()

B. mysql_real_query()

C. same

D. machine dependent

Answer & Solution Discuss in Board Save for Later

79.
The keyword used with UNION that retains duplicate rows is . . . . . . . .

A. ALL

B. NARROW

C. STRICT

D. DISTINCT

Answer & Solution Discuss in Board Save for Later

80.

What is 'xyz' in the following SQL statement?

SELECT abc FROM xyz;

A. row name

B. column name

C. table name

D. database name

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

71.
In which mode is the indicator of the presence/absence of a word in search used?

Answer & Solution

72.
The column not returned by 'OPTIMIZE TABLE' is . . . . . . . .

Answer & Solution

73.
If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command?

`SELECT emp_id FROM person ORDER BY emp_id DESC;`

Answer & Solution

74.
MySQL provides a date type that has an optional time part.

Answer & Solution

75.
There is a startup penalty for a standalone interpreter.

Answer & Solution

76.
"CREATE TABLE ..." command is used to create which type of table in Mysql?

Answer & Solution

77.
What sets the association between one or more MyISAM tables and the named key cache?

Answer & Solution

78.
The one that is more restrictive is . . . . . . . .

`mysql_query(), mysql_real_query()`

Answer & Solution

79.
The keyword used with UNION that retains duplicate rows is . . . . . . . .

Answer & Solution

80.
What is 'xyz' in the following SQL statement?

`SELECT abc FROM xyz;`

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

71. In which mode is the indicator of the presence/absence of a word in search used?

Answer & Solution

72. The column not returned by 'OPTIMIZE TABLE' is . . . . . . . .

Answer & Solution

73. If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command? SELECT emp_id FROM person ORDER BY emp_id DESC;

Answer & Solution

74. MySQL provides a date type that has an optional time part.

Answer & Solution

75. There is a startup penalty for a standalone interpreter.

Answer & Solution

76. "CREATE TABLE ..." command is used to create which type of table in Mysql?

Answer & Solution

77. What sets the association between one or more MyISAM tables and the named key cache?

Answer & Solution

78. The one that is more restrictive is . . . . . . . . mysql_query(), mysql_real_query()

Answer & Solution

79. The keyword used with UNION that retains duplicate rows is . . . . . . . .

Answer & Solution

80. What is 'xyz' in the following SQL statement? SELECT abc FROM xyz;

Answer & Solution

Read More Section(MySQL Miscellaneous)

71.
In which mode is the indicator of the presence/absence of a word in search used?

72.
The column not returned by 'OPTIMIZE TABLE' is . . . . . . . .

73.
If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command?

`SELECT emp_id FROM person ORDER BY emp_id DESC;`

74.
MySQL provides a date type that has an optional time part.

75.
There is a startup penalty for a standalone interpreter.

76.
"CREATE TABLE ..." command is used to create which type of table in Mysql?

77.
What sets the association between one or more MyISAM tables and the named key cache?

78.
The one that is more restrictive is . . . . . . . .

`mysql_query(), mysql_real_query()`

79.
The keyword used with UNION that retains duplicate rows is . . . . . . . .

80.
What is 'xyz' in the following SQL statement?

`SELECT abc FROM xyz;`