BSc IT Sem III ATKT 2015-16 ATKT SQL Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt any Two
   • a) Explain all Single-Row functi 10
   • b) Define sequence t used in generate list of number 1, 3, 5 access of current and next 3, 5, ., 999. Also explain how to get
   • c) Write short note on
   • d) Consider following tables Solve following queries — !) How many orders placed by each customer? 4 ii) List the customers living in city virar
   • iii) Find out orders placed in the Month of August 2015
2. Q2 Attempt any Two 10 marks
   • a) How to grant and revoke the privileges from the user?
   • b) Write a short note on hierarchical retrieval
   • c) Write a short note on set operation used in oracle
   • d) Write any five date-time functions used in oracle
3. Q3 Attempt any Two 10 marks
   • a) What are identifiers? Explain with its types
   • b) What do you mean by anonymous PL/SQL block? Explain with example
   • c) Write a short note on substitution variable. Explain with proper example Write a PL/SQL block to display the details of Employee whose is entered by user Attempt any Two
   • a) What do you mean by exception? Explain oracle named exception handlers
   • b) What are the attributes of Implicit cursor Explain Cursor for loop with proper Write a PL/SQL block which will display all “PL/SQL Books ny Two it? by function? What are different keywords and used for it a procedure on SQL command prompt? Illustrate with example How to create, call and remove a stored hich will count number of a d display it on screen. Use PL/SQL block to execute the func
4. Q6 Attempt any Two 4 marks
   • a) List out steps in order to execute dynamic SQL with DBMS-SQL package
   • b) What do you mean by Trigger? Explain the syntax of creating trigger Explain following steps to execute dynamic SQL with DBMS-SQL package
   • ii) Bind column to cursor columns
   • d) Write short note on - instead of trigger
5. Q7 Attempt any Three a
   • a) How to change the structure of created table? Explain with example
   • b) Write short note on With Clause. 4 How PL/SQL blocks are nested? Illustrated with example
   • d) Explain FOR UPDATE & WHERE CURRENT Clause of cursors What do you mean by package? What are advantages of using package?
   • f) Explain all types of trigger. 3

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