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

Questions asked in this paper

1. Q1 Attempt any Two 10 marks
   • a) Explain all Single-Row functions used in oracle
   • b) Define sequence to generate list of number 1, 3, 5, ., 999. Also explain how to get access of current and next value of the sequence,
   • c) Write short note on
   • i) Check constraint
   • d) Consider following tables Solve following queries —
   • i) How many orders placed by each customer?
   • 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 10
   • a) What do you mean by exception? Explain oracle named exception handlers
   • b) What are the attributes of Implicit cursor
   • c) Explain Cursor for loop with proper example Write a PL/SQL block which will display all “PL/SQL” Books
4. Q5 Attempt any Two 10 marks
   • a) What do you mean by function? What are different keywords ‘and parameters used for it?
   • b) How to invoke a procedure on SQL command prompt? Illustrate with example How to create, call and remove a stored procedure?
   • d) Consider table Sailors (sid, sname, city). Create a function which will count number of Sailors and display it on screen. Use PL/SQL block to execute the function
5. Q6 Attempt any Two DBMS-SQL package, @) List out Steps in order to execute dynamic creating trigger,
6. Q0 What do you mean by Trigger? Explain the DBMS-SQL package, Explain following steps to execute dynamic
   • ii) Bind column to Cursor columns Write short note on - instead of trigger
7. Q7 Attempt any Three \ How to change the structure of created table? Explain W!
   • D) Write short note on With Clause. le How PL/SQL blocks are Illustrated with examp Explain FOR UPDATE & WHERE CURRENT clause of Ct What do you mean by package? What are advantages of using p
   • f) Explain all types of trigger

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