Oracle Database Discussions

Dear All,

I want to discuss some interview questions.

1) I am going to take RMAN backup in tabe drive. How can validate my backup is correct?

2) what is the new backend process included in Oracle 10g

3) One Development Server is on Hot Backup mode. One more Production server is also available it is a replication of Development Server. A user has dropped one table by mistakely. No Down time to be occur for this recover process. How can recover the table.?

4) Database Server has crashed. After can able to startup the database in mount mode. When we try to open that database no results, as well as no error message also appeared. How can we fix it?

5) One Tablespaces has two datafiles. Two datafiles are online. Now one datafile should be set as Begin Backup mode. How we do that?

6) ASM and Storage Architecture.

7) One Development Server and Production Server is running. In Production server, A query gets executes in 5 Minutes. At the same that query get executes in 5 Seconds. Why it gets long time in Production Server?

8) Oracle 9i RMAN and Oracle 10g RMAN Major Differences

Please give your answers for above questions, That will helpful for me and other peoples who are prepared for interview.


Thanks in advance,

Moorthy.GS