Punjab Technical University 2010-6th Sem B.B.A Database Management Systems - Question Paper

Roll No.......................

Total No. of Questions : 13]

Paper ID [B0148]

[Total No. of Pages : 02

Instruction to Candidates:

1)    Section - A is Compulsory.

2)    Attempt any Nine questions from Section - B.

Section - A

(15 x 2 = 30)

a)    Define Data Base?

b)    What are records and files?

c)    What is abstraction?

d)    Write components of DBMS?

e)    What is relational data model?

f)    What is hierarchical data model?

g)    Define relation representation?

h)    Define Views of table?

i)    Give function of integrity rules? j)    Write a short note on SQL?

k)    Define Security in DBMS?

l)    What are integrity and control in data protection?

m)    Write in brief about views?

n)    What are queries?

o)    How concurrency is used in data protection?

Q2) Describe different types of databases?

Q3) What are three level architecture for DBMS?

Q4) Write advantages of DBMS?

Q5) Explain entries and their attributes in DBMS?

Q6) Write a short note on different data models?

Q7) Explain the method of creating the database?

Q8) How tuples relations are created in database?

Q9) Write and explain different keys used in DBMS?

Q10)Explain database manipulation? Show with example?

Q11)What is database protection in DBMS?

Q12)What are applications of ORACLE in DBMS?

Q13)What is data distribution in Distributed databases?

+ + + +

A-51    2

Attachment: punjab-technical-university-2010-b-b-a-23026-1.pdf

Earning:   Approval pending.