Download AKTU B-Tech 5th Sem 2015-2016 Data Base Management System Ncs 502 Question Paper

Printed Pages: 6

561

NCS-502

--- Content provided by​ FirstRanker.com ---

(Following Paper ID and Roll No. to be filled in your Answer Book)

Paper ID: 110502

Roll No.

B. Tech.

(SEM. V) THEORY EXAMINATION, 2015-16

--- Content provided by‌ FirstRanker.com ---

DATA BASE MANAGEMENT SYSTEM

[Time: 3 hours]

[Maximum Marks: 100]

Section-A

1. Attempt all parts of this section. Answer in brief. (10x2=20)

   --- Content provided by‍ FirstRanker.com ---

   1. What are the advantages of file processing system which were removed by the DBMS?
   2. Give example of a simple, composite attributes of an entity.
   3. What do you mean by referential integrity?
   4. What do you mean by DML and DDL?
   5. Distinguish between functional dependency and multivalued dependency.

   --- Content provided by⁠ FirstRanker.com ---

12. What do you mean by multiple granularities? How it is implemented in transaction system?