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 }

Differentiate between transaction type and transaction source? : oracle accounts receivable

1115

6. Display the client name and order date for all orders using the traditional method.

2305

What are a query and state the different types of queries and their uses?

1015

what are archived logs?

2199

State any two functions of oracle?

1045

If you have an example table, what is the best way to get sizing data for the production table implementation?

554

What are bind variables and why are they important?

543

What is oracle rowcount?

1084

What is the usage of analyze command in oracle?

1093

Is oracle a language?

944

What are types of data model?

551

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2472

How to sort the query output in oracle?

1028

What is raw datatype?

1136

What is the dynamic sql in oracle?

1071

For More Un-Answered { Oracle } Questions Click Here