Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Year

Tribhuwan University

Institute of Science and Technology

2076

Bachelor Level / Second Year / Fourth Semester / Science

B.Sc in Computer Science and Information Technology (CSC265)

(Database Management System)

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 Answers Questions

Attempt any TWO questions.
[2*10=20]
1.
What are the advantages of using Database Management System over traditional filing system? Explain different data models with example.[10]
2.
What is concurrency control? Name various methods of controlling the concurrency control? Differentiate between Binary lock and shared/Exclusive lock.[10]
3.
What is normal form? Explain their types. Explain about loss-less join decomposition.[10]
Section B

Short Answers Questions

Attempt any Eight questions.
[8*5=40]
4.
What is data abstraction? What are three levels of data abstraction? Explain. [5]
5.
What is difference between Entities and Entity sets? Explain with example. [5]
6.
Create two table Courses (CID, Course, Dept) and HoD (Dept, Head) using SQL language with all constraints [Primary key, Foreign key and Referential Integrity]. Assume the types of attributes by your own. [5]
7.
Differentiate between Integrity and Security with example. [5]
8.
Define schedule and serializability. How can you test the serializability? [5]
9.
What is Granularity of data items? How does it effect in concurrency control? [5]
10.
Explain 2 phase locking technique in brief. [5]
11.
What are the different approaches of Database recover? What should log file maintain in log-based recovery? [5]
12.
Explain the use of primary and foreign key in DBMS with example. What is the role of foreign key? [5]