| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How can we know the exact updation date of a particular
database? | Satyam | 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 |
| Explain an ORA-01555 | | 1 |
| How many memory layers are in the shared pool? | | 2 |
| Give two methods you could use to determine what DDL changes
have been made. | | 2 |
| How can you enable a trace for a session? | | 1 |
| What view would you use to look at the size of 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 |
| Explain the difference between $ORACLE_HOME and $ORACLE_BASE. | | 2 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan? | | 1 |
| How do you switch from an init.ora file to a spfile? | TCS | 2 |
| Give the two types of tables involved in producing a star
schema and the type of data theyhold. | | 1 |
| What is blocking and how would you troubleshoot it? | | 1 |
| How would you force a log switch? | | 3 |
| Name three advisory statistics you can collect. | | 1 |
| Is it possible to run 32 bit sql server 2000 on64bit
windows platform.if how much memory is available to sql
server? | | 1 |
| 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 would you go about generating an EXPLAIN plan? | | 1 |
| what is the difference between db2start command and start
database manager command? | | 1 |
| |
| For more DB Administration Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
