Advanced Database Management System - Tutorials and Notes: CS9024 Advanced Database Technology April May 2014
Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Sunday, 28 February 2016

CS9024 Advanced Database Technology April May 2014

Anna University Questions - CS9024 Advanced Database Technology April May 2014, Computer Science and Engineering, Fifth Semester, Regulation 2008

Academic Year
April May 2014
Subject Code


Subject Name

Advanced Database Technology

Computer Science and Engineering
Fifth Semester

Computer Science and Engineering
Fifth Semester
(Regulations 2008)
Time : 3 Hours                      Answer A L L Questions                Max. Marks 100
PART-A (10 x 2 = 20 Marks)

1. Brief on generalization in ER model.
2. Mention any two methods of database tuning.
3. How vertical fragmentation achieves data availability feature of distributed databases?
4. List the different types of failures in distributed database system.
5. What is the significance of multi version locking in OODB?
6. Illustrate the differences between the type constructors - Set and List.
7. What is data cube? Mention any two operations that can be performed on a data cube.
8. Mention any two features of web databases.
9. What are the major components of knowledge bases?
10. List any three data structures that support multimedia databases? Give the representation of any one.

Part-B (5* 16 = 80 Marks)

11. i) Consider the following relation containing the attributes:
Bookid, subject_category_of_book, authorname and nationality_of_author.
Primary Key : Bookid
1) What is the highest normal form satisfied by this relation?
2) Suppose the attributes books_title and author_address are added , and the PK is changed to {authorname, books_title}, what will be the highest normal form satisfied by this relation? (8)
ii) Illustrate the stages of query processing. (8)

12. a i) Explain the Client / Server architecture of distributed databases. (8)
a ii) Describe the concurrency control in distributed databases. (8)
12. b i) Consider a company relation that is fragmented horizontally by plant-no and given as Employee(name, address, salary, plant-no). Assume that each fragment has two replicas; one stored at the Chennai site and another stored locally at the plant site of
Trichy. Describe a good processing strategy for the following queries entered at the Madurai site: (8)
(A.) Find all employees at the Chennai site.
(B.) Find the lowest paid employee at Cochin and Mumbai sites.
(C.) Find the highest paid employee in the company.
ii) Explain 2 phase commit protocol of distributed databases. (8)

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

Fig. : 13. a.
a ii) Give a comparison between OODM and ER model. (8)
13. b i) Explain the mechanism to make the objects persistence in OODB. (8)
b ii) Compare the features of GEMSTONE and JASMINE object databases with examples. (8)

14. a i) Give the benefits and limitations of data warehouse. (8)
a ii) Explain with examples, any four operations that can be performed on a data cube.
14. b i) Explain the architecture of mobile database with a neat diagram. (8)
b ii) Compare and contrast the CGI and API (8)

15. a i) Illustrate how active databases help audit-trail applications. (8)
a ii) Explain how video sources are represented in a multimedia database. (8)
15. b i) Explain deductive databases with suitable examples. (8)
b ii) What are range queries, neighbour queries and joins with respect to spatial database? Give example for each. (8)



No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents