and 3 others joined a min ago.
0
339views
Database Management Systems Question Paper - Jun 18 - Information Technology (Semester 5) - Pune University (PU)
1 Answer
0
1views
written 6.9 years ago by
teamques10
★ 70k
|
Database Management Systems - Jun 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) Neat diagrams must be drawn wherever necessary.
(3) Figures to the right indicate full marks.
(4) Assume suitable data if necessary.
1.a.
State & explain the disadvantages of File processing system
(5 marks)
00
1.b.
Define entity & entity-set. What is E-R model?
(5 marks)
00
OR
2.a.
What is query? What do you mean by correlated subquery?
(4 marks)
00
2.b.
List the properties of decomposition. Explain loss less join with example.
(6 marks)
00
3.a.
What are the steps followed in executing write (X) command in transaction?
(5 marks)
00
3.b.
Define query processing. Hat are the steps involved in query processing?
(5 marks)
00
OR
4.a.
When are two schedules said to be view equivalent?
(6 marks)
00
4.b.
Why are cursors necessary in embedded SQL?
(4 marks)
00
5.a.
What is a checkpoint? Explain the operations performed by a system during checkpoint. Explain the recovery mechanism during system crash.
(8 marks)
00
5.b.
What are the design considerations for distributed database?
(8 marks)
00
OR
6.a.
What are the key elements of Parallel DB processing? Explain
(8 marks)
00
6.b.
Explain Time stamp ordering protocol.
(8 marks)
00
7.a.
Draw & explain HBase data model
(6 marks)
00
7.b.
Compare JSON and XML with example.
(6 marks)
00
7.c.
Explain NoSQL concept with MongoDB example.
(6 marks)
00
OR
8.a.
Write a short note on any three
(12 marks)
00
i) SQLite database
ii) Mobile database
iii)Internet database
iv)Cloud database
8.b.
How data validation is done in XML?
(6 marks)
00
9.a.
What is data warehousing?Write the benefits & limitations of data warehousing.
(8 marks)
00
9.b.
Explain the process of knowledge discovery with diagram.
(8 marks)
00
OR
10.a.
Write short notes on
(8 marks)
00
i)Machine learning for Big data
ii) Business Intelligence
10.b.
Explain classification in detail with example
(8 marks)
00
ADD COMMENT
EDIT
Please log in to add an answer.