| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Should you place Recovery Catalog in the Same DB?
. Can you use RMAN without Recovery catalog
| | 4 |
| How do you add a data file to a tablespace? | | 1 |
| Explain what partitioning is and what its benefit is. | | 2 |
| Give two methods you could use to determine what DDL changes
have been made. | | 2 |
| what is the difference between off-line back up and on-line
back up in ibm db2 udb? | Zenith | 2 |
| Give the reasoning behind using an index. | | 2 |
| How would you determine what sessions are connected and what
resources they are waiting for? | | 2 |
| How do you find out from the RMAN catalog if a particular
archive log has been backed-up? | | 2 |
| Explain an ORA-01555 | | 1 |
| What is the difference between the SQL Loader and IMPORT
utilities? | | 2 |
| How would you go about generating an EXPLAIN plan? | | 1 |
| Name a tablespace automatically created when you create a
database. | | 4 |
| What is RAID and what are different types of RAID
configurations? | | 1 |
| What column differentiates the V$ views to the GV$ views and
how? | | 1 |
| What view would you use to look at the size of a data file? | | 2 |
| Can you take Image Backups using RMAN?
. Can you use Backupsets created by RMAN with any other
utility
| | 1 |
| When a user process fails, what background process cleans up
after it? | | 1 |
| How to make a replica of existing oracle server to another
server?
| | 1 |
| what is ora 600? | | 1 |
| You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database? | | 2 |
| |
| For more DB Administration Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
