BSc CS Sem 5 BSc CS Semester 5 (2014 2015) 2015 DBMS Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Explain the usage of the Precedence Graph with the an example
   • (f) Explain the following : 2, Attempt the following (any three)
   • (4) Whatis ARTES ? Explain its phase (hb) With the help of a diagram, ex the 2 Phase Locking protocol
   • (c) a note on Manager,
   • (d) late the different structures, Explain any two of them Define deadlock, explain the different policies for preventing a
   • (f) What is the diff optimistic and pessimistic concurrency control, State phases in optimistic concurrency control 1, Attempt the (any
   • (a) State the data types in PL/SQL with example, how variables can be
   • (h) help of an example, explain the Loop statements of QWrite a short note on nested table, af What is the role of NULL values in PL/SQL ? block that accepts the owner name from the user. The SYS, HR or SCOTT. The username can be SYS the print the result as “Owner is SYS”. If it is SYSTEM, the result as “Owner is SYSTEM” and so on. Write the code using CASE ey
   • (f) Write a PL/SQL block to find the square of a number which is from the table square (num, sq) and store it under sq in the given
2. Q4 Attempt the following (any three)
   • (a) What is cursor ? State and explain the types of cursor
   • (b) What is metadata ? What metadata is stored in system Describe the information stored per relation
   • (c) With the help of a diagram explain the stages of a Quesy Optimization
   • (d) What are commit, savepoint and rollback ? their usage with Explain how read only transactions are ‘Explain the different
   • (f) Assuming a table products (p-no, p-stock, p-price). State and explain the queries to generate the using sequence. Also explain how to display the next value of the squence
3. Q5 Attempt the following (any three) 15 marks
   • (a) Explain the concept of WW conflicts What is log file ? List foxwhich different actions in a database log record
   • (d) Explain the between cursor for loops and parameterized cursors
   • (e) State and- Write Rule State and the artributes of a cursor

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