网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
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
参考答案
更多 “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 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;
考题
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
考题
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.
考题
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
考题
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.
考题
How is block-change tracking enabled?() A、 With alter database enable block change trackingB、 With alter system enable block change trackingC、 With an init.ora parameter changeD、 With an spfile parameter change
考题
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 packageB、 by using the DB_BLOCK_CHECKING parameterC、 by using the DBVERIFY utilityD、 will not be completely resolved until the hardware fault is corrected
考题
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 numberB、 the locations of the redo log filesC、 the locations of the datafilesD、 the physical location of all the database changes
考题
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=1968B、 RECOVER CORRUPTION LISTC、 RECOVER DATAFILE 1201 BLOCK 1968D、 RECOVER BLOCK CORRUPTION LISTE、 None of the above
考题
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.
考题
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.
考题
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 listB、IP Block list providersC、recipient filteringD、sender filtering
考题
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.
考题
单选题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.
考题
单选题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 TRACKINGB
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
考题
多选题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?()ARECOVER FILE=1201 BLOCK=1968BRECOVER CORRUPTION LISTCRECOVER DATAFILE 1201 BLOCK 1968DRECOVER BLOCK CORRUPTION LISTENone of the above
考题
单选题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 uniformB
Choosing the Segment Space Management option to manualC
Setting autoextension on for the data file mentioned for the tablespaceD
Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
考题
多选题To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()AMultiple change tracking files can be created for a database.BThe change tracking file must be created after the first level 0 backup.CRMAN does not support backup and recovery of the change tracking file.DThe database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.
考题
单选题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.
考题
单选题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 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 packageB
by using the DB_BLOCK_CHECKING parameterC
by using the DBVERIFY utilityD
will not be completely resolved until the hardware fault is corrected
考题
单选题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 numberB
the locations of the redo log filesC
the locations of the datafilesD
the physical location of all the database changes
考题
单选题How is block-change tracking enabled?()A
With alter database enable block change trackingB
With alter system enable block change trackingC
With an init.ora parameter changeD
With an spfile parameter change
考题
单选题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.
考题
单选题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 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 TRACKINGB
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE C
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE D
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
考题
单选题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.
热门标签
最新试卷