CS 495 -- The Broken Lab Test

    HTTP

  1. Suppose it takes 10 ms to send a message one way across a network.  Any message of any length can go one way across in 10 ms.  It takes 2 ms for the HTTP server to respond to a message, and another 3 ms for the HTTP client to process recieved data.  How long does it take for a client to request, receive, and process a web page? __________
  2. (2 points) Suppose the situation is as described above, but that it is possible to cache web pages one a hard drive local to the client.  It takes 500 ms to retrieve any data off this hard drive.  List one reason why you should cache data there, and one reason against.
    FOR ___________________________________________________________________________
    AGAINST ______________________________________________________________________
  3. (True/False) Netscape and Internet Explorer are examples of HTTP servers.
  4. The big advantage of HTTP/1.1 over HTTP/1.0 is
    1. Increased reliability
    2. Increased user-friendlyness
    3. Increased speed
    4. It's from Microsoft
  5. The big advantage of HTTP/1.0 over HTTP/0.9 is
    1. Increased reliability
    2. Increased user-friendlyness
    3. Increased speed
    4. It's Univeristy Authorized!
  6. I want to include a still photo on my web page.  What format (jpg/gif) should I use, and why?




    7. SQL and Databases

     
    Couples
    Dater Datee
    Jennifer Brad
    Amanda Jason
    Bob Doug
    Amee' Jason
    Susan Susan
         		 Places
    Dater Place
    Amee' Movie
    Bob Gym
    Amanda Flower Garden
    Kelly Greatful Dead Concert
    Susan Good Book
    Jennifer Home (and veg)
     
  7. Write me an SQL query showing all the people who daters where 'Justin' is the datee.



  8. What one field(s) should I index to speed the query above. ________________________
  9. ( 2points) Write me an SQL query showing all the people who dated themselves, and where they went.  Put alphabetically first names first.




  10. Write me a web site that looks just like the 'Broken Lab' web site.  You may steal all the HTML you want.  You must use a database to store the data.  You must use PHP for one of the pages, and Perl for the other.
    The Add-An-Item Menu ...
       3 points if you can add an item.
       2 points if duplicate causes are not allowed.
    The Generate Tasks Page
       3 points if you can get tasks between the min and max
       2 points if you can select only tasks of the correct catagory
       2 points if no task is ever duplicated on the same page.
    The Dump the Tasks Page
       2 points if you can dump the page