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 single instance environment and rac environment?

What is split brain syndrome in rac?

What are the key characteristics of rac or why to use rac?

What is olr?

What are the main components of an oracle rac system?

How oracle flex asm works?

What is new feature in oracle asm 12c?

What are the file storage options provided by oracle database for oracle rac?

How can you determine what protocol is being used for interconnect traffic?

What is oracle real application clusters?

When system tablespace is created?

985

What are the database administrators utilities available?

988

What is system tablespace?

1056

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

986

How does one get the view definition of fixed views/tables?

975

Un-Answered Questions { Oracle }

What are the restrictions on external table columns?

1010

What is the usage of analyze command in oracle?

1051

If you see contention for library caches how you can fix it?

524

List out the types of joins.

1104

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2250

Explain the truncate in oracle?

923

Explain compound trigger in oracle?

993

How to call a stored function with parameters?

988

What is ADDM Advisor in Oracle?

1130

How to synchronize 2 schema's objects?

2130

How many file formats are supported to export data?

1159

What is the difference between a database and instance?

652

IS it possible to built the oracle database without setting the kernal parameters?

2293

How many anonymous blocks can be defined?

1125

How to convert characters to dates in oracle?

1045

For More Un-Answered { Oracle } Questions Click Here