Oracle Database Interview Question Set-6

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 Dynamic Sampling?
  2. What is the purpose of kernel parameters?
  3. What are diff b/w exp/imp and data pump?
  4. What is partitioning? & on what basis you will do the partitioning?
  5. Which parameters affect the performance of dB?
  6. How to increase the restore speed in database recovery?
  7. How to restore crashed undo?
  8. Why the data pump is fast?
  9. What is oracle restart?
  10. If the user has dropped the table, how will u recover 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:


Indira · July 17, 2020 at 7:06 pm

Thanks Mr. Ahmad they are very helpful

Indira · July 17, 2020 at 7:11 pm

Thanks Mr. Ahmad for sharing the questions. They are very useful.

Leave a Reply

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