- What are the major components of an Oracle Instance?
- What is difference between Database and Instance?
- What are different stages of database startup?
- How does Oracle maintain read consistency?
- What is the difference between Oracle running in Unix/Linux and Windows environment?
- How is RAC different from regular instance?
- Can we have multiple databases in one cluster?
- What is a checkpoint and how frequently does it happen?
- What is spfile?
- How do you switch from an init.ora file to a spfile?
- What are different memory areas and their use?
- How do you use more than 4 GB memory in a 32-bit system?
- What are the pros and cons of automatic memory management?
- What are block size and how do you choose one?
- How does locally managed tablespace differ from dictionary managed tablespace?
- What kind of backups do you recommend for Oracle database?
- What is the fastest way of getting back the deleted data from an Oracle table?
- What can you do if you lose sys password?
- How do you recover a standby data guard if a tablespace gets corrupted?
- How do monitor a production database?
- How can I audit object changes in a database?
- How do you audit actions by a particular user?
- What kind of backup scheme do you recommend?
- How do you use one RMAN server for different versions of Oracle databases?
- What options do you have to restore a user tablespace?
- You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
- How do you move a Oracle database data file from one location to another?
- A user accidentally dropped a table, what are the options to get it back?
- How do you create a temporary table?
- What are the types of indexes available?
- What is a Materialized View?
- What is the difference between streams and change data capture?
- How do you determine whether a table is fragmented? How do you fix it?
- How do you gather statistics?
- After creating a new database, what are the steps you do to make a database secure?
- How do you monitor performance?
- What are the typical things you look for in a AWR or Statspack report?
- How do you capture queries run by an application?
- How do you flush buffer cache?
- What kinds of performance issues are typical to a RAC environment?
- What column differentiates the V$ views to the GV$ views and how?
- How would you go about generating an EXPLAIN plan?
- Explain an ORA-01555 error?
- Explain the use of setting GLOBAL_NAMES equal to TRUE.
- Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
- How would you determine what sessions are connected and what resources they are waiting for?
- How would you force a log switch?
- Give two methods you could use to determine what DDL changes have been made.
- What does coalescing a tablespace do?
- What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
- Name a tablespace automatically created when you create a database.
- When creating a user, what permissions must you grant to allow them to connect to the database?
- How do you add a data file to a tablespace?
- How do you resize a data file?
- What view would you use to look at the size of a data file?
- What view would you use to determine free space in a tablespace?
- How would you determine who has added a row to a table?
- How can you rebuild an index?
- Explain what partitioning is and what its benefit is.
- You have just compiled a PL/SQL package but got errors, how would you view the errors?
- How can you gather statistics on a table?
- How can you enable a trace for a session?
- What is the difference between the SQL*Loader and IMPORT utilities?
- Name two files used for network connection to a database.