Friday, October 2, 2015

Database Management System and Oracle GNDU 2011 Question Paper

Guru Nanak Dev University
B.Sc Information Technology
Database Management System and Oracle
2011 Question Paper
Time:3 Hrs
Minimum Marks:100.
Note:-Attempt any FIVE questions carry equal marks.
1. What is RDBMS? Is Oracle a complete RDBMS? Justify your answer. Also chart the capabilities of Oracle with brief description of each. 20
2. (a) "Non-loss decomposition is an aid to relational database design." Is it true? If yes, then justify it through an appropriate example. 10
(b) What is DDL? How it is different from DML and DCL?
Illustrate the difference through suitable examples. 10
3. (a) What do you understand by PL/SQL? Discuss its important elements as well as its usefulness. 10
(b) What is DBA? What are responsibilities of DBA? Discuss. 10
4. What is normalization ? Explai successive normalization in designing a relational database by taking a suitable example of your choice. 20
5. Explain the following:-
(a) Database Recovery. 10
(b) Triggers in Oracle. 10
6. What do you understand by database models? What are different database models? Compare and contrast all these models. 20
7. (a) Define database. Differentiate between a database processing system and a file processing system. Illustrate the difference through suitable example(s). 10
(b) What is SQl? Why is it popular? Explain the purpose of following SQL commands:-
(1) INSERT
(2) DROP
(3) JOIN
(4) DELETE 10
8. Explain the following terms:-
Database system, Foreign Key, Alternate Key, file,Record,
Primary Key, Candidate key, Tuple, Domain. 20

Duraimani

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as www.IndianUniversityQuestionPapers.com . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!