B.Sc. (Computer Science) Sem 3 Advanced Database Concepts Oct 2022 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)
   • (a) all scalar data types used in oracle
   • (b) What are the advantages of PL/SQL?
   • (c) Explain with suitable example:
3. Q1 IF THEN statement
   • (d) Explain CASE structure with proper syntax. Give suitable example for it
   • (e) are the different ways to store data in variable? Illustrate with proper
   • (f) Create a procedure to calculate square of a number. Use PL/SQL block to
4. Q2 Attempt the following. (Any FOUR) (20M)
   • (a) Write a note on Variable size array
   • (b) List out the steps in order to execute dynamic SQL with DBMS SQL. package
   • (c) Write a note on SQL Injection
   • (d) Define Cursor. Explain ail the steps involved in the explicit cursor execution
   • (e) are Collection Comparisons? Also explain the Collection Methods
   • (f) Use student(rollno,sname,marks) table. Insert one row with NULL in marks column. Create a user defined exception if marks of particular student is null
5. Q3 Attempt the following. (Any FOUR) (20M)
   • (a) Explain ARIES Algorithm. What are the main principles behind the ARIES
   • (b) Explain Deadlock prevention mechanism
   • (c) What are different steps involved in package invocation?
   • (d) note on Two Phase Locking protocol
   • (e) What are the advantages of Concurrent
   • (f) Consider a table Actor Create a trigger that displays a message ‘Updated Successfully” after updating a row in the Actor table VCD/ SYCS SEM- III ADVANCED DATABASE CONCEPTS 75-MARKS _ 2!” HOURS
6. Q4 Attempt the following. (Any FIVE) (15M)
   • (a) What is Sequence in PL/SQL? Explain its parameter,
   • (b) Explain the concept of NULL in PL/SQL
   • (c) Write note on Nested Tables
   • (d) the uses of and “orowlype attributes used in oracle
7. Q1 Serial Schedule
   • (f) Explain Lost Update Problem in transaction

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