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?