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.
________________________