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 }

Can a formula column be obtained through a select statement ?

2278

Can we insert data in view oracle?

977

What is a dead lock in oracle?

1060

what is the use of system.effective.date variable in oracle?

1069

What is the disk migration? what is the steps involved in oracle disk migration?

1183

How to convert character types to numeric types?

1068

What are roles in oracle?

527

Is rowid unique in oracle?

959

What is execute immediate in oracle?

967

What are the various tools? - Name a few?

What is a oracle database?

1007

Explain rename?

933

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1810

What is da in database?

500

how to pass a variable more than one values?

617

For More Un-Answered { Oracle } Questions Click Here