| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain the difference between a hot backup and a cold
backup and the benefits associated with each? | TCS | 4 |
| 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. | | 3 |
| What is RAID and what are different types of RAID
configurations? | | 1 |
| Compare and contrast TRUNCATE and DELETE for a table. | | 4 |
| what is ora 600? | | 1 |
| what is incremental checkpoint? | CTS | 1 |
| Give two methods you could use to determine what DDL changes
have been made. | | 2 |
| hi, how can i check all backups are exist to restore? I.e.
i forget to take backup on one day. But now i want to check
that all backups are there to restore now. I know the
answer of through timestamps we know how to check. But i
need any other way? | | 1 |
| How to determine the service pack currently installed on
SQL Server? | | 1 |
| How would you go about increasing the buffer cache hit ratio? | | 1 |
| Explain an ORA-01555 | | 1 |
| How do you add a data file to a tablespace? | | 1 |
| When a user process fails, what background process cleans up
after it? | | 1 |
| Is it possible to run 32 bit sql server 2000 on64bit
windows platform.if how much memory is available to sql
server? | | 1 |
| Can you take Image Backups using RMAN?
. Can you use Backupsets created by RMAN with any other
utility
| | 1 |
| Explain the difference between a data block, an extent and a
segment. | | 1 |
| Explain the use of setting GLOBAL_NAMES equal to TRUE. | | 1 |
| How do you switch from an init.ora file to a spfile? | TCS | 2 |
| Should you place Recovery Catalog in the Same DB?
. Can you use RMAN without Recovery catalog
| | 4 |
| |
| For more DB Administration Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
