Download Database Systems Examination 2009-10: B.Sc (Hons) Software Developement and Networking and more Exams Database Management Systems (DBMS) in PDF only on Docsity!
Page 1 of 2
CORK INSTITUTE OF TECHNOLOGY
INSTITIÚID TEICNEOLAÍOCHTA CHORCAÍ
Autumn Examinations 2009/
Module Title: Database Systems 3
Module Code: Comp
School: Computing
Programme Title: B.Sc (Hons) Software Developement B.Sc (Hons) Software Development and Networking
Programme Code: KSDEV_8_Y4, KDNET_8_Y
External Examiner(s): Mr. Ken Carroll Internal Examiner(s): Mr. Byron Treacy
Instructions: Answer each question; internal choice within each question.
Duration: 2 Hours
Sitting: Autumn 2010
Requirements for this examination:
Note to Candidates: Please check the Programme Title and the Module Title to ensure that you have received the correct examination paper. If in doubt please contact an Invigilator.
Page 2 of 2
Q1 Recovery: Answer part a) and one other part b or c 34 Marks
a) Explain in detail, why database changes made by operations such as Insert, Update etc are not written directly to the database on the disk after executing in the CPU? 20 Marks b) Log Management: Write a detailed note on a circular log system 14 Marks c) Log Management: Write a detailed note on a 2 log system 14 Marks
Q2.Concurrency: Answer part a) and one other part b or c 33 Marks a) Write a detailed note on Intent Locking using the following guidelines 20 Marks i) Locking granularity ii) Intent Lock Protocol iii) Differentiate between S, IX and SIX locks. iv) Lock escalation
b) Using example(s) of interleaved transaction executions, explain the terms Deadlock detection and resolution 13 Marks c) Explain the term Serializability 13 Marks
Q3. Security: Answer part a) and one other part b or c 33 Marks
a) SQL Grant: 20 Marks i) Describe the SQL Grant statement ii) Explain how SQL Grant can be used to implement different types of security access control. b) Security system evaluation: Discuss the elements of a qualitative criterion (framework) for the evaluation of a database security system. Explain why frameworks such as these are useful. 13 Marks
c) “Security cannot be guaranteed 100%”. Do you agree or disagree with this statement? How does this issue impact on you as the manager/administrator of a database system? 13 Marks
