Which built-in function is used to compute smallest value of numeric columns?
a) Lowest
b) MAX
c) MIN
d) count
Which SQL keyword is used to group rows that have the same values in specified column?
a) Group by
b) Order by
c) Select
d) Sort by
Which SQL keyword is used with GROUP BY to select groups meeting specified criteria?
a) AND
b) EXISTS
c) HAVING
d) IN
Which of the following is the correct command to create table?
a) make table
b) create table
c) draw table
d) drop table
Which SQL command is used to implement a subquery?
a) Group by
b) Order by
c) Select
d) Sort by
When is one SQL query embedded in where clause of another SQL query is called?
a) subset
b) joins
c) where query
d) subquery
