LOYOLA COLLEGE (AUTONOMOUS), CHENNAI – 600 034

M.Sc. DEGREE EXAMINATION – COMPUTER SCIENCE

SECOND SEMESTER – APRIL 2011

CS 2814 – ADVANCED DATABASE MANAGEMENT SYSTEM

 

 

Date : 11-04-2011             Dept. No.                                        Max. : 100 Marks

Time : 9:00 – 12:00

Part – A

Answer All the Questions:                                                                                             (10 x 2 = 20)

 

1. What is Super Key?
2. List out the components of data block.
3. Mention the different types of bulk type-constructors.
4. What is meant by granting a privilege?
5. Define the term: Snowflake schema.
6. What do you meant by Residence Latency?
7. State the difference between Row-level and Statement-level active rules.
8. Define the term: Data Allocation.
9. What is Backward Chaining?
10. What do you meant by Shadow Paging?

Part – B

Answer all the Questions:                                                                                                                     (5 x 8 = 40)

 

11. a) Solve the query by using Relation Algebra

Employee(Eno,Ename,Bdate,Address,Gender,Salary,Superssn,Dno)

Department(Dname,Dnumber,MGRSSN,MGR-START-DATE)

Project(Pname,Pnumber,Plocation,Dnum)

For every project located in “Berlin”, list the project number, the controlling department

number and the department manager’s name, address and birthdate.

(Or)

1. b) Write a short note on Storage Organization in Oracle.

 

12 a) Explain in briefly about Deadlock Prevention.

(Or)

1. b) Explain the relationship between a type and its subtype in a type hierarchy with an example.

 

13 a) Explain in briefly about Mobile Computing Architecture with a neat diagram.

(Or)

1. b) Write a short note on the goals that Data Mining attempts to facilitate.

 

14 a) Give a detail note on I/O Parallelism.

(Or)

1. b) Write a database trigger before insert/update/delete for each statement not allowing any of

these operations on the table Employee on Mondays/Tuesdays & Wednesdays.

 

 

 

15 a) Explain the steps involved in converting a SQL query into Query tree with an example.

(Or)

1. b) Explain the types of privileges at the account level and at relation level.

 

Part – C

 

Answer any two:                                                                                               (2 x 20 = 40)

 

16 a) What is Query processing? Explain the steps involved for Query processing.(10)

1. b) What is a Transaction? Explain ACID properties with an example.(10)

17 a) What is a Data Warehouse? Describe the characteristics of a Data Ware house.(10)

1. b) Give a detail note on Data Fragmentation with an example.(10)
2. a) Explain in detail about Database Tuning in Relational Systems.(10)
3. b) Discuss the Entity Integrity & Referential Integrity constraints. Why each is considered

important?(10)

 

 

 

Go To Main page

 

 

LOYOLA COLLEGE (AUTONOMOUS), CHENNAI – 600 034

M.Sc. DEGREE EXAMINATION – COMPUTER SC.

SECOND SEMESTER – APRIL 2012

CS 2814 – ADVANCED DATABASE MANAGEMENT SYSTEM

 

 

Date : 24-04-2012             Dept. No.                                        Max. : 100 Marks

Time : 9:00 – 12:00

 

SECTION – A

ANSWER ALL THE QUESTIONS:                                                                                        (10*2=20)

 

1. What is Metadata?
2. Define Relational Algebra.
3. Mention the purpose of Normalization.
4. What is 1NF?
5. What you meant by Transaction Processing System?
6. What is Deadlock?
7. Define OID.
8. What is multiple Inheritance?
9. What is Replication Transparency?
10. What is Vertical Fragmentation?

 

SECTION –B

ANSWER ALL THE QUESTIONS:                                                                                         (5*8=40)

 

11(a) Write a short note on Schema Architecture and Data Independence.

(OR)

(b) Explain about the types of Attributes.

12(a) Describe about tha concept of 3NF and BCNF.

(OR)

(b) Discuss about the steps involved in processing a high level query.

13(a) Explain about the needs of concurrency.

(OR)

(b)List out and Explain about the Properties of Transaction.

 

 

 

 

14(a) Explain the following (1) object identity (2) object structure and type constructors.

(OR)

(b) Write a short note on type hierarchies and inheritance.

15(a) Explain about the types of distributed System.

(OR)

(b) List out the applications of Data Mining.

 

SECTION – C

 

ANSWER ANY TWO QUESTIONS                                                                                     (2*20=40)

 

16 (a) Explain About the operators in Relational Algebra with An Example?

(b) How to implementing the Selection Operation?

 

17 (a) Explain about Shadow Paging?

(b)Explain about Client Server Architecture?

 

18 (a) Explain About the characteristics of Data ware houses?

(b) Explain about the applications of Multimedia Databases?

 

 

Go To Main page