niusouti.com

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

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

相似考题

1.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

2. You are managing an Oracle Database 11g database with this backup strategy：  - Every Sunday night， level 0 backup is performed.  - On Monday night and subsequent days， level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true（）A、The backup contains all the used blocks.B、The backup contains all the used and unused blocks.C、The backup contains blocks that have changed since the last level 0 backup.D、The backup contains blocks that have changed since the last level 1 backup taken last week.

3.You are managing an Oracle Database 11g database with the following backup strategy：1） On Sunday， an incremental level 0 tape backup is performed.2） Monday through Saturday， a cumulative incremental level 1 tape backup is performed. Which twostatements are true regarding the backups performed（）A、The backup performed in step 1 backs up all blocks that have ever been in use in the database.B、The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.C、The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.D、The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1

4. You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA， a big file tablespace of size 100 TB on tape drive， but you have tapedrives of only 10 GB each.  Which method would accomplish the task quickly and efficiently？（）  A、 parallel image copy backupB、 backup with MAXPIECESIZE configured for the channelC、 parallel backup with MAXPIECESIZE configured for the channeD、 intrafile parallel backup

参考答案和解析
正确答案： D,B
解析： 暂无解析
更多“You are managing a 24*7 database. The backup strategy for th”相关问题

  • 第1题：

    ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?（）

    • A、parallel image copy backup 
    • B、backup with MAXPIECESIZE configured for the channel 
    • C、parallel backup with MAXPIECESIZE configured for the channel 
    • D、intrafile parallel backup

    正确答案:D

  • 第2题：

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

    • A、The backup status will be marked expired in RMAN recovery catalog.
    • B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
    • C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
    • D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
    • E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

    正确答案:C

  • 第3题：

    You are managing an Oracle Database 11g database with the following backup strategy：  1.On Sunday， an incremental level 0 tape backup is performed.  2.Monday through Saturday， acumulativeincremental level 1 tape backup is performed.  Which two statements are true regarding the backups performed（）

    • A、The backup performed in step 1 backs up all blocks that have ever been in use in the database. 
    • B、The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
    • C、The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
    • D、The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1.

    正确答案:A,B

  • 第4题：

    You need to recommend a backup strategy for the servers in the San Francisco office. The strategy must meet the company's technical requirements    What should you include in the recommendation？（）

    • A、native-boot virtual hard disks （VHDs）
    • B、Microsoft System Center Data Protection Manager 2010
    • C、system restore points
    • D、Windows Server Backup

    正确答案:B

  • 第5题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.  In the options below, which strategy should you use? （） 

    • A、You should use database snapshots 
    • B、You should use database backup and restore 
    • C、You should use database backup and restore along with compression 
    • D、You should use schema-bound views in a read-only database. The database resides on the same instance.

    正确答案:A

  • 第6题：

    单选题
    You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）
    A

    SYSDBA

    B

    SYSOPER

    C

    No system privileges are required for the RMAN user.

    D

    Only SYS user can connect and execute RMAN commands on a target database.


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

  • 第7题：

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


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

  • 第8题：

    单选题
    You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently?（）
    A

    parallel image copy backup

    B

    backup with MAXPIECESIZE configured for the channel

    C

    parallel backup with MAXPIECESIZE configured for the channel

    D

    intrafile parallel backup


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

  • 第9题：

    单选题
    According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
    A

    The backup is similar to image copy.

    B

    The backup contains all used data blocks.

    C

    The backup contains only unused data blocks.

    D

    The backup contains all data blocks changed since the last incremental level 1 backup.


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

  • 第10题：

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

    B

    Your database must be running in NOARCHIVELOG mode

    C

    To back up a tablespace, it must be in backup mode

    D

    To back up a tablespace, it must first be taken offline


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

  • 第11题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（）
    A

    You should implement Differential backup 

    B

    You should implement Database snapshots

    C

    You should implement Primary filegroup backup 

    D

    You should implement Transaction log backup


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

  • 第12题：

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

    B

     Your database must be running in NOARCHIVELOG mode

    C

     To back up a tablespace，it must be in backup mode

    D

     To back up a tablespace，it must first be taken offline


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

  • 第13题：

    You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

    • A、The backup is similar to image copy.
    • B、The backup contains all used data blocks.
    • C、The backup contains only unused data blocks.
    • D、The backup contains all data blocks changed since the last incremental level 1 backup.

    正确答案:B

  • 第14题：

    You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）

    • A、backup pieces
    • B、control file autobackups
    • C、copies of all the parameter files
    • D、trace file generated using BACKUP CONTROLFILE TO TRACE

    正确答案:A,B

  • 第15题：

    According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

    • A、The backup is similar to image copy.
    • B、The backup contains all used data blocks.
    • C、The backup contains only unused data blocks.
    • D、The backup contains all data blocks changed since the last incremental level 1 backup.

    正确答案:B

  • 第16题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?（）  

    • A、You should implement Differential backup 
    • B、You should implement Database snapshots
    • C、You should implement Primary filegroup backup 
    • D、You should implement Transaction log backup

    正确答案:B

  • 第17题：

    单选题
    You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
    A

    The backup is similar to image copy.

    B

    The backup contains all used data blocks.

    C

    The backup contains only unused data blocks.

    D

    The backup contains all data blocks changed since the last incremental level 1 backup.


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

  • 第18题：

    多选题
    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,B
    解析： 暂无解析

  • 第19题：

    单选题
    You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command：   RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS；   After configuring the recovery window， you performed the database backup as follows：（）
    A

     Backup RB1 at log sequence number 12871 on 5th Jan

    B

     Backup RB2 at log sequence number 15622 on 12th Jan

    C

     Backup RB3 at log sequence 16721 on 15th Jan

    D

     On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.


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

  • 第20题：

    单选题
    You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA， a big file tablespace of size 100 TB on tape drive， but you have tapedrives of only 10 GB each.  Which method would accomplish the task quickly and efficiently？（）
    A

     parallel image copy backup

    B

     backup with MAXPIECESIZE configured for the channel

    C

     parallel backup with MAXPIECESIZE configured for the channe

    D

     intrafile parallel backup


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

  • 第21题：

    单选题
    You are managing an Oracle Database 11g database with this backup strategy：  - Every Sunday night， level 0 backup is performed.  - On Monday night and subsequent days， level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true（）
    A

    The backup contains all the used blocks.

    B

    The backup contains all the used and unused blocks.

    C

    The backup contains blocks that have changed since the last level 0 backup.

    D

    The backup contains blocks that have changed since the last level 1 backup taken last week.


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

  • 第22题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.  In the options below, which strategy should you use? （）
    A

    You should use database snapshots 

    B

    You should use database backup and restore 

    C

    You should use database backup and restore along with compression 

    D

    You should use schema-bound views in a read-only database. The database resides on the same instance.


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

  • 第23题：

    单选题
    ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?（）
    A

    parallel image copy backup 

    B

    backup with MAXPIECESIZE configured for the channel 

    C

    parallel backup with MAXPIECESIZE configured for the channel 

    D

    intrafile parallel backup


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

  • 第24题：

    单选题
    Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）
    A

     Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.

    B

     Tell them that their request cannot be met with the current backup strategy.

    C

     Restore the 19ths backup， apply the online redo logs，and open the database.

    D

     Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo  logs，and recover the database to the 20th.

    E

     Use the recover database command to roll back the database from today to the 19th of the month.


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

相关内容