Final Examination Trimester 1 – 2011
Date: Duration:3 hours plus 10 minutes INSTRUCTION TO STUDENTS 1. You are allowed ten minutes extra reading time during which you are not to write 2. Write all answers to each question in the Answer Booklet. 3. Write your Student ID number at the top of each attached sheet. 4. Insert all written foolscaps in their correct sequence. 5. Read the instruction of each section carefully. 6. There are 3 sections altogether A, B and C. SECTION DESCRIPTION 15 Multiple Choice Questions Short Answer Questions 5 Long Answer Questions Q1. Entity Relationship Diagram Q2. Relational Algebra Q3. Normalisation Q4. SQL Q5. Transaction Management and Concurrency Control MARKS 15 20 10 10 15 20 10 Time: Total Marks: 100
A B
C
Total Marks
100
1
SECTION A: MULTIPLE CHOICE
[15 Marks]
Instruction: There is only ONE best answer. Write the correct answer (only the letter) in the Answer Sheet provided. Each question is worth 1 mark. 1. Which of the following is not a Multi-user database? (a) SQL Server (b) MS Access (c) Oracle (d) All of the Above 2. What deals with fixing the database after a failure, such as a hard disk malfunction? (a) Backup (b) Recovery (c) Security (d) Access Control 3. Which of the following might be represented with a multivalued attribute? (a) person’s name (b) class location (c) bank account balance (d) book title 4. To restore a table’s content, the command to be used is (a) COMMIT; RESTORE; (b) COMMIT; BACKUP; (c) COMMIT; ROLLBACK; (d) ROLLBACK; 5. Which kind of relationship exists when there are three entities associated? (a) unary (b) binary (c) ternary (d) weak
2
6.
Which SQL keyword is use to change a column value? (a) (b) (c) (d) CHANGE SET MODIFY SELECT
7.
What do we call when one user’s changes to the database are lost by second user’s changes to the same database? (a)