Which keyword is used to remove one or more rows from table?
a) CHANGE
b) Delete
c) SELECT
d) Erase
When does where clause cannot refer to range and to partial values?
a) keyword LIKE is used
b) keyword BETWEEN is used
c) keyword NULL is used
d) keyword ALSO is used
Which of the following are the five built-in functions provided by SQL?
a) COUNT, MAX, MIN, AVG, SUM
b) COUNT, MAX, MIN, AVG, MULT
c) COUNT, MAX, MIN, AVG, DIV
d) COUNT, MAX, MIN, AVG, NAME
The SQL keyword GROUP BY instruct the DBMS……..
a) to physically group together
b) group together same values of column
c) both a & b
d) none of these
A subquery must be in……..
a) bold
b) capital letters
c) parenthesis
d) italics
Which of the following is true about join?
a) join can be used as an alternative
b) join is combination of product operation
c) join is product of select
d) join can be used for two tables
