CSIT 8th Semester
Advance Database Board Question Paper 2081

CSC 461-2081 ✡
Tribhuvan University
Institute of Science and Technology
2081
✡
Bachelor Level/Fourth Year/Eighth Semester/Science
Computer Science Information Technology (CSC 461)
(Advance Database)
(New Course)
Full Marks:60 Pass Marks:24 Time:3 hours

Candidates are required to give their answers in their own words as for as practicable.
The figures in the margin indicate full marks

Section A
Long Answer Questions
Attempt any Two question.
[2x10=20]
1.

Explain different object database concepts in brief. What are type constructors?

2.

Why do we need query optimization in databases? Explain heuristic query optimization with example.

3.

Explain different distributed database architectures? What is data fragmentation?

Section B

Attempt any Eight questions

[8x5=40]
4.

Explain different constraints of specialization and generalization.

5.

What is hashing? How does hashing improve database efficiency?

6.

Explain ODMG object model.

7.

What are the uses of query trees in query processing? Explain.

8.

What is CAP theorem? Explain.

9.

What is Big Data? What are its 3 V's?

10.

What are triggers? What are the uses of triggers?

11.

Why do we need spatial databases? What are common types of analysis for spatial data?

12.

Write short notes on:
a) Map Reduce
b) Multimedia database