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 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?

1095

What are the database administrators utilities available?

1098

What is system tablespace?

1155

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?

1118

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

1075

Un-Answered Questions { Oracle }

Give the different types of rollback segments.

1084

How can I get column names from a table in oracle?

1108

How can I introduce multiple conditions in like operator?

1057

What is oracle d2k? Why we use it?

How to assign values to variables?

1168

What to do if the binary spfile is wrong for the default instance?

1111

Is there a function to split a string in plsql?

1109

How do I reset a sequence in oracle?

1159

How are extents allocated to a segment?

1184

What are active transformation / passive transformations?

How to define a specific record type?

1142

what is tripstop report?

1913

What are the limitations of check constraint?

1078

Does oracle charge for java?

1118

State the difference between a primary key and foreign key?

1000

For More Un-Answered { Oracle } Questions Click Here