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 in rac what files should be created on shared storage?

1


How can a single instance environment be converted into rac environment and how will they be different?

1


Mention how oracle flex asm works?

1


Mention what is oracle real application clusters?

1


Why is cluster verification utility so important in oracle rac?

1






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

1


Mention what is the function of cache fusion in oracle rac?

1


How would you identify the shared_pool_size parameter that needs to be adjusted?

1


Mention what is new feature in oracle asm 12c?

1


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

1


What are the key components of oracle’s maximum availability architecture?

1


What is tkprof and how can we use it?

1


What are the provisions and resources provided in the oracle’s cloud server?

1


Mention what are the benefits of oracle rac?

1


Can you list down the different components of physical and logical database structure?

1