Download Trigger Time - Database Systems - Exam 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Í
Semester 1 Examinations 2011/
Module Title: Database Systems 3
Module Code: COMP
School: Computing
Programme Title: BSc (Hons) Software Development – Year 3 BSc (Hons) Software Development & Computer Networking – Year 3
Programme Code: KSDEV_8_Y KDNET_8_Y
External Examiner(s): Mr Aidan Quilligan Internal Examiner(s): Mr Byron Treacy
Instructions: Answer any four questions.
Duration: 2 Hours
Sitting: Autumn 2012
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 Database Systems: General terms and concepts (25 Marks)
Describe each of the following terms and concepts
Localisation 10 Marks SQL Dialects and Versions 15 Marks
Q2. Triggers (25 Marks)
The syntax of the MySQL Trigger is as follows
CREATE
TRIGGER trigger_name trigger_time trigger_event
ON tbl_name FOR EACH ROW trigger_stmt
Explain how triggers work by describing the following elements of the Trigger
Trigger Time Trigger Event Trigger_Stmt Both Triggers and SQL Select manipulate (process) the data in a database. However, they are different in that Triggers are procedural, and SQL select is non-procedural. Explain.
Q3. Concurrency : (25 Marks)
Discuss serializability using the following guidelines
General description Interleaved schedule Implications for locking and Data Access Protocol(DAP)
Q4. Recovery: (25 Marks)
Database management systems require particular recovery handling processes for online, transaction based applications. Discuss these requirements with reference to the properties of a transaction outlined below.
Properties of a transaction : the ACID properties.
A tomicity : C onsistency : I solation : D urability :
Q5. Security: (25 Marks)
Write a detailed note on risk assessment in database security.
