You must shut down the database instance to perform the backups.
You must configure the Flash Recovery Area (FRA) for the database.
You can perform complete database backups without closing the database.
All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
第1题:
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
第2题:
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
第3题:
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process,you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?()
第4题:
You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups. Identify two prerequisites to perform the backups.()
第5题:
You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task()
第6题:
The database must have multiplexed redo log files
The database must be in the MOUNT state to execute the command
The database must be in the NOMOUNT state to execute the command
The database must be opened in RESTRICTED mode before this operation
The database must be opened with the RESETLOGS option after the flashback operation
第7题:
The source database backup must be copied over the net for test database.
The source database must be run in ARCHIVELOG mode if the database is open.
The source database must be shut down cleanly if the database is in mounted state.
A net service name should be set up and a listener configured with the target as well as the source database.
第8题:
Multiplex all database files
Configure the Flash Recovery Area.
Configure the database instance for ARCHIVELOG mode.
Configure the FAST_START_MTTR_TARGET initialization parameter.
第9题:
The instance aborts.
The database cannot be recovered.
The database can be recovered by restoring the control files from the backup.
The database remains opened and you have to shut it down with the ABORT option.
The database can be restored till the point of the last closed whole database backup.
第10题:
It must be executed from the Oracle Database 11g environment.
It must be executed only after the SYSAUX tablespace has been created.
It must be executed from the environment of the database that is being upgraded.
It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
第11题:
The database must be opened in restricted mode.
The database must be configured to run in ARCHIVELOG mode.
The tablespaces are required to be in backup mode before taking the backup.
The tablespaces are required to be in read-only mode before taking the backup
第12题:
The database must have multiplexed redo logs for the flashback to succeed.
The database must be MOUNTED for the flashback to succeed.
The database must use block change tracking for the flashback to succeed.
The database must be opened in restricted mode for the flashback to succeed.
The database must be opened with the RESETLOGS option after the flashback is complete.
The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
第13题:
Which two statements are true regarding the database in ARCHIVELOG mode?()
第14题:
You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)()
第15题:
You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario()
第16题:
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task()
第17题:
You must shut down the database instance to perform the backups.
You must configure the Flash Recovery Area (FRA) for the database.
You can perform complete database backups without closing the database.
All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
第18题:
The database must be opened in restricted mode.
The database must be configured to run in ARCHIVELOG mode.
The tablespaces are required to be in backup mode before taking the backup.
The tablespaces are required to be in read-only mode before taking the backup
第19题:
You must shut down the database instance to perform the backups.
You must configure the Flash Recovery Area (FRA) for the database.
You can perform complete database backups without closing the database.
All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
第20题:
You must have started the database instance in restricted mode.
You must have started the database instance inNORMALmode.
You must have started the database instance with server parameter file.
You must have started the database instance but must not have mounted.
You must have started the database instance but must not have opened.
第21题:
Multiplex all database files.
Configure the Flash Recovery Area.
Configure the database instance for ARCHIVELOG mode.
Configure the FAST_START_MTTR_TARGET initialization parameter
第22题:
SYSDATE should not be used with TIMESTAMP.
The database must have multiplexed redo log files.
The database must be in the MOUNT state to execute the command.
The database must be opened with the RESETLOGS option after the flashback operation.
The entire database needs to be restored from the most recent backup before the flashback operation.
第23题:
You have to shut down the database to perform the backups.
Archiving information is written to the data files and redo log files.
You can perform complete database backups without closing the database.
Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
第24题:
The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
ASM compatibility controls which features for the ASM will be enabled.