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
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.
- Typical access times for disk drives in 1998 are
- 10 nanoseconds
- 10 microseconds
- 10 milliseconds
- 10 seconds
- Typical access times for RAM in 1998 are
- 50 nanoseconds
- 50 microseconds
- 50 milliseconds
- 50 seconds
- The typical cost for a megabyte of RAM in 1998 is
- $3
- $300
- $30,000
- $3,000,000
- 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