Oracle RAC Interview Questions
Questions Answers Views Company eMail

What do you mean by sga and how is it different from pga?

1

What is a flashback query and when should it be used?

1

What is rac and what are the various benefits of using rac architecture?

1

How can we identify the resources for which the sessions are waiting?

1

What are the different optimizers that are used to optimize database?

1

What is a system tablespace and why do we need it?

1

What are the various benefits of using rac architecture?

1

How would you differentiate between cluster and grid?

1

What is tkprof?

1

How can we monitor the space allocations in a database?

1

How do you recover a lost control file?

1

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

1

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

1

How is clustered index different from non-clustered index?

1

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

1


Post New Oracle RAC Questions

Un-Answered Questions { Oracle RAC }

Mention what is split brain syndrome in rac?

1


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

1


Mention where does the clusterware write when there is a network or storage issue?

1


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

1


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

1






What is a flashback query and when should it be used?

1


Where does the clusterware write when there is a network or storage issue?

1


What is the difference between media recovery & crash recovery?

1


What is the volume management techniques used in oracle rac?

1


What are the main components of an oracle rac system?

1


How would you differentiate between cluster and grid?

1


What is table partitioning?

1


How oracle flex asm works?

1


What is required by oracle rac database to connect to a network?

1


What are the conditions kept in mind while connecting the oracle rac with the network?

1