Oracle Database Interview Question Set-7

Published by Ahmad on

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?

With Best Wishes!!!!

Cloud Architect
Oracle Database Consultant

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

YouTube Channel:



Siva · July 17, 2020 at 10:28 am

very good questions Bhai 🙂

aman · July 17, 2020 at 3:18 pm

thanks for the questions, they are definitely helpful.

aman · July 17, 2020 at 3:18 pm

Surely a helpful set of questions. Thanks Ahmad.

Sabina · July 19, 2020 at 7:19 pm

Thanks alot for sharing these questions. Kudos to your efforts! Great work!

Leave a Reply

Your email address will not be published. Required fields are marked *