You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = ’LOCATION=/disk1/arch’ LOG_ARCHIVE_DEST_2 = ’LOCATION=/disk2/arch’ LOG_ARCHIVE_DEST_3 = ’LOACTION=/disk3/arch’ LOG_ARCHIVE_DEST_4 = ’LOCATION=/disk4/arch MANDATORY’ Identify the statement that correctly describes this setting.()
Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?()
Which statements about the MEMORY_TARGET initialization parameter are true?()
Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?()
How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database?()
You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement: SQL> SELECT name, value, isdefault 2 FROM v$parameter 3 WHERE name LIKE ’%size%’; The output of this statement displays that the DB_CACHE_SIZE, SHARED_POOL_SIZE, LARGE_POOL_SIZE, and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply?()
Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup?()
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?()
Which two statements are true regarding the SGA_TARGET initialization parameter()