网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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 cancelbased 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 readonly tablespacesCbackup of systemcritical tablespacesDbackup of online, locally managed tablespacesEbackup of read/write dictionarymanaged 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
热门标签
最新试卷