The opening of cursor CSR01 produces the following result set:
STUDENT LASTNM FIRSTNM CLASSNO
123 Brown John T100
213 Bailey James T100

312 Carter Arlene T210
465 Chas Devon T305
546 Davis Steven T405
If this Fetch statement is executed:
FETCH csr01 INTO :studnum, :firstname, :lastname, :class
Which of the following DELETE statements will cause this row to be deleted?

Given the following query:
SELECT quantity,
CASE WHEN itemcode = ‘099’ THEN ‘SILVER’
WHEN itemcode = ‘788’ THEN ‘GOLD’
WHEN itemcode = ‘899’ THEN ‘PLATINUM’
ELSE ‘ERROR’
END
FROM supplier
What will be the result of the query if the following data is evaluated by the CASE expression?
SUPPLIER
——————————————
QUANTITY ITEMCODE
3 099
4 099
1 788
1 899
5 009
3 788
1 899

Given the following expression:
SELECT QUANTITY,
CASE WHEN ITEMCODE = ‘099’ THEN “SILVER”
WHEN ITEMCODE = ‘788’ THEN “GOLD”
WHEN ITEMCODE = ‘899’ THEN “PLATINUM”
ELSE ERROR
END
FROM SUPPLIER

What will be the result of the query if the following data is evaluated by the CASE expression?
QUANTITY ITEMCODE
3 099
4 099
1 788
1 899
5 009
3 788
1 899

Which of the following queries will correctly return the manager information sorted by the
manager’s last name, department and project name?

Assuming table TAB1 contains 100 rows, which of the following queries will return only half of the
rows available?

Given the following two tables:
EMPLOYEE
ID NAME DEPTID
— —————- —
01 Mick Jagger 10
02 Keith Richards 20
03 Ronnie Wood 20
04 Charlie Watts 20
05 Bill Wyman 30
06 Brian Jones DEPARTMENT
ID DEPTNAME
— ——————
10 Executive Staff
20 Sales
30 Marketing
40 Engineering
50 Human Resources
Which two of the following queries will display the employee name and department name for all
employees that are in Sales?

Given the following two tables:
NAMES
NAME NUMBER
———- ——-
Wayne Gretzky 99
Jaromir Jagr 68
Bobby Orr 4
Bobby Hull 23

Brett Hull 16
Mario Lemieux 66
Mark Messier 11
POINTS
NAME POINTS
———- ——
Wayne Gretzky 244
Jaromir Jagr 168
Bobby Orr 129
Brett Hull 121
Mario Lemieux 189
Joe Sakic 94
Which of the following statements will display the player name, number, and points for all players
that have scored points?

Given the following queries:
SELECT c1 FROM tab1;
SELECT c1 FROM tab2;
Which of the following set operators can be used to produce a result data set that contains only
records that are not found in the result data set produced by each query after duplicate rows have
been eliminated?

Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?

Given the following tables:
YEAR_2006
EMPID NAME
—– —————
1 Jagger, Mick
2 Richards, Keith
3 Wood, Ronnie
4 Watts, Charlie
5 Jones, Darryl
6 Leavell, Chuck
YEAR_1962
EMPID NAME
—– —————
1 Jagger, Mick
2 Richards, Keith
3 Jones, Brian
4 Wyman, Bill
5 Watts, Charlie
6 Stewart, Ian
If the following SQL statement is executed, how many rows will be returned?
SELECT name FROM year_2007
UNION ALL
SELECT name FROM year_1962