1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Easy Interview Questions on Oracle SQL PL/SQL

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;

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy