| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| what is the difference between db2start command and start
database manager command? | | 1 |
| Name a tablespace automatically created when you create a
database. | | 4 |
| How would you determine who has added a row to a table? | | 3 |
| Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each. | | 3 |
| 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 |
| How do you add a data file to a tablespace? | | 1 |
| Compare and contrast TRUNCATE and DELETE for a table. | | 4 |
| How would you go about increasing the buffer cache hit ratio? | | 1 |
| what is ora 600? | | 1 |
| How can we know the exact updation date of a particular
database? | Satyam | 1 |
| what is incremental checkpoint? | CTS | 1 |
| How can you enable a trace for a session? | | 1 |
| When a user process fails, what background process cleans up
after it? | | 1 |
| How do you resize a data file? | | 2 |
| What type of index should you use on a fact table? | | 1 |
| Explain the difference between a hot backup and a cold
backup and the benefits associated with each? | TCS | 4 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan? | | 1 |
| What are the different ways of moving data or databases
between servers and databases in SQL Server?
| | 2 |
| |
| For more DB Administration Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
