6.
Which view provides information on the backup status of the datafiles in the database?
- A.V$BACKUP
- B.V$BACKUP_STATUS
- C.V$BACKUP_DATAFILE
- D.V$DATAFILE_BACKUP
- E.V$TABLESPCE_BACKUP
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The V$BACKUP view provides information on the online backup status for datafiles in the database. |
7.
What will be the result of the following configuration?
Log_archive_dest_1='location=c:\oracle\arch\mydb'
Log_archive_dest_2='location=z:\oracle\arch\mydb'
Log_archive_dest_2='location=z:\oracle\arch\mydb'
- A.An error will occur during database startup because the second parameter is not valid.
- B.An error will occur during database startup since you are trying to create archived redo logs in two different locations.
- C.Archived redo logs will be created in two different locations by the ARCH process.
- D.Archived redo logs will be created in two different locations by the LGWR process.
- E.Neither parameter setting is valid, so the database will not start up.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The archived redo logs will be created in two different locations. The ARCH process is responsible for the creation of the archived redo logs. |
8.
True or false? Archived redo logs can be copied to more than one destination by Oracle.
- A.True
- B.False
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| Oracle can be configured to copy archived redo logs to up to 10 different locations. |
9.
Which of the following parameters defines the location where Oracle should create archived redo logs?
- A.LOG_ARCHIVE_1
- B.LOG_DESTINATION_1
- C.LOG_ARCHIVED_DESTINATION_1
- D.LOG_ARCHIVE_DEST_1
- E.LOG_ARCHIVE_SOURCE_1
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The correct answer is D. The LOG_ARCHIVE_DEST_1 parameter is a parameter that would be used to define the location where Oracle would create your archived redo logs. |
10.
Which is not a valid way of backing up a control file?
- A.Backing up the control file to trace
- B.Copying the existing control file of the database to the backup location during a hot backup
- C.Copying the existing control file of the database to the backup location during a cold backup
- D.Creating a backup control file
- E.Using the create controlfile command
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The correct answer is B. You would never back up the actual control file during an online database backup. |
|
|
||||||||||||||||||||||||||||
