1. What are the major components of an Oracle Instance?
  2. What is difference between Database and Instance?
  3. What are different stages of database startup?
  4. How does Oracle maintain read consistency?
  5. What is the difference between Oracle running in Unix/Linux and Windows environment?
  6. How is RAC different from regular instance?
  7. Can we have multiple databases in one cluster?
  8. What is a checkpoint and how frequently does it happen?
  9. What is spfile?
  10. How do you switch from an init.ora file to a spfile?

  1. What are different memory areas and their use?
  2. How do you use more than 4 GB memory in a 32-bit system?
  3. What are the pros and cons of automatic memory management?
Physical Database Design

  1. What are block size and how do you choose one?
  2. How does locally managed tablespace differ from dictionary managed tablespace?
  1. What kind of backups do you recommend for Oracle database?
  2. What is the fastest way of getting back the deleted data from an Oracle table?
  3. What can you do if you lose sys password?
  4. How do you recover a standby data guard if a tablespace gets corrupted?
  5. How do monitor a production database?
  6. How can I audit object changes in a database?
  7. How do you audit actions by a particular user?
  8. What kind of backup scheme do you recommend?
  9. How do you use one RMAN server for different versions of Oracle databases?
  10. What options do you have to restore a user tablespace?
  11. You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
  12. How do you move a Oracle database data file from one location to another?
  13. A user accidentally dropped a table, what are the options to get it back?
  14. How do you create a temporary table?
  15. What are the types of indexes available?
  16. What is a Materialized View?
  17. What is the difference between streams and change data capture?
  18. How do you determine whether a table is fragmented? How do you fix it?
  19. How do you gather statistics?
  20. After creating a new database, what are the steps you do to make a database secure?
  21. How do you monitor performance?
  22. What are the typical things you look for in a AWR or Statspack report?
  23. How do you capture queries run by an application?
  24. How do you flush buffer cache?
  25. What kinds of performance issues are typical to a RAC environment?
  26. What column differentiates the V$ views to the GV$ views and how?
Miscellaneous questions
  1. How would you go about generating an EXPLAIN plan?
  2. Explain an ORA-01555 error?
  3. Explain the use of setting GLOBAL_NAMES equal to TRUE.
  4. Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
  5. How would you determine what sessions are connected and what resources they are waiting for?
  6. How would you force a log switch?
  7. Give two methods you could use to determine what DDL changes have been made.
  8. What does coalescing a tablespace do?
  9. What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
  10. Name a tablespace automatically created when you create a database.
  11. When creating a user, what permissions must you grant to allow them to connect to the database?
  12. How do you add a data file to a tablespace?
  13. How do you resize a data file?
  14. What view would you use to look at the size of a data file?
  15. What view would you use to determine free space in a tablespace?
  16. How would you determine who has added a row to a table?
  17. How can you rebuild an index?
  18. Explain what partitioning is and what its benefit is.
  19. You have just compiled a PL/SQL package but got errors, how would you view the errors?
  20. How can you gather statistics on a table?
  21. How can you enable a trace for a session?
  22. What is the difference between the SQL*Loader and IMPORT utilities?
  23. Name two files used for network connection to a database.
9/12/2012 05:26:19 pm

please share the answers also to learn more on interview questions.please send answers through mail or post in the same wall.


Leave a Reply.


    Write something about yourself. No need to be fancy, just an overview.


    June 2012