Sir,pls send me some more oftanily asked oracle interview questions iam an one year exprience person...i need one year oracle interview questions.....

Showing Answers 1 - 7 of 7 Answers

questions.

1 what is cursor, exception

2.  diffrent type of cursor

3. diffrence of implicit/explicit cursor

4.what is  exception

5 name any 5 exception

6. what alone raise will do

7. how to create index

8 what are the difffrent type of index

more you can take a book and try to create question your own per chapter.

  Was this answer useful?  Yes

Reks

  • Jan 10th, 2007
 

Questions like:

what is the advantage and disadvantage of packages

what is the use of cursors

What are the exceptiions found in select query

how to select duplicate rows,odd number of rows

how do we use decode and case statement

what ia a mutating trigger

what is a sequence and synonym

how many types of views

what are collections

  Was this answer useful?  Yes

Radha

  • Jul 14th, 2011
 

Questions Like:
Difference between Delete and Truncate
Difference between Sub query and Correlated sub query
Difference between Decode and Case
Different Types of constraints
Difference between Primary Key and Unique Key
Types of Index
Types of View
Types of Pseudo columns
What do u mean by exception and its types
Advantages of PL/SQL when compare to SQL
Types of triggers
Types of cursors
Difference Between Procedure and Function
These are frequently asked question in interview

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions