Exam_08 - EXAMINATIONS 2008 MID-YEAR COMP 442 ISSUES IN...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
EXAMINATIONS 2008 MID-YEAR COMP 442 ISSUES IN DATABASE AND INFORMATION SYSTEMS Time Allowed: 3 Hours (180 minutes) Instructions: Attempt all questions. There are 180 possible marks on the exam. Make sure your answers are clear and to the point. Non-programmable calculators without full alphabetic keys are permitted. Non-electronic foreign language dictionaries are permitted. Refer to the Appendix. No other reference material is allowed. Answer in the appropriate heavily outlined boxes or follow the instructions given in the questions. Question Topic Marks 1 Object-Relational Database Features [15 marks] 2 Database Administration [05 marks] 3 Database Security [15 marks] 4 XML DTD and XML Schema [10 marks] 5 Converting an XML Schema into a DTD [10 marks] 6 ID Constraints and Identity Constraints [26 marks] 7 XQuery and XUpdate [26 marks] 8 XML Functional Dependencies [15 marks] 9 XML Normal Form [38 marks] 10 Mapping Relational Schema to DTD [20 marks]
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Student Id_____________ COMP 442 continued 2 Question 1. Object-Relational Database Features [15 marks] Object-relational databases introduce a number of object-oriented features into relational databases. a) [5 marks] List the object-oriented features of object-relational databases. ANSWER b) [10 marks] Of the features you listed in the answer to question above, which ones you consider the most important? Justify your answer. ANSWER
Background image of page 2
Student Id_____________ COMP 442 continued 3 Question 2. Database Administration [5 marks] Make a list of typical database administrator’s duties. ANSWER
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
COMP 442 continued 4 Question 3. Database Security [15 marks] As a superuser of a database cluster, you have created a table exam within a schema grades in a database student and declared the following roles: CREATE ROLE pavle CREATEDB; CREATE ROLE group_1 LOGIN NOINHERIT; CREATE ROLE group_2 LOGIN; CREATE ROLE group_3 LOGIN NOINHERIT; CREATE ROLE group_4 LOGIN CREATEDB; CREATE ROLE group_5 LOGIN NOINHERIT; and have formed the following member roles: GRANT group_1, group_3 TO pavle; GRANT group_2 TO group_1; GRANT group_4 TO group_3; GRANT group_5 TO group_4; and have given the following privileges: GRANT SELECT, DELETE, INSERT ON exam TO pavle; GRANT SELECT, INSERT ON exam TO group_1; GRANT UPDATE ON Exam TO group_2; GRANT SELECT, INSERT ON exam TO group_3; GRANT SELECT, UPDATE, INSERT ON exam TO group_4; GRANT SELECT, DELETE ON exam TO group_5; The duty of the role pavle is to maintain the exam table within the grades schema of the student database in a consistent state by reading, inserting, deleting, and modifying exam data. a)
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/05/2011 for the course FIN 350 taught by Professor Debruinne during the Winter '11 term at Grand Valley State.

Page1 / 22

Exam_08 - EXAMINATIONS 2008 MID-YEAR COMP 442 ISSUES IN...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online