Interview Questions on Oracle PL/SQL

Below is the list of Questions related to PL/SQL. The complexity level of these questions is Easy.

1.I am having Cursor which returns 10 records.I want to display the 5th record.

2.I am having User defined Exception but I want to display error message based on default Oracle
error number using User defined Exception.

3.Write a query that have atleast 5 employees has to there in a Department.

4.Write a query to retrieve the certain range(for ex. 10 to 15 records)

5.what are the database triggers?

6.Why we go for package?

7.Give the syntax for Package Specification and Packeage Body.

8.If 10 functions and 10 procedures are there in Package Specification.But in Package body,
if there are 9 procedures and 9 functions.Whether the Package Body will work or not?

9.Can we use procedures/Functions in package body which are not in package Specification.what
will be the scope that procedures/Functions?

10.What is the use of INSTEAD OF triggers?

11.In a Function A,I have given some Update Statements on emp table.If the function A call as
Select function A from emp;What will be output?

12.what will be the output of this query?
select * from emp where 1=1;

Please share your views about this Article.For more articles visit About Oracle Apps

Related Articles to Read