B.C.A/B.B.A. (III Semester) EXAMINATION, 2018
301 RELATIONAL DATABASE MANAGEMENT SYSTEM
(RDBMS)
(2013 PATTERN)
Time Three Hours Maximum Marks 80
N.B. Neat diagrams must be drawn wherever necessary.
(ii Figures to the right indicate full marks.
(iii All questions carry equal marks.
All questions are compulsory.
1. Attempt all
What is PL/SQL List the sections of a PL/SQL block.
What is RDBMS List any four characteristics of RDBMS.
Define
Upgrading
(ii Downgrading.
What is Schedule List the types of Schedule.
What is procedure in PL/SQL Give syntax of procedure.
[5363]-301 2
Define
Redo
(ii Undo.
What are the different types of storage Gvie example.
Define
Logical error
(ii System error.
2. Attempt any four
Explain advantages and disadvantages of RDBMS.
What is cursor Explain various attributes of cursor.
Explain recoverable schedule and cascadeless schedule with
example.
What is Deadlock Explain how deadlock is hundled.
Explain immediate database modification technique in detail with
example.
3. Attempt any four
What is transaction Explain the states of transaction with
the help of diagram.
What is Log Explain log-based recovery.
Write a note on package in PL/SQL.
Explain two-phase locking protocol with example.
Explain remote backup system with the help of diagram.
[5363]-301 3 P.T.O.
4. Attempt any four
Consider the following relational database company cname,
ccity, cshare_value)
Person Pname, Pcity, Pph.no)
Company-person Pno, no-of-shares).
Write a function which will return total number of companies
from given city.
Condider the following relational detabase
Employee ename, city, deptname)
Project pname, status)
Emp-proj pno, no-of-days)
Write a trigger that restricts insertion or updation of records
having no-of-days less than zero.
Consider the following relational database customer cname,
ccity, mob-no.)
Loan loan-amt, no-of-years, cno).
Write a cursor to display details of customer and their loan
who have token loan for more than 10 years.
Consider the following relational database
Patient Pname, Paddr)
Doctor Dname, Daddr, city)
Patient-Doctor Dno, disease, no-of-visits)
Write a procedure which will display doctor details who is
treating the diabetes patient.
[5363]-301 4
Write a package which will consist of one procedure and one
function.
Write a procedure which will display first n numbers using
for loop.
Write a function which will return cube of a given number.
5. Attempt any four
Consider the following transactions. Find out two non-serial
schedules that are serializable
T1 T2
Read Read
P P 10 Q Q 10
Write Write
Read Read
Q Q/10 R R 10
Write Write
Consider the following transactions. Find out two non-serial
schedules that are serializable
T1 T2
Read Read
x x 1000 x x 1000
Write Write
Read Read
Read y y 2000
[5363]-301 5 P.T.O.
y y 2000 Write
Write
z z 3000
Write
The following is the list representing the sequence of events
in an interleaved execution of set T1, T2, T3 and T4 assuming
two-phase locking protocol.
Is there a deadlock If yes, which transactions are involved
in deadlock
Time Transaction Code
t1 T1 Lock
t2 T2 Lock
t3 T3 Lock
t4 T4 Lock
t5 T1 Lock
t6 T2 Lock
t7 T3 Lock
t8 T4 Lock
The following is the list representing the sequence of events
in an interleaved execution of set T1, T2, T3 and T4 assuming
two-phase locking protocol. Is there a deadlock If yes, which
transactions are involved in deadlock
[5363]-301 6
Time Transaction Code
t1 T1 Lock
t2 T2 Lock
t3 T3 Lock
t4 T4 Lock
t5 T1 Lock
t6 T2 Lock
t7 T3 Lock
t8 T4 Lock
The following are the log entries at the time of system crash
[Start-Transaction, T1]
[Write-item, T1, 2000]
[Commits, T1]
[Check point]
[Start-Transaction, T4]
[Write-item, T4, 3000]
[Write-item, T4, 2000]
[Commit, T4]
[Start-transaction, T2]
[Write-item, T2, 2000]
[Start-transaction, T3]
[Write-item, T3, 3000] System crash
If deferred update technique with check point is used, what
will be the recovery procedure