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

91.

What is the significance of "ORDER BY" in the following MySQL statement?

SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id;

A. Data of emp_id will be sorted

B. Data of emp_id will be sorted in descending order

C. Data of emp_id will be sorted in ascending order

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

92.
A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

93.

In the following MySQL command how many rows will be updated?

UPDATE person
SET lname=’s’,
Fname = ’p’,
WHERE person_id = 1;
/* person_id is a primary key */

A. Single row

B. Double row

C. No row

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

94.
Which of these operators does not perform relative value comparisons?

A. =

B. ==

C. <=

D. >=

Answer & Solution Discuss in Board Save for Later

95.
Which header should be included first?

A. my_global.h

B. my_sys.h

C. mysql.h

D. my_local.h

Answer & Solution Discuss in Board Save for Later

96.
In oracle database variable length column is declared by . . . . . . . .

A. Varchar

B. Varchar 3

C. Varchar2

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

97.
What is the isolation property of transactions?

A. statements form a logic unit

B. database remains consistent

C. one transaction does not affect the other

D. transaction effects are recorded permanently

Answer & Solution Discuss in Board Save for Later

98.
What is the SQL mode to check for divide by zero error?

A. STRICT_ALL_TABLES

B. ERROR_FOR_DIVISION_BY_ZERO

C. ERROR_DIVIDE_BY_ZERO

D. ERROR_WHEN_DIVIDE_BY_ZERO

Answer & Solution Discuss in Board Save for Later

99.
What returns a string containing an error message?

A. mysql_error()

B. mysql_errno()

C. mysql_sqlstate()

D. mysql_close()

Answer & Solution Discuss in Board Save for Later

100.
Which of the following returns a MySQL-specific numeric code?

A. mysql_error()

B. mysql_errno()

C. mysql_sqlstate()

D. mysql_close()

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

91.
What is the significance of "ORDER BY" in the following MySQL statement?

`SELECT emp_id, fname, lname FROM person ORDER BY emp_id;`

Answer & Solution

92.
A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.

Answer & Solution

93.
In the following MySQL command how many rows will be updated?

`UPDATE person SET lname=’s’, Fname = ’p’, WHERE person_id = 1; /* person_id is a primary key */`

Answer & Solution

94.
Which of these operators does not perform relative value comparisons?

Answer & Solution

95.
Which header should be included first?

Answer & Solution

96.
In oracle database variable length column is declared by . . . . . . . .

Answer & Solution

97.
What is the isolation property of transactions?

Answer & Solution

98.
What is the SQL mode to check for divide by zero error?

Answer & Solution

99.
What returns a string containing an error message?

Answer & Solution

100.
Which of the following returns a MySQL-specific numeric code?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

91. What is the significance of "ORDER BY" in the following MySQL statement? SELECT emp_id, fname, lname FROM person ORDER BY emp_id;

Answer & Solution

92. A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.

Answer & Solution

93. In the following MySQL command how many rows will be updated? UPDATE person SET lname=’s’, Fname = ’p’, WHERE person_id = 1; /* person_id is a primary key */

Answer & Solution

94. Which of these operators does not perform relative value comparisons?

Answer & Solution

95. Which header should be included first?

Answer & Solution

96. In oracle database variable length column is declared by . . . . . . . .

Answer & Solution

97. What is the isolation property of transactions?

Answer & Solution

98. What is the SQL mode to check for divide by zero error?

Answer & Solution

99. What returns a string containing an error message?

Answer & Solution

100. Which of the following returns a MySQL-specific numeric code?

Answer & Solution

Read More Section(MySQL Miscellaneous)

91.
What is the significance of "ORDER BY" in the following MySQL statement?

`SELECT emp_id, fname, lname FROM person ORDER BY emp_id;`

92.
A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.

93.
In the following MySQL command how many rows will be updated?

`UPDATE person SET lname=’s’, Fname = ’p’, WHERE person_id = 1; /* person_id is a primary key */`

94.
Which of these operators does not perform relative value comparisons?

95.
Which header should be included first?

96.
In oracle database variable length column is declared by . . . . . . . .

97.
What is the isolation property of transactions?

98.
What is the SQL mode to check for divide by zero error?

99.
What returns a string containing an error message?

100.
Which of the following returns a MySQL-specific numeric code?