随笔分类 - OCP
OCP考试学习
摘要:You want to configure and schedule offline database backups to run automatically. Which tool or utility would you use to achieve this?A.the XML script
阅读全文
摘要:Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)A.dat
阅读全文
摘要:You are using Enterprise Manager to schedule backups for your database. Which type of script would be generated by the backup scheduler?A.XML scriptB.
阅读全文
摘要:You are managing an Oracle Database 11g database with this backup strategy:- Every Sunday night, level 0 backup is performed.- On Monday night and sub
阅读全文
摘要:You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape.Which two statements
阅读全文
摘要:You are working on a database that must be functioning 24 hours a day, 7 days a week. The database is configured in ARCHIVELOG mode.Which two options
阅读全文
摘要:You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements
阅读全文
摘要:Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode?A.The backup will consist of used data block
阅读全文
摘要:Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice
阅读全文
摘要:The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server:LOG_
阅读全文
摘要:You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario
阅读全文
摘要:You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 paramete
阅读全文
摘要:You configured the Flash Recovery Area (FRA) for your database. The database instance is running in ARCHIVELOG mode. The default location for the arch
阅读全文
摘要:You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Fla
阅读全文
摘要:The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?A.Inactive and cur
阅读全文
摘要:You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.)A.Disab
阅读全文
摘要:Which two statements are true about checkpointing? (Choose two.)A. The checkpoint frequency decreases with the smaller redo log file size.B. It ensure
阅读全文
摘要:Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)A.The MTTR advisor wi
阅读全文
摘要:Examine the values for the following initialization parameters:FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0Which two will be the implications
阅读全文
摘要:You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. T
阅读全文
浙公网安备 33010602011771号