


Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Material Type: Exam; Class: Info Delivery on Internet; Subject: Computer Science; University: Wichita State University; Term: Fall 2003;
Typology: Exams
1 / 4
This page cannot be seen from the preview
Don't miss anything!
CS 665 Information Delivery on the Internet Exam 2 - Name: Fall 2003
Part 1: (36 points - 3 points for each problem)
( B ) 1. Which cookie parameter is used to specify the expiration time of a cookie? (A) expiredtime (B) expires (C) setexpire (D) setlife
( A ) 2. Which file stores the directives that control an Apache server’s behavior? (A) httpd.conf (B) srm.conf (C) access.conf (D) ssl.conf
( B ) 3. Which directive is used to specify the index file for a directory in the Apache server? (A) DirectoryDefault (B) DirectoryIndex (C) DirectoryRoot (D) DirectoryAlias
( D ) 4. Which of the following lines in Java will compile without warning or error? (A) float f = 1.3; (B) char c = ”a”; (C) byte b = 257; (D) None of above
( C ) 5. In Java, the keyword(s) that every typed method must have is: (A) void (B) typedef (C) return (D) public static void
( C ) 6. Which keyword is used to indicate a call to a superclass constructor or method in Java? (A) default (B) parent (C) super (D) superclass
( A ) 7. Which keyword in Java can be used to declare a class cannot be instantiated? (A) abstract (B) constant (C) final (D) static
( B ) 8. Which of the following is not a keyword or reserved word in Java? (A) if (B) then (C) goto (D) case
( D ) 9. In a relational database, a table has at least one column that uniquely identifies the rows of the table. The value in this special column is called (A) main key (B) special key (C) unique key (D) primary key
( A ) 10. Which SELECT clause value means to select all the columns of the specified table that meet the condition? (A) ∗ (B)? (C). (D) $
( D ) 11. Which SQL command is used to join one or more of the tables? (A) UPDATE (B) MODIFY (C) JOIN (D) SELECT
( D ) 12. Which method in DBI is used to create a compiled version of a SQL command? (A) compile (B) execute (C) generate (D) prepare
Part 2: (64 points)
(a) Virtual Host A virtual host is built to host multiple sites that share the same physical system. (b) SQL The Structured Query Language (SQL) is a standard language for specifying accesses and modifications to databases. (c) ODBC Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database. (d) Applet An Applet is a Java program that can be resident on the server and downloaded to the brower.
Database Client (Browser)
Web Server and Database Applications
Database System
(a) The first tier has the Web browser, which provides the user interface. (b) The middle tier has Web server and the applications that require database access. (c) The third tier has the database system and the database itself.
(a) A session to a Web server is the collection of all the requests made by a particular browser from the time the browser is started until the user exits the browser. (b) A cookie is an object that is sent the server to a connected browser, where it is stored.
public class Hello { public static void message (int i, String args[]){ String Hello = "Hello! "; Hello += args[i--] + " " + args[i]; System.out.println(Hello); } public static void main(String args[]){ for(int i = 1; i < args.length; i++) message(i++, args); } }
(6 points) Ans:
Hello! Wood Natalie Hello! Douglas Jay
Artist ID Title Released 1001 Let Go 2002 2002 Under Rug Swept 2002 3003 Surfacing 1997 Table 1 Artist Table 2 Album Ans;
select Title, Firstname, Lastname from Artist, Album where Artist.Artist_ID = Album.Artist_ID and Released = 2002
import java.io.*;
public class KeyinFile { public static void main (String[] args) throws IOException {
BufferedReader keyboard = new BufferedReader (new InputStreamReader (System.in));
PrintStream out = new PrintStream (new FileOutputStream(args[0]));
String line = null;
while((line = keyboard.readLine()) != null) { out.println(line); } keyboard.close(); out.close(); } }
(a) A instance method is a method which must be invoked via an instance of a class. (b) A static method is a method which can be invoked via the name of the class in which they are defined.