Fill in the blank with the name of the function to convert a date to an alphanumeric stringSELECT _______(sysdate, 'MM/DD/YYYY') FROM dual;

23.

Select the invalid PL/SQL looping construct.

A.

WHILE LOOP
...
END LOOP;

B.

FOR rec IN some_cursor LOOP
...
END LOOP;

C.

LOOP
...
UNTIL ;
END LOOP;

D.

LOOP
...
EXIT WHEN ;
END LOOP;

E.

None of the above. All are valid.

24.

Select the best answer. Which listed attribute is an invalid attribute of an Explicit cursor.

A.

%NOTFOUND

B.

%FOUND

C.

%ROWCOUNT

D.

%ISOPEN

E.

None of the above. All of these are valid.

25.

Which of the following is not a grouping function.

A.

COUNT

B.

SUM

C.

DISTINCT

D.

MIN

E.

All of the above.

26.

All the blanks can be filled with one word. Fill in the blank
Starting in Oracle 9i, you can use the _________ statement within a SQL statement. It has the functionality of an IF-THEN-ELSE statement.
The syntax for the ________ statement is:
__________ [ expression ] WHEN condition_1 THEN result_1 WHEN condition_2 THEN result_2 ... WHEN condition_n THEN result_n ELSE resultEND

What command can you use to see the errors from a recently created view or stored procedure?

A.

SHOW MISTAKES;

B.

DISPLAY MISTAKES;

C.

DISPLAY ERRORS;

D.

SHOW ERRORS;

E.

None of the above.

30.

Select the best answer below. What are the components of a package?

A.

Box, wrapping and binding

B.

Header and body

C.

Specification and content

D.

Specification and body

E.

None of the above

31.

Write a function named date_as_mmyyyy which will accept a date as a parameter. This date is then converted to characters and formatted as MMYYYY and then returned. If this date is null then return sysdate in this format.