What does asterisk (*) means in SQL?
a) all columns of table are obtained
b) all records are obtained
c) all records with partial criteria obtained
d) none of these
Which SQL command is used to specify the rows to be selected?
a) EXISTS
b) where
c) From
d) Set
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
