Printed Pages - 7 Roll No.
25 13579o04
I-536
M.Sc. (ITnd Semester)
Examination, May-June, 2025
COMPUTER SCIENCE
Paper- I
[Advance RDBMS (PL/SQL)1
(CS-201)
Time Allowed : Three Hours
Maximum Marks : 100
Note : Attembt all sections as directed.
SECTION -A
(Objective /Multiple Choice Questions)
Note : Attempt all questions. Choose the correct
answer. 2x10=20
Q. 1. Which database model organizes data in a tree
like structure ?
(a) Relational model
I-536 P.T.O.
(2)
(b) Hierarchical model
(c) Network model
(d) Object-oriented model
Q. 2. What is the purpose of ODBC?
(a) Database backup
(b) Cross-platform database connectivity
(c) Data redundancy control
(d) Network securty
Q. 3. What symbol represents attributes in an ER
diagram?
(a) Rectangle
(b) Ellipse
(c) Diamond
(d) Line
What is the purpose of relational algebra ?
(a) Store data
(b) Manipulate relations
I536
(3)
(c) Encrypt data
(d) Create tables
Q. 5. What does 3NF primarily eliminate ?
(a) Partial Dependency
(b) Transitive Dependency
(c) Multi-valued Dependency
(d) Functional Dependency
Q. 6. What is denormalization ?
(a) Reducing redundancy
(b) Splitting tables
(c) Introducing redundancy for performance
(d) Encrypting tables
Q. 7. What does the SQL command ALTER do?
(a) Change table structure
(b) Insert a record
(c) Delete a table
(d) Query a database
I-536 PT.0.
(4)
Q. 8. Which SQL keyword is used to remove
duplicates ?
(a) DISTINCT
(b) UNIQUE
(c) DELETE
(d) ORDER BY
Q. 9. Which command is used to handle exceptions in
PL /SQL?
(a) HANDLE
(b) RAISE
(c) THROW.
(d) EXCEPT
Q. 10. In PL/SQL, procedures and
functions are part of ?
(a) Transactions
(b) Triggers
(c) Subprograms
(d) Views
I-536
(5)
SECTION -B
(Short Answer Type Questions)
Note : Answer all questions in 100 words. 6x5=30
Q. 1. Describe the key components of an ER (Entity
Relationship) diagram with an example.
Q. 2. What are the basic operations in relationship
algebra ? Explain any two.
Q. 3. Define normalization. Why is it important in
database design ?
Q. 4. Explain the purpose of the GROUP BY and
HAVING clauses in SQL.
Q. 5. VWhat are the advantages of PL/SQL?
SECTION -C
(Long Answer Type Questions)
10x5=50
Note : Answer all questions in 350 words.
Q. 1. Explain the differenttypes of database users in a
DBMS environment.
I-536 PT.0.
(6)
OR
Discuss the architecture of DBMS with a neat
diagram and explain its components.
Q. 2. What are Extended ER (EER) features ? Explain
Generalization and Specialization with examples.
OR
Explain the various types of JOIN operations in
relational algebra with examples.
Q. 3. Discuss the anomalies that occur without
normalization and how normalization overcomes
them.
OR
Explain the concepts of 4NF and 5NF with
suitable examples.
Q. 4. Describe various Transaction Control Commands
in SQL with examples.
I-536
(7)
OR
Explain the different Integrity Constraints used
SQL with examples.
Q. 5. VWhat are Cursors in PL /SQL ? Explain implict
and explicit cursors with examples.
OR
Discuss the use of Triggers in PL/ SQL. Explain
different types of triggers with suitable examples.
I-536 200
