Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What does the no logging option do? Why would we use it? Why would we be careful of using it?

547

How do I call oracle stored procedures that take no parameters?

1100

How do I learn what codesets are available in oracle?

1035

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1042

How do I limit the number of oracle database connections generated by weblogic server?

1061

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1080

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1070

Why does for update in oracle 8 cause an ora-01002 error?

996

How to find the duplicate rows count from employees table in oracle?

1078

Explain implicit cursor.

1015

Explain mutating triggers.

1023

Give the different types of rollback segments.

1026

How can you use check constraints for self referential integrity?

962

How many types of database triggers exist?

1125

Give the various exception types.

988

Un-Answered Questions { Oracle }

How to call a stored function in oracle?

1015

Hi Can any one tell me what are the API's used in requisition import.

1917

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2128

When system tablespace is created?

1032

How to fetch the row which has the max value for a column?

995

What is a snapshot log?

998

Write a syntax for update query in oracle?

1024

What is the difference between postgresql and oracle?

1037

can u plz provide me oca sql dumps please i need them

1942

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2135

How to check your oracle database 10g xe installation?

983

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

600

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2180

What are the oracle differences between nvl and coalesce

1143

can we use lexical perameter in oracle plsql if yes how

2308

For More Un-Answered { Oracle } Questions Click Here