Loading, please wait...

Become An Author

My SQL MCQ Quiz (Multiple Choice Questions And Answers)

Search here for MCQs

Are you preparing for the next job interviews? If yes, trust me this post will help you also we'll suggest you check out a big collection for Programming Full Forms that may help you in your interview:

List of Programming Full Forms 

26. Which statement is used to count number of rows in table?

  • SELECT COUNT(*) FROM table_name;
  • SELECT COUNT ALL(*) FROM table_name;
  • SELECT ROWS(*) FROM table_name;
  • All of the above
View Answer

27.  In a LIKE clause, you can could ask for any value ending in “ton” by writing?

  • LIKE ton$
  • LIKE ^.*ton$
  • LIKE %ton
  • LIKE .*ton
View Answer

28. How much character are allowed to create database name?

  • 55
  • 72
  • 64
  • 40
View Answer

29. Commands passed to the MySQL daemon are written in

  • English
  • Your choice from Perl, PHP, Java or some other languages
  • the Structured Query Language
  • Swedish
View Answer

30.  If you’re writing a client using the C language API, your source code should include the following line at the top:

  •  use mysql;
  • include (“mysql.h”);
  • #include
  • import com.mysql.*;
View Answer

JOIN TUTORIALS LINK

Our Newsletter Will Let You Know When Any New
Articles, Tutorials and Video Are Released.

CONTRIBUTE

MOBILE APP

Google Play

Follow us

Copyright © 2024. All Rights Reserved.