How would you identify the shared_pool_size parameter that needs to be adjusted?
What is the difference between restoring a database and recovering a database?
Mention what is the difference between instance recovery and crash recovery?
What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?
How can a single instance environment be converted into rac environment and how will they be different?
What is the function of grid naming service used in oracle rac
What do you mean by sga and how is it different from pga?
What is required by oracle rac database to connect to a network?
Mention how can you determine what protocol is being used for interconnect traffic?
How is incremental backup different from differential backup?
What do you understand by row chaining?
What are the provisions and resources provided in the oracle’s cloud server?
How can we use tkprof?
What do you understand by redo log file mirroring?
What are the components required to manage oracle real application clusters database?