[askdba] Re: Need help with Interview Questions

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Fri, 5 Nov 2004 09:42:55 +0000


Comments Inline.

On Thu, 4 Nov 2004 17:52:07 -0500, Rajesh Puneyani
<rajpuneyani@xxxxxxxxx> wrote:
> Hi Guys,
> Recently I appeared in an interview for a position (after a long
> time), Here are a few questions that got me confused.
> Pls. give me your feedback regarding the same.
> 1. What are various ways to create a table in one database from
> another database ?
> I would say - Create table as select (over the database link) and
> Export/Import in Table mode.

These are the Best .. I would not go for any other method than this ... 

> Any other ?
> 2. If a table has 30 Uniform Extents (no size specified) then under
> what circumstances it is good or bad ? Basically - What is the
> advantage of 30 extents over 1 big large extents and what are the
> minuses ?

The Number of Extents do not directly Impact peformance of a Query. [A
Delete / Truncate maybe]. The Only thing u should know is that DFMBRC
does not go beyond an Extent when reading.

> 3.  What are various scenarios which make RMAN the best backup and
> recovery tool ?

The Best Thing i like abt RMAN is Block Level Backup and Block Level
Recovery. You can never do this if you dont use RMAN.

> 4.  what errors did u hit in your most recent DB Recovery procedure ?
> Actually I never had to do a DB recovery from online backup so
> far..Refreshes most of the time...But how to handle such a question ?

I would be quite truthful to them. If you have not done a recovery
than you have a very good stds in place.

> Thank you very much and Looking forward to hear from you soon.
> Regards

Other related posts: