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 }

What are the components required to manage oracle real application clusters database?

1


What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

1


Mention what is the volume management techniques used in oracle rac?

1


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

1


Explain the hardware architecture used in oracle rac?

1






Mention what are the main components of an oracle rac system?

1


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

1


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

1


How can we monitor the space allocations in a database?

1


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

1


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

1


Mention what is the difference between single instance environment and rac environment?

1


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

1


What is the difference between single instance environment and rac environment?

1


What is the difference between instance recovery and crash recovery?

1