| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to determine the service pack currently installed on
SQL Server? | | 1 |
| How do you resize a data file? | | 2 |
| Give the reasoning behind using an index. | | 2 |
| How do you switch from an init.ora file to a spfile? | TCS | 2 |
| Explain an ORA-01555 | | 1 |
| what is the difference between db2start command and start
database manager command? | | 1 |
| What type of index should you use on a fact table? | | 1 |
| Give two methods you could use to determine what DDL changes
have been made. | | 2 |
| What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace? | | 1 |
| Which types of backups you can take in Oracle?
2. A database is running in NOARCHIVELOG mode then which
type of backups you can take?
3. Can you take partial backups if the Database is running
in NOARCHIVELOG mode?
4. Can you take Online Backups if the the database is
running in NOARCHIVELOG mode?
| | 5 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan? | | 1 |
| You have just compiled a PL/SQL package but got errors, how
would you view the errors? | | 3 |
| Give the two types of tables involved in producing a star
schema and the type of data theyhold. | | 1 |
| How to start SQL Server in minimal configuration mode? | | 1 |
| How would you go about generating an EXPLAIN plan? | | 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 |
| what is incremental checkpoint? | CTS | 1 |
| Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each. | | 3 |
| Give two examples of how you might determine the structure
of the table DEPT. | | 2 |
| What does coalescing a tablespace do? | | 1 |
| |
| For more DB Administration Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
