Oracle Database Interview Question Set-23

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 the difference between exp/imp and expdp/impdp?
  2. What is the difference between delete and truncate command?
  3. What is cache fusion? Which process do cache fusion?
  4. Earlier we had a buffer option to speed up logical backup. Which option do we use now in 11g?
  5. What is the ORA-01555 error?
  6. What is a flashback and what is mandatory for a flashback?
  7. We have two database D1 and D2 and the D1 database doesn't have space so how will you take an export of D1?
  8. You are using Toad and you are running procedure and you get a TNS error what is the reason?
  9. Where is the location of the RAC CRS cluster alert log?
  10. If the undo file is corrupted what will you do?

 

 

Thanks

With Best Wishes!!!!

Ahmad
Cloud Architect
Oracle Database Consultant

Certified in-: | 1XAzure | 6XOCI | 1XOCS (GG) | 1XOCE (RAC) | 3XOCP (11g,10g,9i) | 1XOCA (9i) |

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


0 Comments

Leave a Reply

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