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

You enable block change tracking. You issue the following co

题目
单选题
You enable block change tracking. You issue the following command：   BACKUP INCREMENTAL LEVEL 0 DATABASE；   The next day，you issue the following command：   BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which statement about the use of the change tracking file is true？（）
A

 RMAN reads the block change tracking file only when it performs the incremental level 0 backup.

B

 RMAN reads the block change tracking file when it performs both incremental backups.

C

 RMAN reads the block change tracking file only when it performs the incremental level 1 backup.

D

 RMAN does not read the block change tracking file when it performs either incremental backup.

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

第1题：

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

  • A、 You must enable the block change tracking feature.
  • B、 You must have enable the flashback feature.
  • C、 You must use the OMF in your database.
  • D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

正确答案:D

第2题：

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

第3题：

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;


参考答案：C

第4题：

You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session：   ALTER SESSION ENABLE RESUMABLE；   Which command could you issue to enable the resumable space allocation feature at the session level？（）  

  • A、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；
  • B、 ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；
  • C、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；
  • D、 ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；

正确答案:C

第5题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

  • A、 when you change the name of a datafile
  • B、 when you drop a table from the database
  • C、 when you take an export of the database
  • D、 when you back up the database using OS utilities
  • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
  • F、 when you issue a BACKUP command from inside the RMAN run block

正确答案:A,E,F

第6题：

What purpose would you achieve by enabling the block change tracking feature？（）

  • A、 Eliminate the necessity for backups.
  • B、 Perform optimized image copy backups.
  • C、 Perform optimized incremental backups.
  • D、 Enable checkpoint （CKPT） to perform checkpointing at every block change.
  • E、 Enable database writer （DBWn） to write changed blocks to data files faster.

正确答案:C

第7题：

Which RMAN backup command is used to create the block-change tracking file？（）  

  • A、 alter database create block change tracking file
  • B、 alter database enable block change file
  • C、 alter database enable block change tracking using file ，/ora01/opt/ block_change_tracking.fil
  • D、 alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’
  • E、 alter system block change tracking on

正确答案:C

第8题：

You performed an incremental level 0 backup of a database:RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;To enable block change tracking after the incremental level 0 backup, you issued this command:SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘ /mydir/rman_change_track.f’;To perform an incremental level 1 cumulative backup, you issued this command:RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;Which three statements are true?（）

A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

B. The change tracking file must always be backed up when you perform a full database backup.

C. Block change tracking will always reduce I/O performed during cumulative incremental backups.

D. More than one database block may be read by an incremental backup for a change made to a single block.

E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.


参考答案：B, C, E

第9题：

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

第10题：

You received the following error：   ORA-01578： ORACLE data block corrupted   （file # %s， block # %s）   Which file will you check to view additional information regarding the cause of this error？（）

  • A、the alert log file and the trace files
  • B、 the redo log files
  • C、 the control file
  • D、 the change tracking file

正确答案:A

更多相关问题
相关内容