Spring Semester 2003


Review Questions: Final Exam

While this hand is here the file is being updated.

(Once I am done I will remove the hand.)

  1. If you type "touch smile" at command line what will happen next?

  2. What is this command doing "chmod -r *"?

  3. What do you need to know when using "kill" command?

  4. Why do we learn MySQL database rather than other databases such Oracle/Sybase/Microsoft Access?

  5. In Unix what is an absoulte path name?

  6. In Unix what is a relative path name?

  7. Why is it not recommended to create files with mode 777?

  8. What is umask?

  9. What is the .. directory?

  10. What information is stored in the 'lockfile' file?

  11. What information is contained in the following folders, located in Apache's root directory: bin, cgi-bin, conf, htdocs, man, phpsessions, logs.

  12. What is the main difference between Apache and Tomcat?

  13. Why is there a need for both Java and Javascript?

  14. What does .cshrc mean, and why is it called by its file extension rather than the file name?

  15. What does the command 'grep' stand for?

  16. Why is software still 'sold' for profit, when we have so many free tools like Apache and Tomcat?

  17. What do the cvf and xvf stand for in tar and jar archiving commands?

  18. List 6 ways in which we can save/keep state.

  19. What are some of the advantages of XML?

  20. What is the difference between POST and GET?

  21. What is DBI used for?

  22. What is the web.xml file in tomcat used for?

  23. What's the relationship between Java RMI and XML-RPC?

  24. What is the difference between a servlet and a CGI script?

  25. Describe how XML differs from HTML.

  26. When transfering information through GET or POST, how (and why) is the information encoded special characters to ASCII code in hexidecimal form?

  27. What's the function of du in Unix?

  28. How to display your current running program(s) in Unix?

  29. What is the function of "netstat" command in Unix?

  30. What is Perl and what is its advantage(s) comparing to other programming languages?

  31. Please briefly describe the steps of installing Apache server.

  32. Where should the protected file be located?

  33. How to add multiple users to the protected folder?

  34. What does HTTP mean?

  35. What direction do you think web development should/will go?

  36. What do you think should be added to the text content for A348

  37. What is the difference between insert and update, delete and drop in mySQL?

  38. Please briefly describe the steps of installing PHP.

  39. Please list at least 4 techniques for including Javascript in HTML.

  40. Please briefly describe the steps of installing Tomcat.

  41. What is the biggest problem for Tomcat server right now?

  42. Where are the servlets generated from JSP placed in Tomcat?

  43. What is XSLT?

  44. What is the difference between internet and World Wide Web (WWW)?

  45. In Unix, what does -r-x--x--- mean?

  46. What does CGI stand for?

  47. In Java, what is the difference between = and == ?

  48. What does DOM stand for?

  49. What are "cookies"?

  50. What does XML stand for?

  51. What does SGML stand for?

  52. What Is MIME?

  53. What's %ENV?

  54. What is tar and where in the class did it matter which tar we were using?

  55. What's the purpose of a web.xml file?

  56. What's the purpose of a server.xml file?

  57. What is a web service and why is it a useful concept?

  58. How does a PHP refer to itself (by name)?

  59. How does a CGI script in Perl refer to itself (by name)?

  60. How does a Java servlet refer to itself (by name)?

  61. What's the purpose of the lib folder (under WEB-INF)?

  62. What's CGI.pm and what is it used for?

  63. What's DBI.pm and what is it used for?

  64. What does it mean to keep state and why is it hard to do that over HTTP?

  65. Why do I need JSP technology if I already have servlets?

  66. In the context of Apache, what is Jakarta?

  67. What does SOAP stands for?

  68. What is the difference between doPost and doGet method?

  69. What does the file extension "phps" do for you?

  70. Where should we place PHP files?

  71. Where should we place JSP files?

  72. Where should we place servlets?

  73. What does the term "relational" means in RDBMS?

  74. What is HTTP?

  75. Discuss the three parts which each HTTP client request and HTTP server response has.

  76. Which file contains the port number that the server runs (in Apache and Tomcat)?

  77. What does the "more" command do?

  78. What does the command "du" do?

  79. What does the .crshc file in your home directory contain?

  80. What is the difference between ~/.cshrc and /.cshrc?

  81. What is the difference between ./cshrc and /.cshrc?

  82. What is the command to create a symbolic file that references another existing file?

  83. Why is a symbolic link a useful tool?

  84. What does cronatb -l do?

  85. How do you ensure that a variable used in a subroutine in Perl stays as a local variable instead of global?

  86. How do you ensure that a variable used in a subroutine in PHP stays as a local variable instead of global?

  87. When using forms, what is the significance of changing the type="submit" value to type="button" when using JavaScript?

  88. What is an "event handler" in JavaScript and what does it do?

  89. What features does JavaScript lack when compared to Java?

  90. What is the purpose of the webapps directory under Tomcat?

  91. What is the difference between the <% and <%! syntax when using JSP?

  92. If SOAP is considered to be preferred protocol for understanding remote procedure calls for XML, why did we focus on XML-RPC in class?

  93. XML and Java both address portability. In what (respective) way(s)?

  94. In installing apache in your burrowww account, what are the functions of configure, make and make install?

  95. Why is it usually necessary to call source command after you edit your .cshrc or .login files?

  96. What is inheritance in Java?

  97. What are the components of a simple WWW interaction?

  98. When you configure httpd.conf in the new Apache server's conf directory, what do you need to change at the very least?

  99. How do you exit from vi?

  100. What is ASP?

  101. How do you shut down and start up your tomcat?

  102. What is Java RMI and how does it compare with XML-RPC.

  103. What is the Unix command that remove a directory including the all the files inside it?

  104. What does the "make" command do?

  105. Explain what $x[$#x] means in Perl.

  106. Among CGI environment variables, what is QUERY_STRING?

  107. In SQL how do you select "id_num" and "name" of those people whose "income" is more than $50,000 if all the information is in a table called "people"?

  108. In how many ways can you configure PHP (at least two)?

  109. Why are Java applets and servlets similar?

  110. Why are Java applets and servlets different?

  111. What's the relationship between GenericServlet and HttpServlet?

  112. We talked so much about keeping state... What does state mean?

  113. What's the purpose of the command cp if there is such a thing?

  114. Why do we need to create tables in a MySQL database?

  115. What was the purpose of this course?

  116. How do you access the QUERY_STRING from a servlet?

  117. What's the advantage of the HttpSession object?

  118. Name some predefined variables in JSP.

  119. What's the purpose of a form in an HTML document?

  120. What is the purpose of the action atribute in an HTML form?

  121. HTTP is a stateless protocol. What does that mean?

  122. Name the different parts that make a URL and give an example.

  123. Can apache be configured to host programs written in Java?

  124. List three advantages of PHP over Perl for web programming.

  125. List three advantages of Perl over any other programming language.

  126. Which crontab statement executes every Monday at midnight?

  127. What separates the second two elements of every HTTP transaction?

  128. Why did we change
    session.save_path = /tmp
    to
    session.save_path = /u/username/apache/apache_1.3.26/phpsessions
    and where did we make this change?

  129. How does the development of a PHP script most differ from the developoment of Perl/CGI scripts?

  130. What indicates that a segment of text is PHP code?

  131. Which command is used to list all tables in a MySQL database which contain dgerman within their name?

  132. What company is associated with the development of JavaScript?

  133. What is Mosaic?

  134. Why is Tomcat sometimes refered to as a "container"?

  135. What is the difference between the terms "overloading" and "overriding" with respect to Java programming?

  136. What Java packages do you import when defining a servlet classes?

  137. What is Struts?

  138. What is Xalan?

  139. What is Xerces?

  140. Which one is more general: HTML, SGML, or XML?

  141. What type of file can be used to define the presentation of XML?

  142. What is the port number traditionally used by SSH?

  143. What's the most significant difference between an instance of a Perl/CGI or PHP script and a JSP or Java Servlet?

  144. What's JDBC and where did we use it?

  145. What is put in the body of a GET request?

  146. In an HTML form, what is the difference between having a text input field be READONLY and DISABLED?

  147. In the Apache logs directory, there is a very helpful file called error_logs where the error messages print when you have errors running a Perl script from the browser. It can get very large. So you delete it and create a new empty one. You once again have errors that should show up in this new error_log, but nothing gets written to it. How do you get Apache to start writing to your new error_log?

  148. What is in the httpd.pid file? When would you use this file?

  149. In the httpd.conf file, we had the parameter KeepAlive On. What does this mean in this context?

  150. Since PHP allows for easy server-side data storage with session files, why would you ever store user data in a MySQL table?

  151. What is the difference between an int and an Integer in Java?

  152. In a JAVA class, how can you distinguish the constructor from the other methods?

  153. Define a simple BankAccount class in Java, Perl, and Javascript.

  154. What is polymorphism?

  155. The answer is: "Ahhah! They refer to basically the same thing. URI's (Uniform Resource Identifier) are the "generic set of all names/addresses that are short strings that refer to resources." URL (Uniform Resource Locator) is "an informal term associated with popular URI schemes: http, ftp, mailto, etc.". So, there you have it. " What was the question?

  156. In order to view a web page, a client makes a request to a server. Once the response has been sent from the server, what happens to the http connection?

  157. What is a port number on a server?

  158. What is a "dot file"? How can one view all hidden files?

  159. Why is it important to restart the server regularly?

  160. How is a hash table different from an array in Perl?

  161. Is there any relationship between PHP and CGI?


Last updated: May 8, 2003 by Adrian German for A348/A548