随笔分类 - 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
阅读全文
摘要:Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)A. MEMORY_TARGET can be increased up to the value
阅读全文
摘要: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
阅读全文
摘要:Which two statements are correct about database transportation? (Choose two.)A. The source and target platforms must be the sameB. Redo logs, control
阅读全文
摘要:The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed?A. The Oracle database will perform block checki
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:Examine the parameter setting in your database: Which statement is correct about the database?A. Automatic memory management is disabled because PGA_A
阅读全文
摘要: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
阅读全文
摘要: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.
阅读全文
摘要:You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO
阅读全文
摘要:Exhibit: View the Exhibit to examine the parameter values. You are planning to set the value for theMEMORY_TARGET parameter of your database instance.
阅读全文
摘要:To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure n
阅读全文
摘要:Which of the following describes how a distributed resumable transaction behaves?A. The resumable setting on the initiating session determines the res
阅读全文
摘要:To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?A. RESUMABLE
阅读全文
摘要:When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?A. The V$PGA_TARGET_ADVICE view shows
阅读全文
摘要:Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)A.
阅读全文
摘要:In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?A. Setting a nonzero value for SGA_
阅读全文
摘要: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
阅读全文
浙公网安备 33010602011771号