Which shows if the database is in ARCHIVELOG or NOARCHIVELOG mode and – McqOptions

MCQOPTIONS

1.	Which shows if the database is in ARCHIVELOG or NOARCHIVELOG mode and if MANUAL (archiving mode) has been specified in a Dynamic performance view?
A.	V$ARCHIVED_LOG
B.	V$DATABASE
C.	V$ARCHIVE_DEST
D.	V$ARCHIEVE_PROCESSES
Answer» C. V$ARCHIVE_DEST

Discussion

No Comment Found

Related MCQs

What is a redo record called?
What indicates whether there was a problem accessing the destination in an Archive Destination Status?
Which shows if the database is in ARCHIVELOG or NOARCHIVELOG mode and if MANUAL (archiving mode) has been specified in a Dynamic performance view?
Which mode protects a database from instance failure but not from media failure?
What does the redo log for each database instance referred to as in the context of multiple database instances?
What is the minimum size permitted for a redo log file?
Which parameter is used to specify a maximum of two locations,used to specify a primary archive destination?
Which parameter is used in the CREATE DATABASE statement that determines the maximum number of groups of redo log files for each database?
Which modes are used for transmitting archived logs to their destination inthe Specifying Mode of Log Transmission?
A filled redo log file is available after the changes recorded in it have been written to the datafiles if archiving is ______.