The Beatles ... Not The Worst Group Ever Made

1) In the song Penny Lane, where is Penny Lane?
    a) In my ears and in my eyes
    b) There beneith the cool suburban skies
    c) Near the octopus's garden
    d) It's Rocky Raccoon's house

2) How would you best describe Rocky Raccoon?
    a) Angry, vengeful
    b) Homical
    c) Love-lost
    d) Dying while telling jokes

3) In a correct HTML file, name one kind of metadata that might exist.

4) (Yes/No) Can one make a table cell containing a picture of Paul McCartney.

5) I have a normal array named 'a'. I wish to copy it into another array named 'b'. Please write me perl code to do this. Points for brevity.

6) The variables types in perl are ...
    scalar
    normal arrays
    ________________
    ________________

7) Write me a function in perl that returns the sum of it's two arguments. Show me it running.

8) List every nation from the 'nations' database that is 100% Muslim. One point if you can tell me the national codes ('sa', 'ym') and another point if you can tell me the national names ('Saudi Arabia', 'Yemen'). Show me the SQL query on your screen.

9) When running the 'die' command on a CGI script, where does the text go?
    The browser screen
    The error log
    Both
    Neither
    You should not use die commands in CGI scripts

10) Make me an SQL table that can hold the following items. Insert the two items. Show me
    ("White Album", 19.95)
    ("Blue Album", 23.50)

11) What permissions does a CGI script use?
    No permissions
    No permissions to any file except /tmp/* and the right to make network sockets
    Full root permissions
    Anything else

12) Suppose the singer table has 100 items, and the writer table has 27 items. Only three writers have been sung. How many rows will the query "select * from singer, writer" generate? _____________________

13) Suppose that as Lenon is doing his update and before Lennon update is complete the power fails. When the power is restored what will the database contain?
    a) Some records updated but not others
    b) No records updated
    c) All the records updated
    d) None of these horrible answers

14) When can you set a cookie using a CGI script?
    a) Anytime
    b) Only when printing the header
    c) Only after printing the header and during printing the body of the page
    d) Only after printing the page and before the CGI script exits
    e) After the CGI script exits
    f) None of the stinky answers

15) What is a relation?
    a database
    a table
    a tuple
    a column

At http://euclid.nmu.edu/~randy/test there is a thumbnail and a picture. Make me a web page showing the thumbnail such that when I click on the thumbnail I see the full picture.

Make me a web page that tells if apoe is logged on. Hint ... the command 'w' wll tell you who's logged on and the command "ps augx" will list all processes and their owners and the command 'last apoe' will tell if apoe is logged in.

Write me a web page that lists the nations of the world in order by gdp. It must do a database query. Extra point if you use a table.