Download Model question papers & previous years question papers

Posted Date: 09 Sep 2008      Posted By:: jalaj    Member Level: Gold    Points: 5 (Rs. 1)

2007 Punjab Technical University B.B.A BBA(PTU 5/6sem)- DATA BASE MANAGEMENT SYSTEM (BBA-1005) Question paper



Course: B.B.A   University/board: Punjab Technical University





BBA (Semester - 5th & 6th)

DATA BASE MANAGEMENT SYSTEM (BBA-1005)

Time : 03 Hours Maximum Marks : 75
Instruction to Candidates:
1) Section - A is compulsory.
2) Attempt any Nine questions from Section - B.

Section-A
Q1) [15 × 2 = 30]
a) Why can the failure in a data base environment be more serious than
one in a non data base environment?
b) What are the benefits of a centralized data?
c) How does consistency of data result from controlling its redundancy?
d) Who are the users of a DBMS?
e) What can cause inconsistent data? How that can be avoided in a data
base?
f) What is data independence?
g) What do you mean by entity, attributes and relations in database?
h) What are the job responsibilities of a DBA?
i) What do you mean by redundancy? What are problems associated
with it?
j) What are ‘LOCKS’ used in DBMS?
k) What is data abstraction?
l) What is a candidate Key?
m) What do you mean by sharing data?
n) What do you mean by security of data?
o) What is a query? Who handles it in a DBMS?

Section-B
[9 × 5 = 45]
Q2) What are various Data Base Models? Explain in brief.
Q3) What are various characteristics of data used by an organization?
Q4) Explain the architecture of a DBMS?
Q5) What are various advantages and disadvantages of a Data Base Management
System?
Q6) Design a data base to be used by an educational institute for keeping record
of fee payments, books issued and performance of students.
Q7) How do you sort data in SQL? If there are more than one sort keys then
how do you indicate which one is the major key?
Q8) How do you join tables in SQL? Explain with the help of an example.
Q9) Explain the SELECT command and at least 5 clauses used with it?
Q10) How the shared updates cause concurrency problems in databases? Explain
the locking scheme used to deal with the concurrency problem.
Q11) Explain the concepts of ‘Replication’ and ‘Data Independence’.
Q12) What is the purpose of a distributed database? How is it different from a
centralized database?
Q13) What are various data definition and data manipulation commands?





Return to question paper search

Next Question Paper: BBA(PTU 5/6sem)- INTERNET APPLICATIONS (BBA-1004)

Previous Question Paper: BBA(PTU 5/6sem)- DATA BASE MANAGEMENT SYSTEM (BBA-1005)

Related Question Papers:


  • BBA (PTU-1 Sem)-INTRODUCTION TO MODERN BUSINESS


  • MBA (PTU-2 sem) PROJECT EVALUATION AND IMPLEMENTATION(MB-402)


  • MBA (PTU-2 sem) STRATEGIC MANAGEMENT (MB - 401)


  • MBA (PTU-2 sem) CORPORATE LEGAL ENVIRONMENT (MB-302)


  • MBA (PTU-2 sem) APPLIED OPERATION RESEARCH (MB - 301)


  • Categories


    Submit Previous Years University Question Papers and make money from adsense revenue sharing program

    Are you preparing for a university examination? Download model question papers and practise before you write the exam.

    Awards & Gifts
    Active Members
    TodayLast 7 Daysmore...

    ISC Technologies, Kochi - India. Copyright © All Rights Reserved.