and 2 others joined a min ago.
0
414views
Database Management Systems Question Paper - Dec 18 - Information Technology (Semester 5) - Pune University (PU)
1 Answer
0
0views
written 6.9 years ago by
teamques10
★ 70k
|
Database Management Systems - Dec 18
Information Technology (Semester 5)
Total marks: 80
Total time: 3 Hours
INSTRUCTIONS
(1) Answer Q1 or Q2, Q3 or Q4, Q5 or Q6,Q7 or Q8,Q9 or Q10..
(2) Figures to the right indicate full marks.
1.a.
Describe the three level architecture of DBMS.Explain how is it useful for achieving data independence.
(5 marks)
00
1.b.
When are two schedules said to be view equivalent?
(5 marks)
00
OR
2.a.
List the responsibilities of DBA
(5 marks)
00
2.b.
Describe DROP TABLE command of SQL with both the options CASCADE and RESTRICT
(5 marks)
00
3.a.
Write short note on : Mapping of ISA relationship of E-R diagram to tables
(4 marks)
00
3.b.
State and explain (any 6) Codd's norms for RDBMS
(6 marks)
00
OR
4.a.
What are the measures of Query cost?
(5 marks)
00
4.b.
Why are cursor necessary in embedded SQL?
(5 marks)
00
5.a.
Draw and explain the architecture of Parallel databases
(6 marks)
00
5.b.
What is a checkpoint? List the operations to be performed by the system when a checkpoint is to be taken. What does the recovery system do if there is a crash.
(10 marks)
00
OR
6.a.
Explain Query optimization with respect to SQL databases.
(8 marks)
00
6.b.
Discuss and explain data replication and allocation issues in distributed database system.
(8 marks)
00
7.a.
Explain XML data model. list advantages of XML
(8 marks)
00
7.b.
Explain in brief the advantages of MongoDB over RDBMS
(8 marks)
00
OR
8.a.
Discuss data management issues in cloud databases
(8 marks)
00
8.b.
What is HDFS? Draw and explain the architecture.
(8 marks)
00
9.a.
Explain association rules with Support and Confidence measures.
(6 marks)
00
9.b.
Explain architecture of data mining system.
(6 marks)
00
9.c.
Explain the conceptual models for data ware house.
(6 marks)
00
OR
10.a.
Write a short note on any 3
(12 marks)
00
i) Data processing techniques
ii) OLAP
iii) Machine learning for business intelligence
iv) Big data features
10.b.
Explain KDD in detail
( 6 marks)
00
ADD COMMENT
EDIT
Please log in to add an answer.