Which built-in function is used to compute average value of numeric columns?
a) AVG
b) MAX
c) SUM
d) count
Which built-in function is used to compute largest value of numeric columns?
a) AVG
b) MAX
c) SUM
d) count
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
