Guru Nanak Dev University 2011 B.Sc Information Technology Dtatbase Management System And Oracle - Question Paper

2411


B.Sc.(Information Technology) Part-2

DATABASE MANAGEMENT SYSTEM AND ORACLE

Paper-4

[Time allowed:Three hours] [Maximum Marks:100]

Note:-Attempt any 5 ques. carry equal marks.

1. What is RDBMS? Is Oracle a complete RDBMS? Justify
your ans. Also chart the capabilities of Oracle eight
with brief description of every. 20

2. (a) "Non-loss decomposition is an aid to relational
database design." Is it true? If yes, then justify
it through an improper example. 10
(b) What is DDL? How it is various from DML and DCL?
Illustrate the difference through suitable examles. 10

3. (a) What do you understand by PL/SQL? explain its
important elements as well as its usefulness. 10
(b) What is DBA? elaborate responsibilities of DBA?
explain. 10

4. What is normalization ? Explai successive normalization
in designing a relational database by taking a suitable
example of your option. 20

5. discuss the following:-
(a) Database Recovery. 10
(b) Triggers in Oracle. 10

6. What do you understand by database models? elaborate
various database models? Compare and contrast all
these models. 20

7. (a) describe database. Differentiate ranging from 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? discuss the purpose
of subsequent SQL commands:-
(1) INSERT
(2) DROP
(3) JOIN
(4) DELETE 10

8. discuss the subsequent terms:-
Database system, Foreign Key, Alternate Key, file,Record,
Primary Key, Candidate key, Tuple, Domain. 20

Earning:   Approval pending.