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

Oracle RAC Interview Questions

Questions Answers Views Company eMail

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?

How can we monitor the space allocations in a database?

How do you recover a lost control file?

What do you mean by database normalization and why is it important?

How is rman better than user-managed backup recovery process?

How is clustered index different from non-clustered index?

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

Un-Answered Questions { Oracle RAC }

Mention what is cluster?

Mention what is new feature in oracle asm 12c?

Why do we use materialized view instead of table or views?

What are the file systems and volume management techniques used in oracle rac?

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

What are the various benefits of using rac architecture?

What is the difference between media recovery & crash recovery?

What do you understand by redo log file mirroring?

Explain the oracle real application clusters architecture?

What is an explain plan and how does it help in optimizing the sql query?

What if your ocr (oracle cluster registry) is corrupted?

Mention how oracle flex asm works?

What is the function of grid naming service used in oracle rac

How oracle flex asm works?

Mention in rac what files should be created on shared storage?

For More Un-Answered { Oracle RAC } Questions Click Here