Loading, please wait...

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

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

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

  • 55
  • 72
  • 64
  • 40

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

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.*;