Pune University BE(IT) Question Papers May June 2014 / Previous year BE(Information Technology) question papers of Pune University / BE IT Advanced Databases Question Paper / Pune University Questions with Answers
UNIVERSITY
OF PUNE
B.
E. (IT) Examination - May 2014
ADVANCED
DATABASE MANAGEMENT
(2008
Pattern)
[Time
: 3 Hours]
[Max. Marks : 100]
[Total
No. of Questions : 12] [Total No.
of Printed Pages :3]
Instructions
:
(1)
Answers to the section should be written in separate books
(2)
Neat diagrams must be drawn wherever necessary.
(3)
Assume suitable data, if necessary.
(4)
Section I :Q1or Q2, Q3 or Q4, Q5 or Q6
(5)
Section II: Q7 or Q8, Q9 or Q10, Q11 or Q12
SECTION-I
Q1) a) What is PL/SQL Engine? Draw
PL/SQL BLOCK structure. Explain each block. [8]
b) Describe the working of cursor
and types of cursors in PL/SQL. [8]
OR
Q2) a) Explain the need of
packages and describe the package in detail with its advantages. [8]
b) Compare the Embedded SQL and
dynamic SQL. [8]
Q3) a) Write a short not on [16]
i)Main Memory
Database
ii)Real Time
Transaction system
OR
Q4) a) What is Transactional
Workflow explain in detail with example. [8]
b) Explain the Optimistic
concurrency control protocol for Multidatabase System. [8]
Q5) a) Describe XML query algebra
operation. Describe FLWOR expression with example. [9]
b) What is Persistent object?
Explain the approaches to make the Object Persistent. [9]
OR
Q6) a) What is XML Schema.?
Explain with example. [9]
b) Where you would need to use
Complex data types? How would you declare structured types using SQL: 1999? [9]
SECTION
II
Q7) a) Discuss the features of
Star, Snowflake and Fact Constellation schema of Data Warehouse, Compare the
above three schemas. [9]
b) Explain Kimball database
design methodology for data warehouse. [9]
OR
Q8) a) Present a diagrammatic
representation of typical architecture and main components of data warehouse. [9]
b) What is the need of
extraction, cleaning and transformation while building data warehouse? Give
examples to support your answer. [9]
Q9) a) Explain Aproiri Algorithm
with example. [8]
b) What is Data cube? Explain the
different operations on data cube. [8]
OR
Q10) a) What is Decision tree?
How decision tree is used for classification? [8]
b) What is OLAP benchmark? List
the applications and Benefits of OLAP. [8]
Q11) a) Explain what is the need
of granting and revoking privileges. [8]
b) Explain different security and
integrity threats to the database. [8]
OR
Q12) a) What is authorization and
encryption in terms of providing security for database? [8]
b) Explain the statistical
database security. [8]
*******************
Go back to Pune University Question Papers page
No comments:
Post a Comment