Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 }

What is an oracle report?

1124

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1334

What are the advantages of oracle?

1078

In what script is snap$ created? In what script is the scott/tiger schema created?

2763

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2675

What is a package in oracle?

1169

What are the benefits of oracle rac?

what is semphore explian it?

2884

How to create a table in a specific tablespace?

1029

what is difference between inner join & nested query or subqueries

3115

How to convert raw data type into text in oracle? Explain

1054

What is the oracle implicit cursor?

1115

Which dba certification is best?

613

How to check database size in Oracle?

1259

Why does oracle 9i treat an empty string as null?

1132

For More Un-Answered { Oracle } Questions Click Here