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

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

Master of Business Administration (MBA) Examination

III Semester

(RDMS Using ORACLE)

Time : 3 Hours]                                                                                               [Max. Marks : 80

1.         What is an E-R model? What are different symbols used in E-R diagram?

OR

What two conditions must be meet before an entity can be classified as weak entity. Give an example of an weak entity.

2.         Explain briefly :

(a)        The data definition language.

(b)        The data manipulation language.

3.         Explain the variables and constructs used in PL / SQL.

4.         Describe the design and basic principles of data warehousing.

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