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

What is rac?

Explain the oracle grid infrastructure?

What do you understand by row chaining?

What is the function of cache fusion in oracle rac?

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

Why is cluster verification utility so important in oracle rac?

What are the different tools that are provided by oracle to assist performance monitoring?

How is clustered index different from non-clustered index?

What is olr?

What is the difference between instance recovery and crash recovery?

What are the various benefits of using rac architecture?

What are the benefits of oracle real application clusters (rac)?

What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?

Explain the hardware architecture used in oracle rac?

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