B.Sc. (Computer Science) Sem 3 Advanced Database Concepts Nov 2024 Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt any four: 20 marks
   • A) Explain the Architecture of PL/SQL?
   • B) Explain the various datatype of used in PL/SQL with example
   • C) What are control structures?
   • D) Write the short note in sequence?
   • E) What is a function? > F) What are the types of stored type procedure
2. Q2 Attempt any four: 20 marks
   • B) What do we mean by exception?Explain types of exceptions with
   • C) Write a short note on implicit cursor, explicit cursor, for loops?
   • D) What is a Nested table?
   • E) Explain type of Exceptions?
   • F) What are the various collection types?
3. Q3 Attempt any four: A} What are Triggers?Give an example? 20 marks
   • B) What are packages?Give an example?
   • C) What is database backup?Why is backup needed?
   • D) write a short note on commit and rollback ?
   • E) Explain ARIES algorithm of lock based protocol?
   • F) Explain the type of Trigger?
4. Q4 Attempt any five: 15 marks
   • A) Explain the components of the trigger?
   • B) Write a short note on
   • a) FOR Loops
   • b) Case Statements
   • c) While loops
   • C) What is recovery ?Explain the type of re-cavery? Explain the various types of curscr with example?
   • F) Explain the features of PL/SQL

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