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

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

91.

Which of the following does not return a value?

mysql_close(), mysql_init, mysql_real_connect

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

92.
Which statement is used to see the definition for an existing database?

A. SHOW CREATE DATABASE

B. SHOW DATABASE

C. SHOW CREATE

D. SHOW CREATE DATABASE TABLE

Answer & Solution Discuss in Board Save for Later

93.
What enables encrypted connections to be established?

A. exec_stmt_ssl

B. exec_ssl_stmt

C. exec_stmnt_ssl

D. exec_ssl_stmnt

Answer & Solution Discuss in Board Save for Later

94.
Which variable returns code from operations that return true or false?

A. $rc

B. $rv

C. $rows

D. $ary

Answer & Solution Discuss in Board Save for Later

95.
In which mode of search is the search string parsed into words and the search looks for rows?

A. Natural language

B. Boolean mode

C. Query expansion

D. Cross mode

Answer & Solution Discuss in Board Save for Later

96.
The most general purpose language is . . . . . . . .

A. C

B. Perl

C. Python

D. PHP

Answer & Solution Discuss in Board Save for Later

97.
What is used to produce a new string from an old string in the desired character set?

A. Introducers

B. CONVERT()

C. CONVERTER()

D. CONVERTS()

Answer & Solution Discuss in Board Save for Later

98.

What will be the output of the following MySQL command?

SELECT emp_id, fname, lname
FROM employee
WHERE title=’HEAD TELLER’;

A. All columns

B. Only those columns which are mention with "SELECT" clause

C. Columns mention with "SELECT" clause and only those rows which contain 'HEAD TELLER' as a "title"

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

99.
The log that identifies statements that may be in need of being rewritten for better performance is . . . . . . . .

A. error log

B. general query

C. slow query log

D. binary log

Answer & Solution Discuss in Board Save for Later

100.
Which of the following statements is/are correct?

A. True OR true =true

B. True OR false= true

C. False OR false= false

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

91.
Which of the following does not return a value?

`mysql_close(), mysql_init, mysql_real_connect`

Answer & Solution

92.
Which statement is used to see the definition for an existing database?

Answer & Solution

93.
What enables encrypted connections to be established?

Answer & Solution

94.
Which variable returns code from operations that return true or false?

Answer & Solution

95.
In which mode of search is the search string parsed into words and the search looks for rows?

Answer & Solution

96.
The most general purpose language is . . . . . . . .

Answer & Solution

97.
What is used to produce a new string from an old string in the desired character set?

Answer & Solution

98.
What will be the output of the following MySQL command?

`SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’;`

Answer & Solution

99.
The log that identifies statements that may be in need of being rewritten for better performance is . . . . . . . .

Answer & Solution

100.
Which of the following statements is/are correct?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

91. Which of the following does not return a value? mysql_close(), mysql_init, mysql_real_connect

Answer & Solution

92. Which statement is used to see the definition for an existing database?

Answer & Solution

93. What enables encrypted connections to be established?

Answer & Solution

94. Which variable returns code from operations that return true or false?

Answer & Solution

95. In which mode of search is the search string parsed into words and the search looks for rows?

Answer & Solution

96. The most general purpose language is . . . . . . . .

Answer & Solution

97. What is used to produce a new string from an old string in the desired character set?

Answer & Solution

98. What will be the output of the following MySQL command? SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’;

Answer & Solution

99. The log that identifies statements that may be in need of being rewritten for better performance is . . . . . . . .

Answer & Solution

100. Which of the following statements is/are correct?

Answer & Solution

Read More Section(MySQL Miscellaneous)

91.
Which of the following does not return a value?

`mysql_close(), mysql_init, mysql_real_connect`

92.
Which statement is used to see the definition for an existing database?

93.
What enables encrypted connections to be established?

94.
Which variable returns code from operations that return true or false?

95.
In which mode of search is the search string parsed into words and the search looks for rows?

96.
The most general purpose language is . . . . . . . .

97.
What is used to produce a new string from an old string in the desired character set?

98.
What will be the output of the following MySQL command?

`SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’;`

99.
The log that identifies statements that may be in need of being rewritten for better performance is . . . . . . . .

100.
Which of the following statements is/are correct?