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

11.
The function returning reference to array of row values is . . . . . . . .

A. fetchrow_array()

B. fetchrow_arrayref()

C. fetch()

D. fetchrow_hashref()

Answer & Solution Discuss in Board Save for Later

12.
Which of these is a read only variable?

A. error_count

B. big_tables

C. autocommit

D. foreign_key_checks

Answer & Solution Discuss in Board Save for Later

13.
MySQL stores the database character set and collation attributes in the file . . . . . . . .

A. dp.opt

B. db.opt

C. db.sv

D. db.zip

Answer & Solution Discuss in Board Save for Later

14.
The MySQL APIs are libraries to connect applications to database servers.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

15.
Fill the blanks with suitable options?
BETWEEN . . . . . . . . AND . . . . . . . .

A. Upper and lower limit

B. Lower and upper limit

C. Upper and upper limit

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

16.
MySQL can be used to execute script files.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

17.
Multiple statement execution is not enabled by default.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

18.
If COLLATE is given without CHARACTER SET, the first part of the collation name gives the character set.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

19.
0x61 + 0 results in . . . . . . . .

A. 0

B. 'a'

C. 97

D. arbitrary

Answer & Solution Discuss in Board Save for Later

20.
It is not required to have an access privilege for a database before selecting it with 'USE'.

A. True

B. False

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

11. The function returning reference to array of row values is . . . . . . . .

Answer & Solution

12. Which of these is a read only variable?

Answer & Solution

13. MySQL stores the database character set and collation attributes in the file . . . . . . . .

Answer & Solution

14. The MySQL APIs are libraries to connect applications to database servers.

Answer & Solution

15. Fill the blanks with suitable options? BETWEEN . . . . . . . . AND . . . . . . . .

Answer & Solution

16. MySQL can be used to execute script files.

Answer & Solution

17. Multiple statement execution is not enabled by default.

Answer & Solution

18. If COLLATE is given without CHARACTER SET, the first part of the collation name gives the character set.

Answer & Solution

19. 0x61 + 0 results in . . . . . . . .

Answer & Solution

20. It is not required to have an access privilege for a database before selecting it with 'USE'.

Answer & Solution

Read More Section(MySQL Miscellaneous)

11.
The function returning reference to array of row values is . . . . . . . .

12.
Which of these is a read only variable?

13.
MySQL stores the database character set and collation attributes in the file . . . . . . . .

14.
The MySQL APIs are libraries to connect applications to database servers.

15.
Fill the blanks with suitable options?
BETWEEN . . . . . . . . AND . . . . . . . .

16.
MySQL can be used to execute script files.

17.
Multiple statement execution is not enabled by default.

18.
If COLLATE is given without CHARACTER SET, the first part of the collation name gives the character set.

19.
0x61 + 0 results in . . . . . . . .

20.
It is not required to have an access privilege for a database before selecting it with 'USE'.