CSE 190 M, Spring 2008
Practice Final Exam Key

1. HTML/CSS

Scene

#7

Elizabeth: Captain Barbosa, I am here to negotiate the cessation of hostilities against Port Royal.
Barbossa: stick man There are a lot of long words in there, Miss.
What is it that you want?
Elizabeth: I want you to leave
and never come back.
Barbossa: I'm disinclined to acquiesce to your request. Means "no."

2. Javascript/DOM

3. Ajax/XML

4. PHP

5. SQL

SELECT DISTINCT r1.role
FROM     roles r1 
JOIN     movies m1 ON m1.id = r1.movie_id
JOIN     roles r2 ON r1.role = r2.role
JOIN     movies m2 ON m2.id = r2.movie_id
WHERE    r1.movie_id <> r2.movie_id
AND      m1.name LIKE '%Pirates of the Caribbean%'
AND      m2.name LIKE '%Pirates of the Caribbean%'
ORDER BY r1.role;