Pune University BE(CSE) Question Papers / Previous year BE(Computer Engg.) question papers of Pune University / BE CSE Advanced Databases Question Paper / Pune University Questions with Answers
UNIVERSITY
OF PUNE
[4659]-207
B.
E. (IT) Examination - 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 cursor? Explain with
diagram the different types of cursor. [8]
b) Explain the PL/SQL block
structure in detail. [8]
OR
Q2. a) What is trigger? Write the
trigger for updating the records in the database. [8]
b) Explain embedded SQL and
dynamic SQL. [8]
Q3. a) Explain the architecture
of transaction processing monitor. [8]
b) Explain two-phase locking with
example. [10]
OR
Q4. a) Explain ACID properties.
[4]
b) Explain real-time transaction
systems. [4]
c) What are the different types
of concurrency control? Explain any one in detail. [10]
Q5. a) Discuss the table
inheritance in SQL. [4]
b) Consider the database schema
with a relation University whose attributes are as shown below; with types specified
for multi-valued attributes. [12]
Staff(sname, Department set
multiset(department), subject set multiset(subjects)).
Department = (name, joining date)
Subjects = (type, exam set of
(exams))
Exams = (year, place)
i) Define the above schema in
SQL:2003 with appropriate types for each attribute.
ii) Using database schema in
SQL:2003, write the following queries;
1. Find name of all staff who
have joined after January 2013.
2. List all subjects in the
relation University.
OR
Q6. a) Explain document type
definition. Describe a DTD with suitable example for an XML. [8]
b) Write the applications of XML.
[4]
c) Differentiate object oriented
(OO) and object relational (OR) databases. [4]
SECTION
II
Q7. a) Explain in detail the data
warehouse architecture. [8]
b) Write short notes on the following;
[10]
i) Online transaction processing
ii) Data warehouse data house
iii) Dimensionality modeling in
data warehouse
iv) Data warehouse using Oracle
v) Data marts
OR
Q8. a) Explain the functions of
Administration & Management toos in data warehouse. [10]
b) Explain the approaches taken
by vendor to provide data extraction, cleansing, and data transformation tools.
[8]
Q9. a) Write the algorithm for
K-Mean data mining. [8]
b) Describe the characteristics
of multi-dimensional data and how this data can be represented? [8]
OR
Q10.a) Write short notes on the
following; [8]
i) OLAP benchmarks
ii) Applications and benefits of
OLAP
iii) Bayesian classifier
iv) Predictive modeling
b) Discuss OLAP functionality
provided by ROLLUP and CUBE of SQL standard. [8]
Q11. a) Write the types of locks.
[4]
b) Explain exception handlers in
Oracle. [4]
c) Explain implicit and explicit
locking in Oracle. [8]
OR
Q12. a) Write notes on database
security and threats. [8]
b) Explain the authorization and
access control for providing security for database. [8]
*******************
Go back to Pune University Question Papers page