CS 495 -- The Date-a-Base

    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. Increase date-ability
  5. The big advantage of HTTP/1.0 over HTTP/0.9 is
    1. Increased reliability
    2. Increased user-friendlyness
    3. Increased speed
    4. Increase date-ability

    HTML

  6. Write me a web page that has in large letters "Date-a-Base" and also has a title (the thing at the top of the titlebar, above the "back" and "home" buttons) of the same phrase.







  7. I want to include a still photo on my web page.  What format (jpg/gif) should I use, and why?




  8. I want to have a page with two columns of text.  Text on the left  is left justified, and text on the right that is right justified.  An example is below.  Show me some HTML that does this.
    9. COLUMN ONE
    Left Aligned
    Text
    Here it is
    COLUMN TWO
    Right Alliened
    Text
    Here it is






    Perl

  9. Write me a perl program that prints the numbers 1 ... 10.





  10. I have a web page that has a text field named "person" where a person enters their name.  This web pages runs a cgi script.  Write me a perl cgi script that accesses the person field.  (1 point) The script should check a text file to see if the person's name is listed.  If so, print "Hi Again" else print "Welcome first-timer"(2 points).  Finally, all new names should be added to the text file (2 points).


    11. Lite

  11. I have a web page that has a text field named "person" where a person enters their name.  This web pages runs a cgi script.  Write me a lite cgi script that accesses the person field.  (1 point). The script should connect to a database (1 point).  The script should check a database to see if the person's name is listed.  If so, print "Hi Again" else print "Welcome first-timer"(2 points).  Finally, all new names should be added to the datebase  (2 points).

    12. 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)
     
  12. Write me an SQL query showing all the people who daters where 'Justin' is the datee.



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







    15. JavaScript

  15. I want to write a program that accesses a large database.  Would this be a good program for a large JavaScript?  Why or why not?