Topic : Instance

Which is the component of an Oracle instance?


  • The SGA
  • The redo logs
  • The control cache
  • The password file

Answer :

The SGA

Show Answer Discuss

In the event of an Instance failure; which files store command data NOT written to the datafiles?


  • Control files
  • Online redo logs
  • Network segment
  • Archived redo logs

Answer :

Online redo logs

Show Answer Discuss

Where can you find the non-default parameters when an instance is started?


  • Alert log
  • Online redo log
  • Archived redo log
  • System user's trace

Answer :

Alert log

Show Answer Discuss

With the instance down; how would you recover a lost control file?


  • Restore backup control file & recover using backup controlfile
  • Use the CREATE CONTROLFILE command
  • Use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command
  • Use the ALTER DATABASE RECOVER CONTROLFILE FROM TRACE command

Answer :

Restore backup control file & recover using backup controlfile

Show Answer Discuss

Can we check number of instances running on Oracle server and how to set kernel parameters in Linux?


Answer :

- Editing the /etc/oratab file on a server gives the list of oracle instances running on your server.
- Editing /etc/sysctl.conf file with vi editor will open a text file listing out kernel level parameters.
- We can make changes to kernel paramet

Show Answer Discuss