You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）A、 RBALB、 CKPTC、 SMOND、 PMONE、 MMONF、 CTWRG、 DBWR

题目

You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）

  • A、 RBAL
  • B、 CKPT
  • C、 SMON
  • D、 PMON
  • E、 MMON
  • F、 CTWR
  • G、 DBWR
相似考题

1.You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

2. The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）  A、 The block change tracking feature must be enabled.B、 OMF must be configured on your database.C、 The database must be in ARCHIVELOG mode.D、 A USERID must be supplied.

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? （）(Choose two)A、You must configure block change tracking fileB、You must have first level 1 backups for RMAN to restore blocksC、You must ensure that the SALES database is mounted or openD、You must have full or level 0 backups for RMAN to restore blocksE、You must take the tools01.dbf data file offline before you start a block media recovery

4.How is block-change tracking enabled?（）A、With alter database enable block change trackingB、With alter system enable block change tracking C、With an init.ora parameter change D、With an spfile parameter change 

更多“You enabled block”相关问题

  • 第1题：

    You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；  What will be the result of issuing this command？（）

    • A、 The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.
    • B、 The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.
    • C、 The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.
    • D、 The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.

    正确答案:C

  • 第2题：

    You issued the following command to analyze the SCOTT.EMP table for block corruption：   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE；  You received the following error：   ORA-01578： ORACLE data block corrupted  （file # %s， block # %s）   How will you resolve the block corruption problem？（）

    • A、 by using the DBMS_REPAIR package
    • B、 by using the DB_BLOCK_CHECKING parameter
    • C、 by using the DBVERIFY utility
    • D、 will not be completely resolved until the hardware fault is corrected

    正确答案:D

  • 第3题：

    While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.  Which RMAN command do you use to perform BMR and repair the corrupt block？（）  

    • A、 RECOVER FILE=1201 BLOCK=1968
    • B、 RECOVER CORRUPTION LIST
    • C、 RECOVER DATAFILE 1201 BLOCK 1968
    • D、 RECOVER BLOCK CORRUPTION LIST
    • E、 None of the above

    正确答案:B,C

  • 第4题：

    You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

    • A、You must ensure that the SALES database is mounted or open.
    • B、You must restore a backup control file to perform a block media recovery.
    • C、You must take the tools01.dbf data file offline before you start a block media recovery.
    • D、You must put the database in NOARCHIVELOG mode to perform a block media recovery.
    • E、You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

    正确答案:A,E

  • 第5题：

    Your computer has Microsoft Windows Firewall enabled.  Your child plays an online game that uses connectionless traffic over port 5678 for inbound and outbound traffic.  You need to prevent your child from playing this game.  What should you do？ （）

    • A、Enable the User Account Control feature.
    • B、Configure the user account of your child as a standard user.
    • C、Create an outbound rule in Windows Firewall to block UDP port 5678.
    • D、Create an outbound rule in Windows Firewall to block TCP port 5678.

    正确答案:C

  • 第6题：

    单选题
    You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?（）
    A

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

    B

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE

    C

    ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

    D

    ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING


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

  • 第7题：

    单选题
    View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.  Which configuration couldhave enabled the block selection of 16 KB（）
    A

    Choosing the extent allocation type to uniform

    B

    Choosing the Segment Space Management option to manual

    C

    Setting autoextension on for the data file mentioned for the tablespace

    D

    Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value


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

  • 第8题：

    单选题
    You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）
    A

     One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.

    B

     One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.

    C

     One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.

    D

     One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.


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

  • 第9题：

    单选题
    You issued the following command to analyze the SCOTT.EMP table for block corruption：   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE；  You received the following error：   ORA-01578： ORACLE data block corrupted  （file # %s， block # %s）   How will you resolve the block corruption problem？（）
    A

     by using the DBMS_REPAIR package

    B

     by using the DB_BLOCK_CHECKING parameter

    C

     by using the DBVERIFY utility

    D

     will not be completely resolved until the hardware fault is corrected


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

  • 第10题：

    单选题
    How is block-change tracking enabled？（）
    A

     With alter database enable block change tracking

    B

     With alter system enable block change tracking

    C

     With an init.ora parameter change

    D

     With an spfile parameter change


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

  • 第11题：

    单选题
    You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）
    A

     RBAL

    B

     CKPT

    C

     SMON

    D

     PMON

    E

     MMON

    F

     CTWR

    G

     DBWR


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

  • 第12题：

    单选题
    The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）
    A

     The block change tracking feature must be enabled.

    B

     OMF must be configured on your database.

    C

     The database must be in ARCHIVELOG mode.

    D

     A USERID must be supplied.


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

  • 第13题：

    How is block-change tracking enabled？（）  

    • A、 With alter database enable block change tracking
    • B、 With alter system enable block change tracking
    • C、 With an init.ora parameter change
    • D、 With an spfile parameter change

    正确答案:A

  • 第14题：

    You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）

    • A、 the system change number
    • B、 the locations of the redo log files
    • C、 the locations of the datafiles
    • D、 the physical location of all the database changes

    正确答案:D

  • 第15题：

    To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（） 

    • A、 Multiple change tracking files can be created for a database.
    • B、 The change tracking file must be created after the first level 0 backup.
    • C、 RMAN does not support backup and recovery of the change tracking file.
    • D、 The database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.

    正确答案:C,D

  • 第16题：

    You have an Exchange Server 2010 organization that contains multiple Hub Transport servers. You need to recommend a message hygiene solution to meet the following requirements： .Block servers that are known to send spam .Minimize administrative effort What should you recommend？（）

    • A、an IP Block list
    • B、IP Block list providers
    • C、recipient filtering
    • D、sender filtering

    正确答案:B

  • 第17题：

    单选题
    You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；  What will be the result of issuing this command？（）
    A

     The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.

    B

     The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.

    C

     The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.

    D

     The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.


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

  • 第18题：

    多选题
    While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.  Which RMAN command do you use to perform BMR and repair the corrupt block？（）
    A

    RECOVER FILE=1201 BLOCK=1968

    B

    RECOVER CORRUPTION LIST

    C

    RECOVER DATAFILE 1201 BLOCK 1968

    D

    RECOVER BLOCK CORRUPTION LIST

    E

    None of the above


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

  • 第19题：

    多选题
    To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）
    A

    Multiple change tracking files can be created for a database.

    B

    The change tracking file must be created after the first level 0 backup.

    C

    RMAN does not support backup and recovery of the change tracking file.

    D

    The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.


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

  • 第20题：

    单选题
    How is block-change tracking enabled?（）
    A

    With alter database enable block change tracking

    B

    With alter system enable block change tracking 

    C

    With an init.ora parameter change 

    D

    With an spfile parameter change 


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

  • 第21题：

    单选题
    You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature.  What information will be written in the change tracking file？（）
    A

     the system change number

    B

     the locations of the redo log files

    C

     the locations of the datafiles

    D

     the physical location of all the database changes


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

  • 第22题：

    单选题
    While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）
    A

     Block Media Recovery must be used with RMAN.

    B

     You must perform complete recovery of individual blocks.

    C

     You must have a full RMAN backup， not an incremental backup.

    D

     You must use the DBVERIFY utility before using the Block Media Recovery feature.


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

  • 第23题：

    单选题
    You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.  Which statement should you use to enable the block change tracking feature？（）
    A

     ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

    B

     ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE 

    C

     ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 

    D

     ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING


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

相关内容