Attempt the following questions i. What is cursor? Differentiate between implicit and explicit cursor. ii. List pre-defined and users defined exceptions and discuss any one of it.
[7 marks]Attempt the following questions: i. Give usage of %type datatype in PLSQL. ii. List dictionary to view the user defined constraints. iii. Give uses of %rowtype datatype in PLSQL. iv. What is one line difference between procedure and function. v. Give any three advantages of using PLSQL. vi. List various types of triggers. vii. Give one advantage of using package.
[7 marks]Explain Cursor For loop giving example.
[7 marks]Write a PLSQL block to print multiplication table of given number.
[7 marks]Explain implicit cursor giving example.
[7 marks]What is view? Discuss its concept.
[7 marks]Discuss the concept of Decode statement giving example.
[7 marks]What is sequence? Discuss its concept giving example.
[7 marks]What is Varray? Discuss its concept giving example.
[7 marks]How function is initialized and called? Explain the concept of function giving example.
[7 marks]Assume EMP table ( empno, empnm, date_join). Write a trigger which will not allow to insert record whose name starts with uppercase.
[7 marks]Write a PLSQL function to swap two numbers.
[7 marks]Explain the concept of :OLD and :NEW qualifier in trigger giving example.
[7 marks]What is package? Explain the concept of package giving example.
[7 marks]Assume table EMP(empno, name, salary). Write a procedure which will print salary of employee which lies between 5000 to 15000.
[7 marks]Assume the STUD table ( rollno, name, marks1, marks2, marks3). Write a PLSQL procedure which will read marks of three subject and print sum in called function.
[7 marks]Explain the concept of Commit, Rollback and Savepoint.
[7 marks]