Name:                                                                           SSN:

1. (Concepts) Put 4 out of the 7 terms, (a) communication subsystem, (b) compiler, (c) database, (d) DBMS, (e) file system, (f) loader, and (g) operating system, into the following boxes.       (8%)
   
   



---

2. (Concepts) Give an example showing an advantage of inheritance in OODBMS.       (8%)
   
   




















---

3. (Concepts) Put 4 out of the 7 systems, (a) file system, (b) Gemstone, (c) IBM IMS, (d) JDBC, (e) operating system, (f) Oracle 7, and (g) Oracle 8, into the following quadrants.       (8%)
   
   
4. (Concepts) Give an example showing an advantage of a persistent language over a file system.       (8%)
   
   


























---

5. (Concepts) What are the problems of using a relational DBMS for a no-query and complex-data application?       (8%)
   
   









6. (VARRAY)       (20%)
   • Create a book table containing an attribute class of varying-length array.
   • Implement the list.java program to list the requested books.
     Notice: Java programming is not the focus which is on the SQL statements.

































7. (LOB) Give a PL/SQL block for printing a LOB which contains a text file (100,000+ bytes) .       (20%)
   Notice: DBMS_OUTPUT.PUT_LINE(var) is a PL/SQL output command printing out the content of the variable var.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   

    create type point_t as object (
       x  int,           -- horizontal coordinate of the point
       y  int );         -- vertical   coordinate of the point

    create type rectangle_t as object (
       pt1  point_t,     -- lower left-hand  corner of rectangle
       pt2  point_t,     -- upper right-hand corner of rectangle
       member function overlap (r rectangle_t) return int );
    

8. (Methods) Implement the method overlap which gives the area of the overlapping region of the two rectangles.       (20%)