BSc IT Sem III 2015 2016 2016 SYIT SEM III ADV.SQL Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Write a short note on
   • i) Granting privileges
   • d) Write a short note on hierarchical retrieval
2. Q3 Attempt any Two. 10 marks
   • a) Write a short note on substitution variable. Explain with proper example
   • b) What are the disadvantages of SQL? How PL/SQL Write a short note on attribute used in PL/SQL as name and city of a particular supplier whose supplier number is entered by the user
3. Q4 Attempt any Two
   • a)Explain following with proper code block —
   • i) FOR loop
   • b) What are the steps involved oursor nt? What is a cursor? What are the attributes used in Explicit ty pe, capacity), Update the capacity of a room by the user, Using implicit cursor, display appropriate message if the updated, otherwise not
4. Q5 Attempt any Two, 10 marks
   • a) Explain the advantages of using functions What do you mean by procedure? What are the different keywords and parameters for creating database procedure? What is the different between anonymous block and subprogram?
   • d) Consider a table Student( sname, city). Create a function to return the
5. Q6 Attempt any Two. 10 marks
   • a) Explain following steps to execute dynamic SQL with DBMS_SQL package Execute the SQL statement
   • b) Write a short note on Instead of trigger for a view Explain all types of Trigger
   • d) Consider a table Create a trigger that displays a message ‘Deleted Successfully’ after deleting a row in the Employee table
6. Q7 Attempt any Three 15 marks
   • a) Write a short note on
   • i) GROUP BY clause ORDER BY clause
   • b) Explain any five date time functions used in oracle, Explain the role of commit and rollback with respect to transaction. Also explain the concept of savepoint in it
   • d) What do you mean by parameéterised cursor? Explain its syntax. Give proper PL/SQL code
   • e) How to create, call and remove a stored function?
   • f) What is dynamic SQL?

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