Please find below what I think is the answers to the listed and correct me
wherever possible;

User complains that he is unable to connect to database. What are your
reactions?

ans>>
I will check the listener.ora, tnsname.ora, sqlnet.ora whether they provide
contain correct connection information.

What are the differences between listener.ora, tnsname.ora, sqlnet.ora?

Ans>>
a. Listener.ora - used to connect the user to the oracle server
b. tnsnames.ora - used to configure net service names
c. sqlnet.ora - controls the behavior of oracle net services

Have got any experience with Oracle RAC?

Ans>>
No Sir

How about Streams?

Ans>>
No Sir

What are the additional processes does RAC have?

Ans>>
No idea

Explain me briefly the steps involved in taking Hotbackups?

Ans>>
1. Run your database in archivelog mode
2. Enable automatic archiving of redo logs
3. To backup an online tablespace you need to take it offline
4. Database cannot be shutdown even for some seconds

What is a Coldback and how you take it?

Ans>>
Offline back that is taken while the database is shutdown completely.

During a Hotbackup, system crashes? What do you do to bring it up?

Ans>>
You recover it to a point in time using Backup + Archived redo log files

User complains of slow response, what is your methodology to resolve the
issue?

Ans>>
I will check for sufficient space in the tablespaces

What are the advantages of RMAN over conventional backups?

Ans>>
1. Has the features to write scripts to automate backups
2. It can be used to backup only changed blocks in the database

How do you clone/duplicate a database using RMAN?

Ans>>
You use recovery manager catalog.

What are the contents of listener.ora?

Ans>>
1. Name of Listner
2. Port name
3. Protocol name
4. Instance and hostname

What are the differences between 9i and 10g versions?

Ans>>
10G has some new features that are not found in Oracle9i


Regards,

Gordon



Oracle LazyDBA home page