| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Give the two types of tables involved in producing a star
schema and the type of data theyhold. | | 1 |
| Explain the difference between $ORACLE_HOME and $ORACLE_BASE. | | 2 |
| What is RAID and what are different types of RAID
configurations? | | 1 |
| Explain the difference between a hot backup and a cold
backup and the benefits associated with each? | TCS | 4 |
| Explain what partitioning is and what its benefit is. | | 2 |
| Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to each. | | 3 |
| what is the difference between off-line back up and on-line
back up in ibm db2 udb? | Zenith | 2 |
| What are the different ways of moving data or databases
between servers and databases in SQL Server?
| | 2 |
| CTS int questions:
1.Temperory tablespace corrupted,how to resolve?If you need
to recover?
2.In tablespace begin backup mode,Its possible to add the
datafile?
3.How to partition the table using Hash partioning,what
happened internally?
4.During rman backup,some files are missing Rman will
continue the backup?
5.what are the errors occurs frequently?
6.which join method is best?why?
7.how to solve deadlock errors?
please reply anyone....
regards
siva | CTS | 1 |
| Give the reasoning behind using an index. | | 2 |
| Name a tablespace automatically created when you create a
database. | | 4 |
| When a user process fails, what background process cleans up
after it? | | 1 |
| Can you take Image Backups using RMAN?
. Can you use Backupsets created by RMAN with any other
utility
| | 1 |
| Give two examples of referential integrity constraints. | | 1 |
| Compare and contrast TRUNCATE and DELETE for a table. | | 4 |
| Explain the difference between a data block, an extent and a
segment. | | 1 |
| How can we know the exact updation date of a particular
database? | Satyam | 1 |
| How would you determine who has added a row to a table? | | 3 |
| what is incremental checkpoint? | CTS | 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 |
| |
| For more DB Administration Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
