BSc CS Sem 3 2023 2024 2024 ADVANCED DATABASE CONCEPTS Question Paper - Mumbai University | munotes

Questions asked in this paper

• 2) Figures to the right indicate marks

1. Q3 Mixing of sub-questions is not allowed
2. Q1 Attempt the following. (Any FOUR) (20M)
   • (b) | What do you mean by Function? What are the different keywords and parameters used for creating database function? How do we call it?
   • (c) with suitable example:
   • i) IF.THEN.ELSIF statement
   • (d) is Sequence? its all parameters
   • (e) What are benefits of Stored procedure? Consider table Book (ISBN, author). Create a function to return the title of the book for a given ISBN. Use a PL/SQL block to execute the code
3. Q2 Attempt the following. (Any FOUR) (20M) What do you mean by Collection? Explain its methods How oracle handles exception? Explain with syntax Write a note on Variable size array
   • (d) out the steps in order to execute SQL with SQI package Cursor. Explain all the steps involved in the explicit cursor execution,
   • (1) table Person fname, Iname, city, salary). Write implicit cursor to update salary of each person by 5000/ = Q.3 the following. (Any FOUR)
   • (a) Explain all the phases of ARIES Algorithm
   • (b) What do you mean by deadlock? the mechanism to detect a deadlock do you mean by Serializability? Explain View Serializability
   • (d) different states through which transaction goes during its execution do you mean by | rigger? Explain with its types, Consider a table Create a trigger that displays a messave “Deleted Successfully” deleting a row trom an | mployee table
4. Q4 Attempt the following. (Any FIVE) (15M)
   • (a) Write short note on GOTO statement
   • (b) the following — Datetime and Interval types
5. Q2 Character types
6. Q3 Numeric types
   • (c) the uses of %type and attributes used in oracle
   • (d) the concept of CURSOR FOR LOOP. Write short note on Package Specification. 4
   • (f) Write a note on Dirty Read problem

Read from the scan above, so a character or two may differ. The scan is the original.