Final exam -- closed book section

The entire exam is to be turned in by 3:45 PM. You must turn in the closed book section of the final before you consult your textbook or notes.

Problem 1 (22 points)

Give brief (one or two sentence) definitions of the following eleven terms:

• candidate key
• cluster
• data dictionary
• domain
• DDL -- Data Definition Language
• embedded SQL
• foreign key
• JDBC
• SCSI (small computer system interconnect)
• serializability
• transaction

Problem 2 (4 points)

What are the two phases of Two Phase Locking?

Problem 3 (12 points)

Name the four characteristics of the ACID test for transaction management systems and give a brief definition of each of them

• A
• C
• I
• D

Problem 4 (2 points)

List two popular Database Management Systems.

Problem 5 (6 points)

What are the differences between the following three levels of database design specified in the ANSI-SPARC model?

• conceptual level
• external level
• internal level

Question 6. (6 points)

Briefly explain the requirements of the following three levels of normalization

• 1NF -- First Normal Form
• 2NF -- Second Normal Form
• 3NF -- Third Normal Form

Problem 7 (4 points)

Name a couple of ways in which different levels of RAID differ?

Problem 8 (4 points)

Circle the most appropriate answer for the following four questions.

1. Typical access times for disk drives in 1998 are
   • 10 nanoseconds
   • 10 microseconds
   • 10 milliseconds
   • 10 seconds
2. Typical access times for RAM in 1998 are
   • 50 nanoseconds
   • 50 microseconds
   • 50 milliseconds
   • 50 seconds
3. The typical cost for a megabyte of RAM in 1998 is
   • $3
   • $300
   • $30,000
   • $3,000,000
4. The typical cost for a gigabyte of disk storage in 1998 is
   • $2
   • $200
   • $20,000
   • $2,000,000

Question 9. (6 points)

Suppose the following SQL SELECT statement will list the names, department, and salaries of all company employees

SELECT Staff.Name, Staff.Dept, Staff.Salary
       FROM EmployeeTable ;

Now write two SQL statements to

• list all company departments once
• list all employees in the ACCOUNTING department

Back to the CSCI 363 home page