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?

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


2 Comments

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 to Wasim Sayed Cancel reply

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