Incorrect answers c there is no alter controlfile

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ers: C: There is no ALTER CONTROLFILE BACKUP command in Oracle, you can backup online control file with ALTER DATABASE BACKUP CONTROLFILE command. D: There is no ALTER DATABASE BACKUP TABLESPACE command in Oracle, you can put the tablespace in backup mode with ALTER TABLESPACE BEGIN BACKUP command, copy datafiles of the tablespace and return tablespace in normal mode with ALTER TABLESPACE END BACKUP command. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 577-583 Chapter 12: Overview of Backup and Recovery QUESTION 30: Which two actions must you take to stop automatic archiving of redo-log files? (Choose two) A. Issue the ALTER SYSTEM ARCHIVE LOG STOP ; command. B. Issue the ALTER SYSTEM SET LOG_ARCHIVE_START=FALSE; command. C. Set LOG_ARCHIVE_STOP=TRUE in the parameter file and restart the database. D. Set LOG_ARCHIVE_START=FALSE in the parameter file and restart the database. Answer: A, D Explanation: To stop automatic archiving of redo log files you need to issue the ALTER SYSTEM - The Power...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online