Which operator performs pattern matching ?

1. BETWEEN operator
2. LIKE operator
3. EXISTS operator
4. None of these

Consider the following query

SELECT name FROM class WHERE subject LIKE ' ............... Computer Science' ;

Which one of the following has to be added into the blank space to select the subject which has Computer Science as its ending string ?

1. $\text{\textdollar}$
2. _
3. ||
4. \%

The pattern '_ _ _' matches any string of …………… three characters. '_ _ _%' matches any string of …………… three characters.

1. Atleast, Exactly
2. Exactly, Atleast
3. Atleast, All
4. All, Exactly

By default, ORDER BY clause lists the results in …………… order.

1. Descending
2. Any
3. Same
4. Ascending