CS2029 Advanced Database Technology Anna University question paper - May/June 2011

CS2029 Advanced Database Technology question paper - May/June 2011 / Anna University Previous Year 2011 Exam Questions for Advanced Database Technology / Anna University Previous Year 2011 Computer Science and Information Technology Question Papers / CS 606 Advanced Database Technology Question Paper

M260

B.E./B.Tech. DEGREE EXAMINATION, MAY/JUNE-2011

Regulations 2008

Sixth Semester

CS 606 — ADVANCED DATABASE TECHNOLOGY

Computer Science and Engineering

Time : Three Hours                                                          Maximum : 100 marks

Answer ALL Questions

PART A – (10 X 2 = 20 marks)

1. Define primary key, candidate key.

2. What are the goals of data mining?

3. What is data parallelism?

4. Write short notes on horizontal fragmentation.

5. Why do database systems support concurrent execution of transactions?

6. Differentiate persistent objects and transient objects.

7. List out the types of Constructor? Give definition of each.

8. Briefly explain about applications of data warehousing.

9. Write short notes on multimedia query languages.

10. What is knowledge? What are its types?

PART B – (5 X 16 = 80 marks)

11. (a) Explain in detail about serial schedule and serializable schedule in transaction processing. (16)

Or

(b) Explain any two principal methods for dealing with the deadlock problem. (16)

12. (a) Briefly explain about Intra-operation parallelism and Inter-operation parallelism. (16)

Or

(b) Explain about commit protocols. (16)

13. (a) (i) Explain how the concept of the object identity in the object-oriented model differs from the concept of tuple equality in a relational model? (6)

(ii) Briefly explain about ODMG model. (10)

Or

(b) Discuss in detail about transaction and concurrency of Object oriented databases. (16)

14. (a) Explain about data mining and association rules of data mining in detail. (16)

Or

(b) (i)           What do you mean by a tier? For a Web, why a three tier client-server architecture is more suitable? Give a general structure of a client-server system. (8)

(ii) Briefly explain about mobile databases. (8)

15. (a) Explain about spatial and multimedia database. (16)

Or

(b) Explain in detail about Active Databases. (16)

________________________

 

CS2029 Advanced Database Technology Anna University question paper - May/June 2013

CS2029 Advanced Database Technology question paper - May/June 2013 / Anna University Previous Year 2013 Exam Questions for Advanced Database Technology / Anna University Previous Year 2013 Computer Science and Information Technology Question Papers / CS 606 Advanced Database Technology Question Paper

Question Paper Code : 21283

B.E./B.Tech. DEGREE EXAMINATION, MAY/JUNE 2013

Sixth Semester

Computer Science and Engineering

CS 2029/CS 606/10144 CSE 23 — ADVANCED DATABASE TECHNOLOGY

(Common to Seventh Semester – Information Technology)

(Regulation 2008/2010)

Time : Three Hours                                                          Maximum : 100 marks

Answer ALL Questions

PART A – (10 X 2 = 20 marks)

1. Write an SQL query to retrieve employee name and Id from a table employee.

2. What is Concurrency Control?

3. Differentiate intra query parallelism from inter query parallelism.

4. Differentiate distributed database and normal database.

5. How transaction is performed in Object oriented database?

6. What is versioning in terms of object oriented database?

7. List the advantages of XML over HTML.

8. Specify the advantages of Data warehousing.

9. How spatial databases are more helpful than active database?

10. What is deductive database?

PART B – (5 X 16 = 80 marks)

11. (a) (i) Illustrate and discuss the steps involved in processing a query with neat diagram.                                                                                                         (12)

(ii) Discuss briefly on database tuning.                                                          (4)

Or

(b) Explain the following with an example in relational model

(i) Transaction Processing

(ii) Query Optimization                                                                                 (16)

12. (a) (i) Explain with a neat diagram the architecture of distributed databases also mention its uses.                                                                                        (8)

(ii) Discuss the ACID properties of a transaction with relevant example.                   (8)

Or

(b) (i) Explain the Distributed transaction Processing with suitable example.   (10)

(ii) Explain the role of recovery subsystem in a distributed environment.                  (6)

13. (a) (i) Explain the object oriented database and its approaches.               (8)

(ii) Explain the component of the ODMG model with example.                        (8)

Or

(b) (i) Discuss the transaction states in object oriented databases.                          (8)

(ii) What is POSTGRES? Explain it in detail.                                                     (8)

14. (a) (i) How XML are processed and stored in web database? Explain with an example.                                                                                                   (8)

(ii) Explain the process of mobile database and its advantages over other database.                                                                                                                    (8)

Or

(b) (i) Explain the steps involved in constructing a data warehouse.                (8)

(ii) Explain about the decision trees in the process of data mining.                          (8)

15. (a) (i) Describe the active and deductive database and compare with each other.                                                                                                                            (8)

(ii) Explain the role and use of multimedia database for current technologies.          (8)

Or

(b) Elaborate the following with an example.                                                 (16)

(i) Spatial databases

(ii) Multimedia query with complex types.

________________________

CS2029 Advanced Database Technology Anna University question paper - Nov/Dec 2012

CS2029 Advanced Database Technology question paper - Nov/Dec 2012 / Anna University Previous Year 2012 Exam Questions for Advanced Database Technology / Anna University Previous Year 2012 Computer Science and Information Technology Question Papers / CS 606 Advanced Database Technology Question Paper

Question Paper Code : 11253

B.E./B.Tech. DEGREE EXAMINATION, NOV/DEC 2012

Sixth Semester

Computer Science and Engineering

CS 2029/CS 606 — ADVANCED DATABASE TECHNOLOGY

(Common to Seventh Semester - Information Technology)

(Regulation 2008)

Time : Three Hours                                                          Maximum : 100 marks

Answer ALL Questions

PART A – (10 X 2 = 20 marks)

1. Define cascading rollback.

2. Mention any two ways of tuning the query processing in relational databases.

3. Give a simple distributed access plan for a scenario of your choice.

4. With proper illustration define mixed fragmentation.

5. Illustrate the differences between the type constructors – bag and list.

6. ‘Versioning is important in Object Oriented Databases’ – Justify.

7. Write a trigger to compare an employee’s salary with that of her supervisor. (Note: Assume employee schema as: Emp (Name, Eno, Sal, Dno, Supervisor_Eno).

8. What issues are to be considered regarding the data management in mobile databases?

9. Brief on the data structures used for the multimedia databases.

10. What are the different types of specification used in deductive databases?

PART B – (5 X 16 = 80 marks)

11. (a) (i) Explain the impact of indexes in the databases. Discuss on the re-designing of the indexes for database tuning. (10)

(ii) Discuss in detail about any three recovery techniques. (6)

Or

(b) (i) Consider a scenario where you are asked to store information about Department complaints holding the following details:

Dept_No, Dept_Name, Location, Mgr_Name, Mgr_ID_No, Tel_Extn, Cust_No, Cust_Name, Date_of_Complaint, Nature_of_Complaint.

Also, assume that the Dept_No, and Cust_No are all needed to uniquely identify the date and nature of the complaint about the department. Identify the dependencies of the given structure and convert that as a normalized structure. (12)

(ii) Explain any one Timestamp methods for concurrency control. (4)

12. (a) (i) List possible types of failure in a distributed system. For each possible failure, explain how 2PC ensures transaction atomicity despite the failure. (10)

(ii) Explain how I/O parallelism is attained in a parallel database environment. (6)

Or

(b) (i) Describe in detail about the concurrency control in distributed databases. (8)

(ii) Explain the Intra-operation parallelism with respect to Join and Sort operations. (8)

13. (a) (i) Compare inheritance in the EER model to inheritance in the OO model. (8)

(ii) Give an equivalent OODB schema in ODL for the RDB schema of Fig. 13. (a).(ii).

Fig. 13. (a).(ii)

Or

(b) (i) List the features, advantages and disadvantages of OODBMS. (8)

(ii) Express the RDB schema of Fig. 13. (a).(ii) in POSTGRES. (8)

14. (a) (i) Explain the architecture and construction of data warehouse. (8)

(ii) Is data mining a threat to privacy and data security? Justify. (8)

Or

(b) (i) Narrate in detail the automatic web documents classification. (8)

(ii) Explain the architecture of mobile database with neat sketch. (8)

15. (a) (i) Explain in detail how the video sources are represented in multimedia database. (8)

(ii) How the rules are interpreted in deductive databases? Explain with examples.

Or

(b) (i) Explain the issues, methodology and applications of spatial database. (8)

(ii) Write an appropriate example explain the concepts of active databases. (8)

________________________