Oracle Database Interview Question Set-13

My DBA Community,

My today’s post is very important for those who are looking for a job and preparing for an Interview. I am writing Oracle Database interview questions.

I hope these IQ will help you.

1. How to run and read the execution plan?

2. In the case of OS patch what will be your task as a dba?

3. Difference between physical and logical standby?

4. What is the Functionality of the dg broker?

5. How do u monitor databases on a daily basis?

6. What is automatic memory management?

7. How to rename a datafile?

8. If I set memory_max_target to 8gb and want to set memory_target to 10gb. How can I do it?

9. If you have 10GB memory for your instance from which 4GB is allocated to SGA. Now I have made 20GB memory available for your instance and want to change SGA size to 8GB. How can you do it? Will there be any limitations to do this?

10. How to check free space in ASM disk?

Thanks