| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the difference between db2start command and start
database manager command? | | 1 |
| What are the different ways of moving data or databases
between servers and databases in SQL Server?
| | 2 |
| Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each. | | 1 |
| What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace? | | 1 |
| Give the reasoning behind using an index. | | 1 |
| Name two files used for network connection to a database. | | 4 |
| Give two examples of how you might determine the structure
of the table DEPT. | | 2 |
| What view would you use to determine free space in a tablespace? | | 2 |
| Explain CREATE DATABASE syntax? | | 1 |
| What background process refreshes materialized views? | | 1 |
| When a user process fails, what background process cleans up
after it? | | 1 |
| How do you switch from an init.ora file to a spfile? | TCS | 1 |
| Explain the difference between a hot backup and a cold
backup and the benefits associated with each? | TCS | 3 |
| Can you take Image Backups using RMAN?
. Can you use Backupsets created by RMAN with any other
utility
| | 1 |
| Should you place Recovery Catalog in the Same DB?
. Can you use RMAN without Recovery catalog
| | 2 |
| What type of index should you use on a fact table? | | 1 |
| Explain the use of setting GLOBAL_NAMES equal to TRUE. | | 1 |
| How would you determine what sessions are connected and what
resources they are waiting for? | | 2 |
| What is RAID and what are different types of RAID
configurations? | | 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? | | 1 |
| |
| For more DB Administration Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
