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

Oracle RAC Interview Questions

Questions Answers Views Company eMail

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

What do we mean by hot backup & cold backup and how are they different?

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

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

How can we use tkprof?

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

How can we collect the statistics of different database objects?

What do you understand from cache fusion?

Why do we need to rebuild indexes?

What is the difference between media recovery & crash recovery?

What are the different types of backups that are available in oracle?

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

What is the difference between restoring a database and recovering a database?

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

What do you understand by redo log file mirroring?

Un-Answered Questions { Oracle RAC }

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

Mention what are the key characteristics of rac or why to use rac?

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

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

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

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

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

What is a recovery catalog?

What are the various benefits of using rac architecture?

How can we monitor the space allocations in a database?

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

What do you understand by redo log file mirroring?

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

Why is cluster verification utility so important in oracle rac?

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

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