MySQL mcq questions and answers | MySQL MCQs Page-2 section-12

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.
Which among the following is not a "query clause"?

A. WHERE

B. MODIFY

C. ALTER

D. FROM

Answer & Solution Discuss in Board Save for Later

12.
The function used to convert an int to string is . . . . . . . .

A. INET_ATON()

B. INET_NTOA()

C. INET_ITOS()

D. INET_STOI()

Answer & Solution Discuss in Board Save for Later

13.
By default, the AUTO_INCREMENT sequences begin at . . . . . . . .

A. 0

B. 1

C. -1

D. 2

Answer & Solution Discuss in Board Save for Later

14.
Which MySQL statement is used to find out which character sets are available?

A. SHOW CHARACTER SET

B. SHOW COLLATION

C. SHOW CHARACTER SETS

D. SHOW COLLATIONS

Answer & Solution Discuss in Board Save for Later

15.
In Perl DBI, functions are called . . . . . . . .

A. functions

B. procedures

C. methods

D. programs

Answer & Solution Discuss in Board Save for Later

16.
Suppose a stored function named PI() is written in the database 'sampdb'. How would it be called?

A. PI()

B. sampdb.PI()

C. MySQL.PI()

D. db.PI()

Answer & Solution Discuss in Board Save for Later

17.
Which string function returns the index of the first occurrence of substring?

A. INSERT()

B. INSTR()

C. INSTRING()

D. INFSTR()

Answer & Solution Discuss in Board Save for Later

18.
The server sets its default time zone by examining its environment.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

19.
The superuser account of the grant tables in the mysql database is called . . . . . . . .

A. super

B. prime

C. root

D. leaf

Answer & Solution Discuss in Board Save for Later

20.
While using DBI API functions are called and pointers to structures are used.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9

MySQL mcq questions and answers | MySQL MCQs

11. Which among the following is not a "query clause"?

Answer & Solution

12. The function used to convert an int to string is . . . . . . . .

Answer & Solution

13. By default, the AUTO_INCREMENT sequences begin at . . . . . . . .

Answer & Solution

14. Which MySQL statement is used to find out which character sets are available?

Answer & Solution

15. In Perl DBI, functions are called . . . . . . . .

Answer & Solution

16. Suppose a stored function named PI() is written in the database 'sampdb'. How would it be called?

Answer & Solution

17. Which string function returns the index of the first occurrence of substring?

Answer & Solution

18. The server sets its default time zone by examining its environment.

Answer & Solution

19. The superuser account of the grant tables in the mysql database is called . . . . . . . .

Answer & Solution

20. While using DBI API functions are called and pointers to structures are used.

Answer & Solution

Read More Section(MySQL Miscellaneous)

11.
Which among the following is not a "query clause"?

12.
The function used to convert an int to string is . . . . . . . .

13.
By default, the AUTO_INCREMENT sequences begin at . . . . . . . .

14.
Which MySQL statement is used to find out which character sets are available?

15.
In Perl DBI, functions are called . . . . . . . .

16.
Suppose a stored function named PI() is written in the database 'sampdb'. How would it be called?

17.
Which string function returns the index of the first occurrence of substring?

18.
The server sets its default time zone by examining its environment.

19.
The superuser account of the grant tables in the mysql database is called . . . . . . . .

20.
While using DBI API functions are called and pointers to structures are used.