违法和不良信息举报 联系客服
免费注册 登录

You want to configure and schedule offline database backups 

题目
单选题
You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）
A

the XML script

B

the PL/SQL script

C

the DBMS_SCHEDULER package

D

Enterprise Manager to schedule the backup

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention. What should you do to achieve the objective？（）

  • A、configure the database to run in ARCHIVELOG mode
  • B、configure the Flash Recovery Area to enable automatic database backup
  • C、schedule the database backup using DBMS_JOB package after creating the database
  • D、schedule the database backup using Recovery Manager （RMAN） commands after creating the database
  • E、schedule the database backup using Database Configuration Assistant （DBCA） while creating the database

正确答案:E

第2题：

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

  • A、You must configure block change tracking file
  • B、You must have first level 1 backups for RMAN to restore blocks
  • C、You must ensure that the SALES database is mounted or open
  • D、You must have full or level 0 backups for RMAN to restore blocks
  • E、You must take the tools01.dbf data file offline before you start a block media recovery

正确答案:C,D

第3题：

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?()

A. You must configure block change tracking file

B. You must have first level 1 backups for RMAN to restore blocks

C. You must ensure that the SALES database is mounted or open

D. You must have full or level 0 backups for RMAN to restore blocks

E. You must take the tools01.dbf data file offline before you start a block media recovery


参考答案：C, D

第4题：

You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）

  • A、the XML script
  • B、the PL/SQL script
  • C、the DBMS_SCHEDULER package
  • D、Enterprise Manager to schedule the backup

正确答案:D

第5题：

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

  • A、You must shut down the database instance to perform the backups.
  • B、You must configure the Flash Recovery Area （FRA） for the database.
  • C、You can perform complete database backups without closing the database.
  • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

正确答案:C,D

第6题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  • A、The database is in mount state.
  • B、One of the tablespaces is offline.
  • C、One of the tablespaces is read only.
  • D、The database operates in ARCHIEVELOG mode. 
  • E、The database operates in NOARCHIEVELOG mode.

正确答案:E

第7题：

Which two statements are true regarding the database in ARCHIVELOG mode？（）

  • A、You have to shut down the database to perform the backups.
  • B、Archiving information is written to the data files and redo log files.
  • C、You can perform complete database backups without closing the database.
  • D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
  • E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

正确答案:C,E

第8题：

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? ()(Choose two)

A. You must configure block change tracking file

B. You must have first level 1 backups for RMAN to restore blocks

C. You must ensure that the SALES database is mounted or open

D. You must have full or level 0 backups for RMAN to restore blocks

E. You must take the tools01.dbf data file offline before you start a block media recovery


参考答案：C, D

第9题：

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

  • A、The DBMS_JOB package
  • B、The BACKUP_JOB package
  • C、The DBMS_BACKUP_RESTORE package
  • D、The calendar tool in the Operating System （OS）
  • E、The backup scheduler in Enterprise Manager （EM）
  • F、The DBMS_BACKUP_SCHEDULER packager inline mode

正确答案:E

第10题：

You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands：   CONFIGURE DEFAULT DEVICE TYPE TO sbt；   CONFIGURE BACKUP OPTIMIZATION ON；   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   From Monday to Saturday， you performed the following actions：   Day                         Action  Monday                BACKUP DATABASE  Tuesday                BACKUP DATABASE  Wednesday              BACKUP DATABASE  Thursday               BACKUP DATABASE  Friday                 BACKUP DATABASE  Saturday               BACKUP DATABASE  How many times will the backup of the USERS tablespace be performed？（）

  • A、 The backup will not be performed at all.
  • B、 three times
  • C、 four times
  • D、 six times

正确答案:C

更多相关问题
相关内容