| Other DB Administration Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How do you find out from the RMAN catalog if a particular
archive log has been backed-up? | | 2 |
| How do you resize a data file? | | 2 |
| Explain the difference between a data block, an extent and a
segment. | | 1 |
| How would you force a log switch? | | 3 |
| When creating a user, what permissions must you grant to
allow them to connect to the database? | | 2 |
| Give the reasoning behind using an index. | | 2 |
| What is RAID and what are different types of RAID
configurations? | | 1 |
| Compare and contrast TRUNCATE and DELETE for a table. | | 4 |
| What view would you use to look at the size of a data file? | | 2 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan? | | 1 |
| Explain the difference between a hot backup and a cold
backup and the benefits associated with each? | TCS | 4 |
| Give the two types of tables involved in producing a star
schema and the type of data theyhold. | | 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 to make a replica of existing oracle server to another
server?
| | 1 |
| How can you gather statistics on a table? | | 2 |
| Name a tablespace automatically created when you create a
database. | | 4 |
| How would you go about generating an EXPLAIN plan? | | 1 |
| You have just compiled a PL/SQL package but got errors, how
would you view the errors? | | 3 |
| What does coalescing a tablespace do? | | 1 |
| What column differentiates the V$ views to the GV$ views and
how? | | 1 |
| |
| For more DB Administration Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
