Alter system switch logfile command forces a log

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: E command forces a log switch and causes a checkpoint to occur. Incorrect Answers: A: There is no ALTER SYSTEM CHECKPOINT command in Oracle. C: There is no ALTER DATABASE CHECKPOINT command in Oracle. D: There is no ALTER DATABASE SWITCH LOGFILE command in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 328-330 Chapter 7: Managing the Physical Database Structure QUESTION 86: Which two dynamic performance views could you query to display the number of online redo log groups and the current log groups? (Choose two) A. V$LOG B. V$THREAD C. V$SESSION D. V$ARCHIVE E. V$INSTANCE Answer: A, B Explanation: Answers A and B are correct. V$LOG view gives comprehensive information about the current status of the redo log. V$THREAD view provides information about the number of online redo log groups. Incorrect Answers: C: V$SESSION dictionary view contains information about every session currently connected to Oracle. D: There is no V$ARCHIVE view in Oracle. E: V$INSTANCE shows inform...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online