单选题The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A Enable flashback logging.B Start the database in the ARCHIVELOG mode.C Issue the ALTER DATABASE FLASHBACK ON； command.D Set the FAST_START_MTTR_TARGET initialization parameter.
单选题
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）
A
Enable flashback logging.
B
Start the database in the ARCHIVELOG mode.
C
Issue the ALTER DATABASE FLASHBACK ON； command.
D
Set the FAST_START_MTTR_TARGET initialization parameter.
参考解析
解析：
暂无解析
相关考题：
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
In order to perform Flashback Transaction Query operations， which of these steps are required？（）A、 Ensure that database is running with version 10.1 compatibility.B、 Enable Flashback Logging.C、 Enable Supplemental Logging.D、 Ensure that the database is running with version 10.0 compatibility.E、 Ensure that the database is in ARCHIVELOG mode.
Which view will you use to view information regarding the jobs that are currently running in a database？（）A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A、 Enable flashback logging.B、 Start the database in the ARCHIVELOG mode.C、 Issue the ALTER DATABASE FLASHBACK ON； command.D、 Set the FAST_START_MTTR_TARGET initialization parameter.
You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）A、The backups would be consistent.B、The backups would be inconsistent.C、The backups would be possible only if the database is running in ARCHIVELOG mode.D、The backups would be possible only if the database is running in NOARCHIVELOG mode.E、The backups need to be restored and the database has to be recovered in case of a media failure
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）A、adding a new user to the databaseB、dropping a user from the databaseC、dropping a table from the databaseD、dropping a data file from a tablespaceE、adding a new tablespace to the database
you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）A、 TrueB、 False
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A、 The queries that are currently executing will abort and an error message will be returned to the user.B、 The queries that are currently executing will execute normally but future queries will not executed.C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D、 The currently executing and future queries will execute normally， but will be slower
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.
多选题In order to perform Flashback Transaction Query operations， which of these steps are required？（）AEnsure that database is running with version 10.1 compatibility.BEnable Flashback Logging.CEnable Supplemental Logging.DEnsure that the database is running with version 10.0 compatibility.EEnsure that the database is in ARCHIVELOG mode.
单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A The queries that are currently executing will abort and an error message will be returned to the user.B The queries that are currently executing will execute normally but future queries will not executed.C Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D The currently executing and future queries will execute normally， but will be slower
单选题Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）AYou can perform open database backups.BYou can perform closed database backups.CYou cannot perform schema-level logical backups.DYou can perform the backup of only the SYSTEM tablespace when the database is open.
多选题Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）Aadding a new user to the databaseBdropping a user from the databaseCdropping a table from the databaseDdropping a data file from a tablespaceEadding a new tablespace to the database
多选题You are managing an Oracle Database 11g database. The database is open， and you plan to performRecovery Manager （RMAN） backups. Which three statements are true about these backups（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure.
多选题Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）AThe destination must be global only.BA maximum of five destinations can be assigned.CA maximum of ten different destinations can be assigned.DAll the destinations are determined by the server automatically.EThe destination may be local or remote for a Standby Database.FThe destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）AYou can perform online whole database backups.BYou can performofflinewhole database backups.CYou cannot perform schema-level export/import operations.DYou can perform the backup of only the SYSTEM tablespace when the database is open.
单选题You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）AEnable the flash recovery area and specify it as the archived redo log destination.BDisable the flash recovery area and start the database instance in ARCHIVELOG mode.CEnable the flash recovery area but do not specify it as the archived redo log destination.DDisable the flash recovery area and start the database instance in NOARCHIVELOG mode.
单选题you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）A TrueB False
多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）Abackup of offline tablespacesBbackup of readonly tablespacesCbackup of systemcritical tablespacesDbackup of online， locally managed tablespacesEbackup of read/write dictionarymanaged tablespaces
单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）AConfigure Java Pool to cache the java objects.BConfigure Streams Pool to enable parallel processing.CIncrease Shared Pool size to cache more PL/SQL objects.DIncrease Database Buffer Cache size to increase cache hits.EConfigure Large Pool to be used by RMAN and shared server.FIncrease the total System Global Area （SGA） size to increase memory hits.
单选题You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）AConfigure Java Pool to cache the java objects.BConfigure Streams Pool to enable parallel processing.CIncrease Shared Pool size to cache more PL/SQL objects.DIncrease Database Buffer Cache size to increase cache hits.EConfigure Large Pool to be used by RMAN and shared server.FIncrease the total System Global Area （SGA） size to increase memory hits.
单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）AAllow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesBShut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSCAllow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileDAllow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
多选题You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups. Which three statements are true about these backups（）AThe backups would be consistent.BThe backups would be inconsistent.CThe backups would be possible only if the database is running in ARCHIVELOG mode.DThe backups would be possible only if the database is running in NOARCHIVELOG mode.EThe backups need to be restored and the database has to be recovered in case of a media failure
单选题Which view will you use to view information regarding the jobs that are currently running in a database？（）ADBA_SCHEDULER_RUNNING_JOBSBDBA_SCHEDULER_JOB_RUN_DETAILSCDBA_SCHEDULER_JOBSDDBA_SCHEDULER_JOB_LOG
多选题Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）AThe instance aborts.BThe database cannot be recovered.CThe database can be recovered by restoring the control files from the backup.DThe database remains opened and you have to shut it down with the ABORT option.EThe database can be restored till the point of the last closed whole database backup.
多选题The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）ARestore the data file and perform incomplete recovery.BRestore the data file and perform point-in-time recover.CDrop the tablespace and lose all data in the tablespace.DRestore the database and lose all data since the last backup.