RDBMS, Question Paper of MBA (IT) 3rd-4th Semester,Download Previous Years Question Paper 1

Roll no ....................

Total No. of Questions: 07]

Paper ID [MB682]

MBA(Sem.-3^rd & 4^th )

RDBMS (MB-682)

TIME: 03 Hours

Instruction to Candidates :

1)    Attempt any one question form each sections A,B,C,D.

2)    Section –E is compulsory.

Section – A

1.      

a.      Describe the three schema architecture. Why do we need mapping between schema levels? How do different schema definition languages support this architecture?

b.     What are the different types of database end users? Discuss the  main activities of each.

2.      

a.      Discuss the characteristics of a data warehouse. Divide them into functionality of a warehouse and advantageous users derive from it.

b.     What is meant by data allocation in distributed database design? What typical units of data are distributed over sites?

Section –B

3.      

a.      What is an entity type? What is an entity set? Explain the difference among an entity, an entity type and an entity set.

b.     Explain different constraints in relational model.

4.      

a.      Compare Hierarchical and Network model.

b.     Explain object oriented databases.

Section –C

5.     What is relational calculus? Explain with examples tuple and domain relational calculus.

6.       

a.      Discuss insertion, deletion and modification anomalies. Why are they considered bad? Illustrate with examples.

b.     What is meant by the completeness and soundness of Armstrong’s inference rules?

Section – D

7.     What is meant by the concurrent execution of database transactions in a multi-user system? Discuss why concurrency control is needed and give informal examples.

8.      

a.      Describe the four levels of isolation in SQL.

b.     What is security threat? Explain different security threats.

9.       

a.      What is database?

b.     What is primary key?

c.     What is data mining?

d.     What are homogeneous distributed databases?

e.      What are the disadvantageous of network model?

f.       Define the different type of attributes in E-R model.

g.     What is difference between the random access and sequential access?

h.     Define the term fully functional dependency.

i.        What is database integrity?

j.        What is system lock?