CSIT 8th Semester
Advance Database Board Question Paper 2081

Views: ...
CSC 461-2081 ✡

Tribhuvan University

Institute of Science and Technology

TUpapers.com TUpapers.com
Bachelor Level/Fourth Year/Eighth Semester/Science
Bachelors in Computer Science and Information Technology (CSC 461)
(Advance Database) <br> <b class='underline'>(New Course</b>)
Full Marks: 60 Pass Marks: 24 Time: 3 hours

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

Section A
Long Answer Questions
Attempt any Two questions.
[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

[8×5=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