itgle.com

单选题In user-managed backup and recover procedures， how are data files backed up？ （）A Using SQL commands.B Using SQL*Plus commands.C Using operating system commands.D Using Recover Manager commands.

题目
单选题
In user-managed backup and recover procedures， how are data files backed up？ （）
A

Using SQL commands.

B

Using SQL*Plus commands.

C

Using operating system commands.

D

Using Recover Manager commands.

相似考题

1. You are using Enterprise Manager to schedule backups for your database.  Which type of script would begenerated by the backup scheduler（）A、XML scriptB、PL/SQL scriptC、Operating system scriptThis document was downloaded from =>> http：//www.amaderforum.comD、Recovery Manager （RMAN） script

2.Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

3.You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system （OS） file.D、It is a Recovery Manager （RMAN） script

4.A company has a policy that states that all servers will be fully backed up on the weekend.Additionally， all changed items will be backed up each night. In the event of a server failure， the administrator wants to be able to fully recover the system using two restore jobs. Which of the following backup levels should be used nightly？（）A、IncrementalB、NormalC、DifferentialD、Full

更多“单选题In user-managed backup and recover procedures， how are data files backed up？ （）A Using SQL commands.B Using SQL*Plus commands.C Using operating system commands.D Using Recover Manager commands.”相关问题

  • 第1题：

    It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）

    • A、cannot be used in RMAN
    • B、by starting up the database again
    • C、by using the CATALOG command of RMAN
    • D、by using the RECOVER CATALOG command in RMAN
    • E、by re-creating the target control file to rebuild the RMAN repository

    正确答案:C

  • 第2题：

    You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？ （）

    • A、SQL script
    • B、PL/SQL script
    • C、Operating System （OS） script
    • D、Enterprise Manager （EM） script
    • E、Recovery Manager （RMAN） script

    正确答案:E

  • 第3题：

    You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup？（）

    • A、ABORT
    • B、NORMAL
    • C、IMMEDIATE
    • D、TRANSACTIONAL

    正确答案:B,C,D

  • 第4题：

    When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）

    • A、data file
    • B、password file
    • C、archivelog file
    • D、temporary file
    • E、online redo log file
    • F、the current control file
    • G、the tnsnames.ora file
    • H、current server parameter file

    正确答案:A,C,F,H

  • 第5题：

    In user-managed backup and recover procedures， how are data files backed up？ （）

    • A、Using SQL commands.
    • B、Using SQL*Plus commands.
    • C、Using operating system commands.
    • D、Using Recover Manager commands.

    正确答案:C

  • 第6题：

    单选题
    You are using Enterprise Manager to schedule backups for your database.  Which type of script wouldbe generated by the backup scheduler（）
    A

    XML script

    B

    PL/SQL script

    C

    Operating system script

    D

    Recovery Manager （RMAN） script


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    The Certkiller has a Windows 2008 domain controller server. This server is routinely backed up over the network from a dedicated backup server that is running Windows 2003 OS. You need to prepare the domain controller for disaster recovery apart from the routine backup procedures. You are unable to launch the backup utility while attempting to back up the system state data for the data controller. You need to backup system state data from the Windows Server 2008 domain controller server. What should you do（）
    A

    Add your user account to the local Backup Operators group

    B

    Install the Windows Server backup feature using the Server Manager feature.

    C

    Install the Removable Storage Manager feature using the Server Manager feature

    D

    Deactivating the backup job that is configured to backup Windows 2008 server domain controller on the Windows 2003 server.

    E

    None of the above


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）
    A

     The USERS.DBF datafile is corrupted and cannot be restored by RMAN.

    B

     The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.

    C

     The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.

    D

     The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    In user-managed backup and recover procedures， how are data files backed up？ （）
    A

    Using SQL commands.

    B

    Using SQL*Plus commands.

    C

    Using operating system commands.

    D

    Using Recover Manager commands.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？（）
    A

    SQL script

    B

    PL/SQL script

    C

    Operating System （OS） script

    D

    Enterprise Manager （EM） script

    E

    Recovery Manager （RMAN） script


    正确答案： E
    解析： 暂无解析

  • 第11题：

    单选题
    Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）
    A

    You need to perform the restore and recover operations manually, because the backup was made manually. 

    B

    First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 

    C

    First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 

    D

    You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）
    A

    It is a SQL script.

    B

    It is a PL/SQL file.

    C

    It is an operating system （OS） file.

    D

    It is a Recovery Manager （RMAN） script


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Which two are characteristics of user-managed backup and recovery operations？（）

    • A、Recovery is initiated using SQL*Plus.
    • B、Database files are backed up using SQL commands.
    • C、Database files are backed up with Recovery Manager.
    • D、Database files are restored using Recovery Manager.
    • E、Database files are backed up using operating system commands.

    正确答案:A,B

  • 第14题：

    Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）

    • A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
    • B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
    • C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
    • D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

    正确答案:C

  • 第15题：

    You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

    • A、 by using the DBMS_REPAIR package
    • B、 by using the DBVERIFY utility
    • C、 by using Block Media Recovery
    • D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

    正确答案:C

  • 第16题：

    Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）

    • A、Rebuild the index using the online option. 
    • B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 
    • C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 
    • D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

    正确答案:C

  • 第17题：

    You have a Windows Server 2008 R2 Hyper-V server. Virtual machines （VMs） store data on pass-through disks. You need to design a backup solution that allows you to restore VMs. What should you do？（）

    • A、Back up the VMs by using Windows Server Backup within the VMs
    • B、Back up the system state on the VMs by using Windows Server Backup within the VMs
    • C、Back up the Hyper-V server by using Microsoft System Center Data Protection Manager （DPM） 2007 with SP1
    • D、Create checkpoints of the VMs by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2

    正确答案:A

  • 第18题：

    单选题
    It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）
    A

    cannot be used in RMAN

    B

    by starting up the database again

    C

    by using the CATALOG command of RMAN

    D

    by using the RECOVER CATALOG command in RMAN

    E

    by re-creating the target control file to rebuild the RMAN repository


    正确答案： C
    解析： 暂无解析

  • 第19题：

    多选题
    Which two are characteristics of user-managed backup and recovery operations？（）
    A

    Recovery is initiated using SQL*Plus.

    B

    Database files are backed up using SQL commands.

    C

    Database files are backed up with Recovery Manager.

    D

    Database files are restored using Recovery Manager.

    E

    Database files are backed up using operating system commands.


    正确答案： A,C
    解析： 暂无解析

  • 第20题：

    单选题
    Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）
    A

    Rebuild the index using the online option. 

    B

    Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 

    C

    Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 

    D

    Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup； there is no need to apply the redo information

    B

     restore the full database to recover the data up to the point when you performed the backup

    C

     restore the tablespace from the backup and then perform a recovery using the backup control file

    D

     restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    You have a Windows Server 2008 R2 Hyper-V server. Virtual machines （VMs） store data on pass-through disks. You need to design a backup solution that allows you to restore VMs. What should you do？（）
    A

    Back up the VMs by using Windows Server Backup within the VMs

    B

    Back up the system state on the VMs by using Windows Server Backup within the VMs

    C

    Back up the Hyper-V server by using Microsoft System Center Data Protection Manager （DPM） 2007 with SP1

    D

    Create checkpoints of the VMs by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    A company has a policy that states that all servers will be fully backed up on the weekend.Additionally， all changed items will be backed up each night. In the event of a server failure， the administrator wants to be able to fully recover the system using two restore jobs. Which of the following backup levels should be used nightly？（）
    A

    Incremental

    B

    Normal

    C

    Differential

    D

    Full


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday.  How will you recover the dropped table， SCOTT.EMPLOYEE？（）
    A

     by using the Flashback Table feature

    B

     by using the Flashback Database feature

    C

     by performing incomplete recovery using RMAN utility

    D

     by performing incomplete recovery using user-managed recovery


    正确答案： C
    解析： 暂无解析

相关内容