Topic : Database Mode

When configuring a database for ARCHIVELOG mode; you use an initialisation parameter to specify which action?


  • The size of archived log files.
  • How frequently log files will be archived.
  • That the database is in ARCHIVELOG mode.
  • To Store Archive log Files

Answer :

To Store Archive log Files

Show Answer Discuss

You are configuring a database for ARCHIVELOG mode. Which initialization parameter should you use?


  • LOG_ARCHIVE_SIZE
  • ARCHIVELOG_MODE
  • LOG_ARCHIVE_DEST

Answer :

LOG_ARCHIVE_DEST

Show Answer Discuss

Which command does a DBA use to list the current status of archiving?


  • ARCHIVE LOG LIST;
  • FROM ARCHIVE LOGS;
  • SELECT * FROM VITEREAD

Answer :

ARCHIVE LOG LIST;

Show Answer Discuss

Is it possible take consistent backup if the database is in NOARCHIVELOG mode?


  • Yes
  • No

Answer :

Yes

Show Answer Discuss

Database is in Archivelog mode and Loss of unbackedup datafile is__?


  • Complete Online Recovery
  • Incomplete Recovery
  • Complete Offline recovery

Answer :

Complete Online Recovery

Show Answer Discuss