网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning,media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation?()
A

recover using Oracle Flashback Database technology

B

restore the data files from backup and perform a complete recovery

C

restore only the corrupted data file and perform tablespace recovery

D

restore the data files from backup and perform cancel-based recovery

E

restore the entire database from the most recent backup and start the instance and open the database


参考答案

参考解析
解析: 暂无解析
更多 “单选题Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning,media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation?()A recover using Oracle Flashback Database technologyB restore the data files from backup and perform a complete recoveryC restore only the corrupted data file and perform tablespace recoveryD restore the data files from backup and perform cancel-based recoveryE restore the entire database from the most recent backup and start the instance and open the database” 相关考题
考题 You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

考题 What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()A、 MMONB、 LGWRC、 ARCHD、 ARWRE、 COPY

考题 You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()A、Hot backupB、Online backupC、consistent backupD、incremental backupE、inconsistent backup

考题 Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?() A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs

考题 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.

考题 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

考题 Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day, 7 days a week production environment?()A、ARCHIVELOG mode.B、NOARCHIVELOG mode.C、Open database backups.D、Consistent whole backups.

考题 A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()A、 backup database allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all

考题 Which three actions are required to configure the Flashback Database?()  A、 set Flash Recovery AreaB、 enable Flashback loggingC、 create FLASHBACK tablespaceD、 start the database in the ARCHIVELOG modeE、 start the database in the NOARCHIVELOG mode

考题 单选题You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()A  Enable the flash recovery area and specify it as the archived redo log destination.B  Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C  Enable the flash recovery area but do not specify it as the archived redo log destination. D  Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.

考题 单选题For which database operation would you need the database to be in the MOUNT state()A renaming the control filesB re-creating the control filesC dropping a user in your databaseD dropping a tablespace in your databaseE configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

考题 单选题Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()A You can perform open database backups.B You can perform closed database backups.C You cannot perform schema-level logical backups.D You 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

考题 多选题Which three actions are required to configure the Flashback Database?()Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode

考题 单选题A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()A  backup database allB  backup compressed databaseC  backup as compressed backupset databaseD  backup as compressed backup database plus archivelog allE  backup as compressed backupset database plus compress archivelog all

考题 多选题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.

考题 单选题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.

考题 单选题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()A You can perform online whole database backups.B You can performofflinewhole database backups.C You cannot perform schema-level export/import operations.D You 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?()A Enable the flash recovery area and specify it as the archived redo log destination.B Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C Enable the flash recovery area but do not specify it as the archived redo log destination.D Disable 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 in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation?()A recover using Oracle Flashback Database technologyB restore the data files from backup and perform a complete recoveryC restore only the corrupted data file and perform tablespace recoveryD restore the data files from backup and perform cancel­based recoveryE restore the entire database from the most recent backup and start the instance and open the database

考题 多选题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 read­only tablespacesCbackup of system­critical tablespacesDbackup of online, locally managed tablespacesEbackup of read/write dictionary­managed tablespaces

考题 多选题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 tablespaces.BBackup of read-only tablespaces.CBackup of system-critical tablespaces.DBackup of online, locally managed tablespaces.EBackup of read/write dictionary-managed tablespaces.

考题 多选题You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.

考题 单选题When performing recover of a database in NOARCHIVELOG mode with RMAN, the target database must be in the () state to restore the control file.A OPENB IDLEC MOUNTD NOMOUNT

考题 单选题What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?()A  MMONB  LGWRC  ARCHD  ARWRE  COPY

考题 单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case? ()A Hot backupB Online backupC consistent backupD incremental backupE inconsistent backup