BSc IT Sem III 2015 2016 2016 Advance SQL Question Paper - Mumbai University | munotes

Questions asked in this paper

• ii) Figures to the right indicate full marks

1. Q1 Attempt any Two, >
   • a) Briefly explain Sequence. What is the use of nextval and currval attribute in sequence : Write a short note on
   • i) Uniqueness Constraint Explain all Single-Row used in
   • d) Consider following is Solve following Find out the book minimum quantity, 3 li) Find out the total number of books in each Create to display the-details of book whose order is placed having ‘Henry Korth? and publisher ind out the book whose price is less than the average all books. (Solve Display the distributors city wise,
2. Q2 Attempt any = [10}
   • a) Write short note on SQL Factoring clause, Write a short note on hierarchical retrieval
   • i) UNION clause
   • d) Explain all date-time functions used in
3. Q3 Attempt any Two. 10 marks
   • a) How PL/SQL blocks are nested? with example
   • b) Explain all scalar data types available in PL/SQL
   • c) What do you mean by anonymous PL/SQL block? Explain with example
   • d) table Room(room_ id, room_type, capacity, location). Write a PL/SQL block to display the details room Whose room id is entered by the user, Attempt any Two. [10]
   • a) Explain FOR UPDATE and WHERE CURRENT Clause of cursors
   • b) What do you mean by parameterized cursor? How to declare 4
   • c) What is a cursor? What are the attributes block which will a
4. Q5 Attempt any Two Explain the ways to call a function in PL/SQL What mean by package? What are the advantages of using to.create, call and remove a stored procedure? will return total ; number of persons from the table database trigger.and a stored procedure
   • b) Explain following steps to execute dynamic SQL with DBMS_SQU
   • ii) Bind columns to cursor
   • iii) Execute query to fetch data from tables into cursor columns What do you mean Explain the syntax of creating trigger ) What do y an by Trigger? Explain the syntax of creating with note on instead of How to change the structure of created Explain with example
   • b) How to grant and revoke the privilegés from thé user?
   • c) What are identifiers? Explain with What do an excéption? Explain oracle named exception What do you mean by function? What are the different keywords and parameters used for
   • f) List out the steps in order to execute dynamic SQL with DBMS_SQL package

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