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 the difference between media recovery & crash recovery?

What are the different types of backups that are available in oracle?

What are the different tools that are provided by oracle to assist performance monitoring?

What is the difference between restoring a database and recovering a database?

Can you list down the different components of physical and logical database structure?

What do you understand by redo log file mirroring?

What do you mean by sga and how is it different from pga?

What is a flashback query and when should it be used?

What is rac and what are the various benefits of using rac architecture?

How can we identify the resources for which the sessions are waiting?

What are the different optimizers that are used to optimize database?

What is a system tablespace and why do we need it?

What are the various benefits of using rac architecture?

How would you differentiate between cluster and grid?

What is tkprof?

Un-Answered Questions { Oracle }

How to convert the oracle reports to excel sheet from oracle?

Can sub procedure/function be called recursively?

1003

What is memo?

637

Explain the designer?

625

What is a matrix report and how many minimum groups are required to prepare the same?

1139

what's query optimization and without use of IN AND Exist can we get another way data from query

2141

What are dml statements in oracle?

1095

What is null value in oracle?

1097

What is a database table in oracle?

1022

Explain about party and customer in ar : oracle accounts receivable

1209

Is oracle dba in demand?

594

what is oracle forms?

1104

How to rename an index?

1071

What privilege is needed for a user to query tables in another schema?

973

What is the difference between bind and lexical parameter?

1079

For More Un-Answered { Oracle } Questions Click Here