Total No. of Questions—5] [Total No. of Printed Pages—2
Seat
No. [5367]-203
M.C.M. (II Semester) EXAMINATION, 2018
203 ADVANCED RDBMS USING ORACLE
(2013 PATTERN)
Time Two Hours Maximum Marks 50
N.B. Q. No. 1 is compulsory.
(ii Attempt any three from the remaining.
(iii Figures to the right indicate full marks.
1. Consider the following tables to solve queries and PL/SQL below
STUDENT Sname, city)
COURSE Cname, fee)
REGISTRATION Data-of-Reg).
Create above tables with suitable constraints.
Add at least two records in each table.
Solve any five queries 5×2=10
Display all the students from
Display the name of students who have registered for
more than two courses.
Display the No. of students registered for the course
'Oracle' in year 2016.
Add one column 'Adv-Fees-Paid' in the table Registration.
[5367]-203 2
Display the course name of Minimum Fee.
Delete the course named 'Advanced Java'.
2. Write PL/SQL block, which will accept S-Id and display the name
of the course the student in registered.
3. Write a cursor to increase the course Fee by 10% for which total
No. of registered students are more than 150.
4. Write a trigger program for not registering students on Saturday
or Sunday.
5. Write short notes on any two
Implicit and explicit cursors.
DML Statement
Data Recovery.