MCQs – SQL Basics

(Last Updated On: March 28, 2018)

Q) To specify the number of records to return, which keyword is used

  1. FIRST
  2. TOP
  3. START
  4. ROW
View Answer
Answer: B
To return specific number of records, SQL Server uses TOP, MYSQL database uses LIMIT and Oracle database uses ROWNUM.

 

Q) To search for a specified pattern in a column

  1. SQL MATCH
  2. SQL LIKE
  3. SQL PATTERN
  4. SQL SEARCH
View Answer
Answer: B


Q) Which clause is used to combine rows from two or more tables based on a related column between them.

  1. SQL MATCH
  2. SQL JOIN
  3. SQL PATTERN
  4. NONE
View Answer
Answer: B


Q) To combine the result-set of two or more SELECT statements, SQL clause used is

  1. SQL UNION
  2. SQL JOIN
  3. SQL GROUP BY
  4. NONE
View Answer
Answer: A

SQL Join statement is used to combine result set from two or more tables.