Which SQL command is used to join two conditions that both must be true?
a) EXISTS
b) update
c) AND
d) Set
Which SQL keyword is used to determine, if a column value is equal
to any one of a set of values?
a) EXISTS
b) IN
c) AND
d) Set
Which of the following function is used to compute the number of rows in a table?
a) AVG
b) MAX
c) MIN
d) count
Which built-in function is used to compute total numeric columns?
a) AVG
b) MAX
c) SUM
d) count
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
