| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| When a user process fails, what background process cleans up
after it? | | 1 |
| What is RAID and what are different types of RAID
configurations? | | 1 |
| What view would you use to look at the size of a data file? | | 2 |
| What view would you use to determine free space in a tablespace? | | 3 |
| How would you determine what sessions are connected and what
resources they are waiting for? | | 2 |
| Give two examples of referential integrity constraints. | | 1 |
| Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each. | | 3 |
| How would you determine the time zone under which a database
was operating? | | 2 |
| How to make a replica of existing oracle server to another
server?
| | 1 |
| How would you force a log switch? | | 3 |
| How can you gather statistics on a table? | | 2 |
| What does coalescing a tablespace do? | | 1 |
| How can you enable a trace for a session? | | 1 |
| How can we know the exact updation date of a particular
database? | Satyam | 1 |
| How would you go about increasing the buffer cache hit ratio? | | 1 |
| Can you take Online Backups if the the database is running
in NOARCHIVELOG mode?
5. How do you bring the database in ARCHIVELOG mode from
NOARCHIVELOG mode?
6. You cannot shutdown the database for even some minutes,
then in which mode you should run
the database?
| Wipro | 3 |
| How would you determine who has added a row to a table? | | 3 |
| What command would you use to create a backup control file? | | 1 |
| What is blocking and how would you troubleshoot it? | | 1 |
| I have my backup RMAN script called "backup_rman.sh". I am
on the target database. My catalog username/password is
rman/rman. My catalog db is called rman. How would you run
this shell script from the o/s such that it would run as a
background process? | | 1 |
| |
| For more DB Administration Interview Questions Click Here |
Site Map
