Q1 html/css code -> picture
HTML:
multiple floats to same side (columns)
margin vs. padding
size units (em vs. pt vs. %)
ul w/ bullets
block vs. inline; width = 100% of page
inline text alignment vs. margins?
CSS:
class vs. id
comma-separated multiple selectors
multiple classes on one tag
nesting and inheritance
red herrings, rules not used
comma versus space (context) or >
Q2 html/css picture -> code
dog breeds? french bulldog?
inception theme?
Q3 js/dom
select box? event other than onclick?
string manipulation? searching for palindromes?
make them create/delete DOM nodes?
Q4 ajax/xml
make the xml return different things if it's found or not found
have to look for whether getElement() [0] is defined
Q5 php
something to do with forms and validation
complex form, given to them; they have to process and decide an answer
car order form? can i afford this car?
something that needs a for loop? foreach?
reading a file?? form doesn't seem to need foreach
maybe outputs N HTML tags for query parameter of value N?
test id/class vs name confusion?
student CSE major application?
assume top/bottom functions
Q6 sql
-- all the times a director has appeared in his own movie, twice --
SELECT DISTINCT d.first_name, d.last_name
FROM directors d
JOIN movies_directors md ON md.director_id = d.id
JOIN movies m ON m.id = md.movie_id
JOIN roles r1 ON r1.movie_id = m.id
JOIN actors a1 ON a1.id = r1.actor_id
JOIN roles r2 ON r2.movie_id = m.id
JOIN actors a2 ON a2.id = r2.actor_id
WHERE a1.id = a2.id
AND a1.first_name = d.first_name AND a1.last_name = d.last_name
AND r1.role < r2.role
ORDER BY d.last_name, d.first_name;
+------------+-----------+
| first_name | last_name |
+------------+-----------+
| LeVar | Burton |
| Santo | Cilauro |
| Claus Theo | Gartner |
| Tom | Gleisner |
| Jane (I) | Kennedy |
| Tony (III) | Martin |
| Bill | Melendez |
| Mick (I) | Molloy |
| Yves | Renier |
| Rob | Sitch |
| Jason | Stephens |
| James | Tolkan |
+------------+-----------+
12 rows in set (2 min 50.02 sec)
+------------+-----------+-------------------------------+-------------------------------+
| first_name | last_name | role | role |
+------------+-----------+-------------------------------+-------------------------------+
| LeVar | Burton | | Lt. (j.g.)/Lt./Lt. Cmdr. Geor |
| Santo | Cilauro | Kelvin Purple | Various (1992-1993) |
| Claus Theo | Gärtner | Josef Matula | Matula |
| Tom | Gleisner | Jock | Various (1992-1993) |
| Jane (I) | Kennedy | Bev | Various (1992-1993) |
| Tony (III) | Martin | Various (1992-1993) | Warren Perso |
| Bill | Melendez | | Snoopy/Woodstock/Spike (1988- |
| Mick (I) | Molloy | Sturt | Various (1992-1993) |
| Yves | Rénier | Commissaire Moulin (1976-1982 | Moulin |
| Rob | Sitch | Joe | Various (1992-1993) |
| Jason | Stephens | Strzelecki | Various (1992-1993) |
| James | Tolkan | Hackett | Percy Ludlow |
| James | Tolkan | Bernard Quest | Special Agent In Charge Richa |
| James | Tolkan | Joseph Pitcairn | Percy Ludlow |
| James | Tolkan | | Special Agent In Charge Richa |
| James | Tolkan | Hackett | Special Agent In Charge Richa |
| James | Tolkan | Bernard Quest | Joseph Pitcairn |
| James | Tolkan | Joseph Pitcairn | Special Agent In Charge Richa |
| James | Tolkan | | Joseph Pitcairn |
| James | Tolkan | Hackett | Joseph Pitcairn |
| James | Tolkan | Bernard Quest | Hackett |
| James | Tolkan | | Bernard Quest |
| James | Tolkan | | Hackett |
| James | Tolkan | Bernard Quest | Percy Ludlow |
| James | Tolkan | Percy Ludlow | Special Agent In Charge Richa |
| James | Tolkan | | Percy Ludlow |
+------------+-----------+-------------------------------+-------------------------------+
-- all actors who have appeared in >= 2 Martin Scorsese movies --
SELECT a.first_name, a.last_name, m1.name, m2.name
FROM actors a
JOIN roles r1 ON r1.actor_id = a.id
JOIN movies m1 ON m1.id = r1.movie_id
JOIN movies_directors md1 ON md1.movie_id = m1.id
JOIN directors d1 ON d1.id = md1.director_id
JOIN roles r2 ON r2.actor_id = a.id
JOIN movies m2 ON m2.id = r2.movie_id
JOIN movies_directors md2 ON md2.movie_id = m2.id
JOIN directors d2 ON d2.id = md2.director_id
WHERE d1.first_name = "Martin" AND d1.last_name = "Scorsese"
AND d2.id = d1.id AND m1.id < m2.id
ORDER BY a.last_name, a.first_name, m1.name, m2.name;
-- all of the Martin Scorsese movies Joe Pesci has appeared in --
SELECT m.name
FROM movies m
JOIN roles r ON m.id = r.movie_id
JOIN actors a ON a.id = r.actor_id
JOIN movies_directors md ON md.movie_id = m.id
JOIN directors d ON d.id = md.director_id
WHERE a.first_name = "Joe" AND a.last_name = "Pesci"
AND d.first_name = "Martin" AND d.last_name = "Scorsese"
ORDER BY m.name;
-- all of the Martin Scorsese movies has he himself appeared in as an actor? --
SELECT m.name
FROM movies m
JOIN roles r ON m.id = r.movie_id
JOIN actors a ON a.id = r.actor_id
JOIN movies_genres mg ON mg.movie_id = m.id
JOIN movies_directors md ON md.movie_id = m.id
JOIN directors d ON d.id = md.director_id
WHERE a.first_name = "Martin" AND a.last_name = "Scorsese"
AND d.first_name = "Martin" AND d.last_name = "Scorsese"
AND mg.genre = "Drama"
ORDER BY m.name;
-- all actors that have been in 2 action movies, along with the names of those movies
SELECT a.first_name, a.last_name, m1.name, m2.name
FROM actors a
JOIN roles r1 ON r1.actor_id = a.id
JOIN movies m1 ON m1.id = r1.movie_id
JOIN movies_genres mg1 ON mg1.movie_id = m1.id
JOIN roles r2 ON r2.actor_id = a.id
JOIN movies m2 ON m2.id = r2.movie_id
JOIN movies_genres mg2 ON mg2.movie_id = m2.id
WHERE m1.id < m2.id
AND mg1.genre = 'Action' AND mg2.genre = 'Action'
ORDER BY a.last_name, a.first_name;
tip for solving the "question #1" HTML/CSS problems:
Number all of the CSS rules. Now, for any given div/p/etc.:
1 - look at each rule and decide whether it applies to this.
If so, write that number next to it.
2 - once done, look at all the rule(s) that apply and merge their properties.