Question

QUESTION 32

1. Which statement can be used for conditional queries equal to if-then-else

   		CASE
   		WHERE
   		DISTINCT
   		DECODE

2.5 points   

QUESTION 33

1. The GROUP BY clause comes before the ORDER BY clause

   True

   False

2.5 points   

QUESTION 34

1. In the statement: SELECT Order_Item from orders o where order_id=1001; the "o" is a

   		column alias
   		table alias
   		part of the column name
   		a join operator

2.5 points   

QUESTION 35

1. Include which clause to this statement to return the null rows: SELECT * from USERS where NAME

   		EQUAL TO NULL;
   		NOT EQUAL NAME;
   		NVL;
   		IS NULL;

2.5 points   

QUESTION 36

1. In the statement: SELECT zip "Zip Code" from customer; "Zip Code" is a

   		table alias
   		column name
   		column alias
   		table name

2.5 points   

QUESTION 37

1. SELECT COUNT(*) from orders; will return all rows including rows with nulls

   True

   False

Answer 1

QUESTION 32
WHERE

QUESTION 33
True

QUESTION 34
table alias

QUESTION 35
IS NULL;

QUESTION 36
column alias

QUESTION 37
True