Loading, please wait...

SQL (Structured Query Language) 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 

21. A subquery in an SQL SELECT statement is enclosed in:

  • parenthesis -- (...).
  • brackets -- [...].
  • CAPITAL LETTERS.
  • braces -- {...}.

22. The result of a SQL SELECT statement is a ______

  • FILE
  • REPORT
  • TABLE
  • FORM

23. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

  • all columns of the table are to be returned.
  • all records meeting the full criteria are to be returned.
  • all records with even partial criteria met are to be returned.
  • None of the above is correct.

24. The HAVING clause does which of the following?

  • Acts EXACTLY like a WHERE clause.
  • Acts like a WHERE clause but is used for columns rather than groups.
  • Acts like a WHERE clause but is used for groups rather than rows.
  • Acts like a WHERE clause but is used for rows rather than columns.

25. Which of the following do you need to consider when you make a table in SQL?

  • Data types
  • Primary keys
  • Default values
  • All of the mentioned