Saturday, May 7, 2016

Advanced Database Management - Pune University Question Nov Dec 2014

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


B. E. (IT) Examination - 2014
(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

Q1. a) What is cursor? Explain with diagram the different types of cursor. [8]
b) Explain the PL/SQL block structure in detail. [8]
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]
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. 
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]

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
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]
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]
Q12. a) Write notes on database security and threats. [8]
b) Explain the authorization and access control for providing security for database. [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

data recovery