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

题目内容 (请给出正确答案)
单选题
You work as a database administrator for Supportcenter.cn. 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 backup

B

Online backup

C

consistent backup

D

incremental backup

E

inconsistent backup


参考答案

参考解析
解析: 暂无解析
更多 “单选题You work as a database administrator for Supportcenter.cn. 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 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.

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

考题 You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online, read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online, read/write data files when the database is in the NOMOUNT state.

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

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

考题 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?()A、 Backup of offline tablespaces.B、 Backup of read-only tablespaces.C、 Backup of system-critical tablespaces.D、 Backup of online, locally managed tablespaces.E、 Backup 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?()A、backup of offline tablespacesB、backup of read­only tablespacesC、backup of system­critical tablespacesD、backup of online, locally managed tablespacesE、backup of read/write dictionary­managed tablespaces

考题 Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()  A、 Put the database in hot backup mode and perform an online backup,including backing up the  archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress, back them up individually,and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing,you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

考题 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 NOARCHIVELOG mode and the tablespace is online.C、 The database is in NOARCHIVELOG mode and the tablespace is offline.D、 The database is in ARCHIVELOG mode and the tablespace is offline.E、 The database is in ARCHIVELOG mode and the tablespace is online.

考题 You work as a database administrator for Supportcenter.cn. 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 maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A、 redo log filesB、 password fileC、 control fileD、 change tracking file

考题 Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?()  A、 Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.C、 Oracle will generate an error when trying to open the database,indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D、 The database will open with the file in hot backup mode. You can restart the backup at any time.E、 The datafile in hot backup mode will be corrupted and you will have to recover it.

考题 You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent. Which type of backup should you perform?()A、standard backup setB、image copyC、compressed backupD、user-managed backup

考题 You want to perform a backup of your database to tape. Which backup format can you use?()A、backup set onlyB、image copy onlyC、only user-managed backupD、both image copy and backup setE、only incremental image copy backup

考题 单选题Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?()A  Oracle will automatically take the datafile out of hot backup mode,generate a warning message,and then open the database.B  Oracle will automatically take the datafile out of hot backup mode and then open the database.C  Oracle will generate an error when trying to open the database,indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.D  The database will open with the file in hot backup mode. You can restart the backup at any time.E  The datafile in hot backup mode will be corrupted and you will have to recover it.

考题 单选题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 work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()AA backup of the target database when it is mountedBA backup of online redo log files when the database is openCA backup of only used data blocks in the file beingbeingbackup upDA backup of online, read/write data files when the database is openEA backup of only those data blocks that have changed since a previous backupFA backup of online, read/write data files when the database is in the NOMOUNT state.

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

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

考题 单选题You work as a database administrator for Supportcenter.cn. 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 work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()A Restore all the data files and open the databaseB Create the data file and perform tablespace recoveryC No need to restore any file, just recover the databaseD Restore only the system data file and recover the databaseE Restore only lost date file and performtablespacerecovery

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

考题 单选题You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device.  The current consumption of your CPU is approximately 40 percent.  Which type of backup should you perform?()A  standard backup setB  image copyC  compressed backupD  user-managed 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

考题 单选题You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()A  redo log filesB  password fileC  control fileD  change tracking file

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

考题 单选题You work as a database administrator for Supportcenter.cn. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this?()A The DBMS_JOB packageB The BACKUP_JOB packageC The DBMS_BACKUP_RESTORE packageD The calendar tool in the Operating System (OS)E The backup scheduler in Enterprise Manager (EM)F The DBMS_BACKUP_SCHEDULER packager inline mode

考题 单选题Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()A  Put the database in hot backup mode and perform an online backup,including backing up the  archived redo logs.B  Just back up the database datafiles without shutting down the database.C  You will have to wait until you can shut down the database to perform the backup.D  Mark each datafile as backup in progress, back them up individually,and then mark them as backup not in progress. No archived redo logs will need to be backed up.E  Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing,you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup