Acharya Nagarjuna University (ANU) 2005 B.Tech Computer Science and Engineering CS/IT 423 Advanced Database Management System - Question Paper

IV/IV B.Tech Degree Examination, April 2005
Second Semester
Advanced Database Management System
CSE/IT 423

(CSE/1T 423)

TV/1V B.Tech. DEGHEE EXAMINATION, APKJL 2005.

Second Semester

ADVANCED DATABASE MANAGEMENT SYSTEMS

Tiine : Three hours    Maximum : 70 marks

Answer Question No,. 1 compulsorily,

(CSE/1T 423)

(lx 14= 14}

Answer ONE question from each Unit.

(CSE/1T 423)

(4 x 14 = 56)

All questions carry equal marka,

~    .    aL

1. (a) What are the advantages of query optimization?

(b)    Define Materialization,

(c)    What is query processing plan?

(d)    What is location transparency?

e) What are advantages of distributed computing aystem?

(f)    What is replication transparency?

(g)    What is horizontal fragmentation?

(h)    What Is oracle?

is DDL? Give its commands..

(j)    What is DCL? Give itecommands.

(k)    What is data warehouse?

(1)    What is meant by flexible reporting?

(m)    What is a special schedule?

(n) What ia difference between integrity and security?

unitI

2; (a) What is meant by term heuristic optimization? Discuss the main heuristic that are applied during queiy optimination.

Or

(b) Diaeuss the timeu stamp ordering protocol for concurrency control. How does strict timer stamp ordering differ from basic time tamp ordering?

3. {a) Explain the features of distributed data bases,

J-    

(b) Describe the two-phase commit protocol for muIti-databas%trangactions.

Or

Explain the components of distributed database management system (DDBMSa),

(d) What ia meant by transaction rollback? Explain.

mirm

4. (a) What are the origins of the object oriented approach,

(b)    Discuss the concept of polymorphism and 'operator overloading.

Or

(c)    Write notes on ;

(i)    Inlieritpice

(ii)    Data Definition Language (DDL)¹

(iii)    Relational database.

S. (a) Explain the characteristics of warehouse, devide them intb functionality of warehouse and advantages uars deriyo from it,

fr?-

'(b) List the difficulties in implementing a data ware house.

Or

(c) What are the goals or tasks that data miniiig attempts to facilitate?    

{d}., What is data mining? How does data mining technology relate to data warehouse technology?

4    (CSE/IT 423)

Attachment: acharya-nagarjuna-university--anu--2005-b-tech-computer-science-and-engineering-7630-1.pdf

Earning:   Approval pending.