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 is merge in oracle?

1002

What is a proxy class?

978

What is a proxy object?

1016

What is dynamic proxy?

967

What is proxy method?

933

What is primefaces used for?

1015

Can we insert data in view oracle?

972

Is oracle an operator?

890

What is not equal to in oracle?

956

What is set operator oracle?

930

What is where clause in oracle?

987

Which is faster join or subquery in oracle?

940

What is a lookup table in oracle?

940

How to create lov dynamically in oracle forms which is data comes from database procedure of out parameter, data will will out parameter of procedure base

1 1566

How to resolve the ORA-39133 error in Oracle?

1045

Un-Answered Questions { Oracle }

What is meant by raw datatype?

1011

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2071

What are the various types of snapshots ?

983

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1047

How can you find all the processes on your system?

529

Can a formula column be obtained through a select statement ?

2272

how to handle exceptions in post production

1366

How is clustered database important in oracle rac architecture?

What is an explain plan and how does it help in optimizing the sql query?

what are archived logs?

2152

how to dynamically change the page size of d2k reports?

What are the logical operations?

1070

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1298

What is your favorite tool for day-to-day oracle operation?

511

What is the implicit cursor in oracle?

1044

For More Un-Answered { Oracle } Questions Click Here