General Questions

Question 11 :

The SQL keyword(s) ________ is used with wildcards.


A). LIKE only
B). IN only
C). NOT IN only
D). IN and NOT IN
Answer : Option A

Question 12 :

Which of the following is the correct order of keywords for SQL SELECT statements?


A). SELECT, FROM, WHERE
B). FROM, WHERE, SELECT
C). WHERE, FROM,SELECT
D). SELECT,WHERE,FROM
Answer : Option A

Question 13 :

A subquery in an SQL SELECT statement is enclosed in:


A). braces -- {...}.
B). CAPITAL LETTERS.
C). parenthesis -- (...) .
D). brackets -- [...].
Answer : Option C

Question 14 :

The result of a SQL SELECT statement is a(n) ________ .


A). report
B). form
C). file
D). table
Answer : Option D

Question 15 :

Which of the following are the five built-in functions provided by SQL?


A). COUNT, SUM, AVG, MAX, MIN
B). SUM, AVG, MIN, MAX, MULT
C). SUM, AVG, MULT, DIV, MIN
D). SUM, AVG, MIN, MAX, NAME
Answer : Option A