ICS 434-01 - Advanced Database Systems

Quiz # 2                                                                                              April 25, 2003

  1. List the various classifications of DBMSs based on their physical architecture.

 

 

 

 

 

 

  1. Explain each tier in a three-tier Client/Server Architecture.

 

 

 

 

 

 

 

 

 

 

 

 

 

  1. Explain one advantage and one disadvantage of the three-tier Client/Server Architecture.

 

 

 

 

 

 


  1. List the basic application steps in ODBC-based communication between a client and a DBMS.

 

 

 

 

 

  1. Explain the following:
    1. Difference between Stored Procedures and Triggers

 

 

 

 

 

 

 

 

    1. Difference between Embedded SQL and Call-Level Interface

 

 

 

 

 

 

 

    1. Difference between System Catalog and Data Dictionary.