随笔分类 -  ocp-parameter

摘要:Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance.To what value will the 阅读全文
posted @ 2017-11-16 16:15 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0)
摘要:Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)A. MEMORY_TARGET can be increased up to the value 阅读全文
posted @ 2017-11-16 15:13 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
摘要:What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?A. The number of DBWR processes increasesB. The number of ASMB processes i 阅读全文
posted @ 2017-11-16 14:44 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要:Which two statements are correct about database transportation? (Choose two.)A. The source and target platforms must be the sameB. Redo logs, control 阅读全文
posted @ 2017-11-16 14:42 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
摘要:The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?A. The Oracle database will perform block checki 阅读全文
posted @ 2017-11-16 14:41 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
摘要:What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?A. An upper limit on how far you can flash back the database, depending on the informa 阅读全文
posted @ 2017-11-16 13:45 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
摘要:Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is ru 阅读全文
posted @ 2017-11-16 13:39 巴啦啦大魔王 阅读(142) 评论(0) 推荐(0)
摘要:Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the 阅读全文
posted @ 2017-11-16 13:18 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
摘要:Examine the parameter setting in your database: Which statement is correct about the database?A. Automatic memory management is disabled because PGA_A 阅读全文
posted @ 2017-11-16 11:17 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
摘要:You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?A. Set MEMORY_TARGET to zeroB. Set the 阅读全文
posted @ 2017-11-16 11:12 巴啦啦大魔王 阅读(109) 评论(0) 推荐(0)
摘要:Note the following parameter settings: Which setting is NOT allowed? A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;C. 阅读全文
posted @ 2017-11-16 09:02 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
摘要:You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO 阅读全文
posted @ 2017-11-15 17:04 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0)
摘要:Exhibit: View the Exhibit to examine the parameter values. You are planning to set the value for theMEMORY_TARGET parameter of your database instance. 阅读全文
posted @ 2017-11-15 16:07 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
摘要:To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure n 阅读全文
posted @ 2017-11-14 16:51 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要:Which of the following describes how a distributed resumable transaction behaves?A. The resumable setting on the initiating session determines the res 阅读全文
posted @ 2017-11-14 15:00 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0)
摘要:To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?A. RESUMABLE 阅读全文
posted @ 2017-11-14 14:55 巴啦啦大魔王 阅读(69) 评论(0) 推荐(0)
摘要:When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?A. The V$PGA_TARGET_ADVICE view shows 阅读全文
posted @ 2017-11-14 14:50 巴啦啦大魔王 阅读(121) 评论(0) 推荐(0)
摘要:Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)A. 阅读全文
posted @ 2017-11-14 14:42 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0)
摘要:In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?A. Setting a nonzero value for SGA_ 阅读全文
posted @ 2017-11-14 14:38 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
摘要:Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropr 阅读全文
posted @ 2017-11-14 14:17 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)