module 7 part #3

Question 1

The special operator used to check whether an attribute value matches a given string pattern is _____.
a. BETWEEN b. IS NULL
c. LIKE d. IN

Answer 1

c. LIKE

Question 2

A(n) _____ is a query that is embedded (or nested) inside another query.
a. alias
b. operator
c. subquery
d. view

Answer 2

c. subquery

Question 3

3. Which of the following queries is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?
   a. SELECT ONLY V_CODE FROM PRODUCT;
   b. SELECT UNIQUE V_CODE FROM PRODUCT;
   c. SELECT DIFFERENT V_CODE FROM PRODUCT;
   d. SELECT DISTINCT V_CODE FROM PRODUCT;

Answer 3

d. SELECT DISTINCT V_CODE FROM PRODUCT;

Question 4

A(n) _____ is an alternate name given to a column or table in any SQL statement.
Alias
Data type
Stored function
Trigger

Answer 4

Alias

Question 5

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE

Answer 5

b. SELECT

Question 6

According to the rules of precedence, which of the following computations should be completed first?

a. Additions and subtractions
b. Multiplications and divisions
c. Operations within parentheses
d. Power operations

Answer 6

c. Operations within parentheses

Question 7

An alias is especially useful when a table must be joined to itself in a(n) _____ query.

Answer 7

SELF JOIN