MCA MAGADH UNIVERSITY QUESTION, (2016-2019) Database Management Systems

MCA MAGADH UNIVERSITY QUESTION, (2016-2019) Database Management Systems 

                                                                            2016-2019
                                                                         Time: 4 hours
                                                                        Full Marks: 80
                                             Candidates are required to give their answers in their
                                                            Own words as far as practicable.
                                                             The questions are of equal value.
                                                                   Answer any five questions.


1. Define DBMS and RDBMS. Write differences between these two.

2. What is Oracle? Explain SQL with example.

3. Describe the following:
    (i) DDL
    (ii) DML
    (iii) DQL
    (iv) TCL

4. What is relational Algebra? Explain the following:
    (i) Union of two relations
    (ii) Intersection of two relations
    (iii) Projections of a relation
    (iv) Selection of a relation

5. What is PL/SQL? Write its advantages. Write a PL/SQL code to find the factorial of a given number.

6. What is Cursor? Write its different operations.

7. What is normal form? Explain 3NF and BCNF.

8. What are functions and procedure in PL/SQL ? Write a PL/SQL code to find the sum of two given numbers by using procedure.

9. What is E-R diagram? Illustrate with example.

10. Write short notes of any two of the following:
      (i) HISAM
      (ii) HDAM
      (iii) HIDAM
      (iv) HSAM