Database Management System – BSc.CSIT (TU) Question Paper 2072 | Fourth Semester

Download our Android App from Google Play Store and start reading Reference Notes Offline.

DBMS question paper 2072Fourth Semester | Second Year | Tribhuvan University
Computer Science and Information Technology (CSc. 253)
Database Management System, Year: 2072
Old Question Collection | Question Bank

Download Question Paper File
[File Type: PDF | File Size: 281 KB | Download]

OR you can read question paper online below;
Full Marks: 60 | Pass Marks: 24 | Time: 3 hours.

Attempt all the questions:

  1. Answer the following questions in short: (5×2=10)
    1. Three-schema architecture
    2. Advantage of DBMS approach over file system approach.
    3. What is weak entity, owner entity type and identifying relationship?
    4. Different types of data attributes.
    5. Differentiate between program-data independence and program-operation independence.
    1. Given an ER diagram for a database showing Bank. Each Bank can have multiple Branches, and each branch can have multiple accounts and loans. [6]
    2. What is union compatibility? Define operations union, intersection, and difference on two union compatible relations R and S with suitable example. [4]
    1. Describe the different clauses in the syntax of an SQL query, and show what types of constructs can be specified in each clause. [5]
    2. How view is defined in SQL? Explain the problems that may arise when one attempts to update a view. [1+4]
    1. Define Boyce-Codd normal form. How does it differ from 3NF? Why is it considered a stronger form of 3NF? [1+4]
    2. What is a functional dependency? When are two sets of functional dependencies equivalent? How can we determine their equivalence? [1+4]
    1. Discuss the ACID properties of a database transaction with suitable example. [5]
    2. Indicate how the recovery scheme works in a single user environment if the system fails
      1. After the transaction starts and before the read.
      2. After the read and before the write.
      3. After the write and before the commit.
      4. After the commit and before al database entries are flushed onto disk. [5]
    1. What is the two-phase locking protocol? How does it guarantee serializability? [5]
    2. What is meant by transaction rollback? What is meant by cascading rollback? Why do practical recovery methods use protocols that do not permit cascading rollback? [5]
(Visited 868 times, 1 visits today)

Posted By : Digvijay | Comment RSS | Category : Fourth Semester, Old Question Collection
Tag :

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

Wordpress DMCA
Community | Toolbar | Android App | Founder/Developer : Hari Prasad Chaudhary | CSIT Portal Manager : Digvijay Chaudhary