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

题目内容 (请给出正确答案)
单选题
Management has decided that the database must be available 24 hours a day, 7 days a week. Given this requirement, which type of backup is required?()
A

user-managed backups.

B

partial database backups.

C

consistent database backups.

D

inconsistent database backups.


参考答案

参考解析
解析: 暂无解析
更多 “单选题Management has decided that the database must be available 24 hours a day, 7 days a week. Given this requirement, which type of backup is required?()A user-managed backups.B partial database backups.C consistent database backups.D inconsistent database backups.” 相关考题
考题 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.)() A. The database must be opened in restricted mode.B. The database must be configured to run in ARCHIVELOG mode.C. The tablespaces are required to be in backup mode before taking the backup.D. The tablespaces are required to be in read-only mode before taking the backup

考题 You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?()A、You must have change tracking enabled in your databaseB、Your database must be running in NOARCHIVELOG modeC、To back up a tablespace, it must be in backup modeD、To back up a tablespace, it must first be taken offline

考题 Management has decided that the database must be available 24 hours a day, 7 days a week. Given this requirement, which type of backup is required?()A、user-managed backups.B、partial database backups.C、consistent database backups.D、inconsistent database backups.

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

考题 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.)()A、The database must be opened in restricted mode.B、The database must be configured to run in ARCHIVELOG mode.C、The tablespaces are required to be in backup mode before taking the backup.D、The tablespaces are required to be in read-only mode before taking the backup

考题 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 are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement in this scenario is true?()A、The database crashes.B、The DBA needs to re-create the file.C、The file gets re-created automatically.D、The file gets restored automatically from the last backup.E、The DBA needs to perform a complete database recovery.F、The DBA needs to perform an incomplete database recovery.

考题 You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups()A、You can perform consistent backups only.B、You can perform a complete database backup without shutting down the database instance.C、You can back up data files only when all data files have the same SCN recorded in the control file.D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

考题 Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode()A、The backup will consist of used data blocks only.B、The database must be shut down to accomplish the backup.C、The backup can be accomplished without shutting down the database.D、The backup will contain all database files that have never been backed up.

考题 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.()A、The database must be opened in restricted mode.B、The database must be configured to run in ARCHIVELOG mode.C、The tablespaces are required to be in backup mode before taking the backup.D、The tablespaces are required to be in read-only mode before taking the backup

考题 Identify two situations in which you can use Data Recovery Advisor for recovery.() A、 The user has dropped an important table that needs to be recovered.B、 The database files are corrupted when the database is open.C、 You are not able to start up the database instance because the required database files are missing.D、 The archived log files are missing for which backup is not available.

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

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

考题 Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery?()A、Online backups.B、Skipping unused block. C、Partial database backups.D、Incremental block-level backup.E、Detection of corrupted blocks during backup.

考题 Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)A、The user has dropped an important table that needs to be recovered.B、The database files are corrupted when the database is open.C、You are not able to start up the database instance because the required database files are missing.D、The archived log files are missing for which backup is not available.

考题 Which of the following shut down options should not be used before performing a consistent whole database backup?()A、NORMALB、TRANSACTIONALC、ABORTD、IMMEDIATEE、INCONSISTENT

考题 To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?()A、The database will open, and the tablespace automatically comes out of the backup modeB、The database will be mounted, and recovery must be performed on the USERS tablespace.C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

考题 多选题You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()AYou can perform consistent backups only.BYou can perform a complete database backup without shutting down the database instance.CYou can back up data files only when all data files have the same SCN recorded in the control file.DYou can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands

考题 多选题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?()AARCHIVELOG mode.BNOARCHIVELOG mode.COpen database backups.DConsistent whole backups.

考题 单选题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:   SQL ALTER TABLESPACE users BEGIN BACKUP;   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace?()A  The database will open,and the tablespace automatically comes out of the backup mode.B  The database will be mounted,and recovery must be performed on the USERS tablespace.C  The database will be mounted,and data files in the USERS tablespace must be taken out of the backup mode.D  The database will not be mounted,and you must restore all the data files for the USERS tablespace from the backup,and perform recovery.

考题 单选题The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()A until SCNB until timeC until cancelD using backup control file

考题 单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?()A You must have change tracking enabled in your databaseB Your database must be running in NOARCHIVELOG modeC To back up a tablespace, it must be in backup modeD To back up a tablespace, it must first be taken offline

考题 单选题Which command would you use to determine what database backups are currently available for restore?()A list database backupB report database backup  C list backup of databaseD list summary backupE report backup of database

考题 单选题You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement in this scenario is true?()A The database crashes.B The DBA needs to re-create the file.C The file gets re-created automatically.D The file gets restored automatically from the last backup.E The DBA needs to perform a complete database recovery.F The DBA needs to perform an incomplete database recovery.

考题 单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode()A The backup will consist of used data blocks only.B The database must be shut down to accomplish the backup.C The backup can be accomplished without shutting down the database.D The backup will contain all database files that have never been backed up.

考题 单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode()A The backup will consist of used data blocks only.B The database must be shut down to accomplish the backup.C The backup can be accomplished without shutting down the database.D The backup will contain all database files that have never been backed up

考题 多选题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.()AThe database must be opened in restricted mode.BThe database must be configured to run in ARCHIVELOG mode.CThe tablespaces are required to be in backup mode before taking the backup.DThe tablespaces are required to be in read-only mode before taking the backup