mba-3-sem-erdms-using-oracle-march-2012

mba-3-sem-erdms-using-oracle-march-2012

Master of Business Administration (MBA) Examination

III Semester

(RDMS Using ORACLE)

Time : 3 Flours]                                                                                               [Max. Marks : 80

1.         What is an E-R modeling? Explain different types of entities.

OR

What are different anamolies which must be removed to get various normal forms? Explain.

2.         What is transaction control language and its use.

OR

Write short note on :

DDL, DML, DCL and TCL.

3.         Write about the use of group by and having clause in SQL.

OR

What do you mean by inner join outer, join, left and right outer join along with the examples.

4.         Write short note on :

Stored functions.

OR

Why we use PL / SQL?

5.         Write short note on :

(a) OLAR

(b) Recovery and failure.

OR

Explain transaction management ad recovery and failure,