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
SECTION A: MULTIPLE CHOICE
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
Which SQL keyword is use to change a column value? (a) (b) (c) (d) CHANGE SET MODIFY SELECT
What do we call when one user’s changes to the database are lost by second user’s changes to the same database? (a) (b) (c) (d) Concurrent update problem Inconsistent read problem Inconsistent write problem Deadlock problem
Which of the following is not true about normalization? (a) (b) (c) (d) Produces relations with a single theme Reduces the number of functional dependencies in the schema May create referential integrity constraints Splits poorly structured relation into two or more well-structured relations
Which of the following statement is true regarding Data Definition Languages? (a) (b) (c) (d) Create data structures Manipulate the data in the database INSERT, DELETE data in database All of the above
Which of the following is not an advantage of distributed database processing? (a) (b) (c) (d) Better performance Increased flexibility Users have some sense of custody over data. Updates can be made by several users at same time
What does the following shorthand notation A B, C, D indicate? (a) (b) (c) (d) Attribute A determines attribute B only Attribute B, C and D is functionally dependent on attribute A Attribute B is a foreign key Attribute B, C and D determines attribute A
In a multi-user database system, what is the most commonly method used to handle concurrency control problem? (a) (b) (c) (d) Transaction control Integrity control Locking Lost updates
Which one of the following is true about entity integrity? (a) (b) (c) (d) Null value is permitted in special cases. Primary key must uniquely identify each row in a table. Foreign key must reference a primary key. Accuracy of data is maintained by referring to primary table.
Which relational operator yields all values from selected attributes? (a) Difference (b) Product (c) Select (d) Project
What is the specific range of values for a field known as? (a) (b) (c) (d) Tuple Attribute domain Entity integrity Referential integrity
SECTION B: SHORT ANSWER QUESTIONS Instruction: All questions are...