Exam II question distribution

Exam II Question Distribution

Time and Place

Question Style

For programming questions:
- If not specified, any programming languages can be used to answer the questions.
- The code given by you should be able to work on the public Unix servers of the Aerospace School.
- If the questions specifically ask for C++/JDBC/SQL/SQL*Plus, the C++/JDBC/SQL/SQL*Plus knowledge provided in the class slides should be enough for you to answer the questions.
- Detailed web programming questions such as CGI and HTML will not be asked, but general concepts about web-enabled databases/files such as construction steps will be.
- The top part of a JDBC program will be given:
```
  import  java.sql.*;
  import  java.io.*; 
  class  ClassName { 
    public static void  main( String args[ ] )
      throws SQLException { 
      DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver( ) );
      Connection conn = DriverManager.getConnection( 
        "jdbc:oracle:thin:@172.20.4.9:1521:aero", "userid", "password" );
```
The textbook Chapters 5 & 6 were not completely covered. Therefore, if the materials were not mentioned in the classes, the related questions will not be asked.

Question types may include: (i) true-or-false, (ii) multiple choices, (iii) match, (iv) blank filling, (v) question-and-answer, or (vi) programming.

Question Distribution (Major Topics)

Covering Chapters 5 & 6, Homework III, Class Slides 3.1 – 3.14 and 6.1 – 12.12, and Programming Exercises I & II

Chapter 6. Organizing Files for Performance (35% – 45%)
- (Concepts and programming) Reclaiming space in files (management of the avail list)
- (Concepts and programming) Sequential search vs. binary search
- (Concepts and programming) Keysorting

Databases, JDBC, and web-enabled databases/files (50% – 60%)
- Step-by-step web-enabled database/file system construction
- Questions ——> SQL*Plus commands
- Questions ——> SQL commands
- Questions ——> JDBC programs