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 do you know about normalization? Explain in detail?

951

What are the different oracle database objects?

1091

State all possible different index configurations a table can possibly have?

998

What is the difference between translate and replace?

1060

How can we delete duplicate rows in a table?

973

What is a cursor and what are the steps need to be taken?

1202

Compare and contrast between sql and sql server and explain its various functions?

963

How different is ms access and oracle?

1037

How to display employee records who gets more salary than the average salary in the department?

1065

State some uses of redo log files?

1006

What is coalesce function?

1069

How can we view last record added to a table?

1038

What is the maximum number of triggers that can be applied to a single table?

1021

What is the usage of merge statement?

1154

Explain the difference between a procedure and a function?

1169

Un-Answered Questions { Oracle }

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2460

What do you understand by database schema and what does it hold?

1230

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2062

How to update values on multiple rows in oracle?

1034

How to do clean up if create database failed?

1027

What is the difference between single instance environment and rac environment?

What is ole automation?

How to get the Installed Oracle Version Information ?

1123

Explain the use of file option in exp command.

1129

What is a package in oracle?

1101

Difference between pre-select and pre-query

1106

How to recover a dropped table in oracle?

1047

Can sub procedure/function be called recursively?

1001

How to create an oracle testing table?

1069

How to move objects from DEV to QA and QA to PROD Environments?

710

For More Un-Answered { Oracle } Questions Click Here