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

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

How do you recover a lost control file?

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

What is the difference between media recovery & crash recovery?

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

Mention what is the difference between instance recovery and crash recovery?

Mention what is cluster?

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

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

What is table partitioning and why is it required?

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

What is rac?

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

What is the load balancing advisory?

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