Oracle Database Interview Question Set-7

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. What is SQL BaseLine?

2. What are the two source attributes for SQL Base Line?

3. How to Create a SQL Base Line?

4. In one Table Index is there but Optimizer is not using index what will be the reason?

5. What are Deadlocks? How it will be resolved?

6. One user A Started a Transaction after that user B started the transaction on the same row in that table. So Deadlock occurs. Which user Transaction will rollback? DBA will rollback or it happens automatically?

7. What are the Locks? Tell me the name Object Type of Lock?

8. If user Fire Select query Statement so Lock will happen or not?

9. When the user fires the Select statement than in backend how it will execute?

10. What is the SQL patch? Why did we use it?

Thanks
With Best Wishes!!!!

Ahmad
Cloud Architect
Oracle Database Consultant

Certified in-: | 6X OCI|OCS (ADB)|OCS (GG)|OCE (RAC)|OCP (11g,10g,9i) |OCA (9i) |

YouTube Channel: https://www.youtube.com/c/OracleRide