单选题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/pr

题目
单选题
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?（）
A

/u01/app/oracle/product/11.1.0/db_1

B

/u01/app/oracle

C

$ORACLE_HOME/bdump

D

$ORACLE_HOME/log

相似考题

1.Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL－related problems?()A. ADR diagnostic filesB. all the optimizer statisticsC. initialization parameter settingsD. PL/SQL functions, procedures, and packagesE. the table and index definitions and actual data

2. In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？  A、 database buffer cacheB、 shared poolC、 PGAD、 large pool

3.Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?（）A、ADR diagnostic filesB、all the optimizer statisticsC、initialization parameter settingsD、PL/SQL functions, procedures, and packagesE、the table and index definitions and actual data

4.View the Exhibit to examine the parameter values.You are planning to set the value for the MEMORY_TARGET parameter of your database instance.What value would you recommend?()A. 90 MBB. 272 MBC. 362 MBD. 1,440 MB

更多“Examine the following values of the initialization parameter”相关问题

  • 第1题：

    Given： String value = getServletContext（）.getInitParameter（"foo"）； in an HttpServlet and a web applicationdeployment descriptor that contains： foo frodo Which two are true？（）

    • A、The foo initialization parameter CANNOT be set programmatically.
    • B、Compilation fails because getInitParameter returns type Object.
    • C、The foo initialization parameter is NOT a servlet initialization parameter.
    • D、Compilation fails because ServletContext does NOT have a getInitParameter method.
    • E、The foo parameter must be defined within the  element of the deployment descriptor.

    正确答案:A,C

  • 第2题：

    When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）

    • A、create
    • B、import
    • C、load
    • D、sqlimport
    • E、update

    正确答案:B,D

  • 第3题：

    An RMAN backup job fails， displaying the following error：  ORA/x7f19809： limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）

    • A、take the backup of the flash recovery area less frequently
    • B、increase the value of the UNDO_RETENTION initialization parameter
    • C、change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO
    • D、change the backup retention policy to retain the backups for a smaller period of time 
    • E、increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter
    • F、increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

    正确答案:D,E

  • 第4题：

    You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）

    • A、 only the INSTANCE_TYPE initialization parameter is set to an invalid value
    • B、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
    • C、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
    • D、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

    正确答案:D

  • 第5题：

    多选题
    You decided to increase the value for the SHARED_SERVERS parameter by using the following command：  SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？；  Which three values can be specified for the SCOPE clause？（）
    A

    ALL

    B

    PFILE

    C

    BOTH

    D

    NONE

    E

    SPFILE

    F

    MEMORY

    G

    INSTANCE

    H

    DATABASE


    正确答案： C,E,F
    解析： 暂无解析

  • 第6题：

    多选题
    You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE://        SGA_TARGET = 512M        SHARED_POOL_SIZE = 256M   Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）
    A

    Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.

    B

    Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.

    C

    Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.

    D

    Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.

    E

    Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool  component to the desired size by reallocating the additional memory from the auto-tuned memory components.

    F

    Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.


    正确答案： A,B
    解析： 暂无解析

  • 第7题：

    单选题
    You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
    A

     Increase the value of the FAST_START_MTTR_TARGET initialization parameter.

    B

     Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.

    C

     Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.

    D

     Increase the value of the SGA_TARGET initialization parameter.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    多选题
    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（）
    A

    The SGA advisor will be disabled.

    B

    The MTTR advisor will be disabled.

    C

    Automatic checkpoint tuning will be disabled.

    D

    Checkpoint information will not be written to the alert log file.


    正确答案： B,C
    解析： 暂无解析

  • 第9题：

    单选题
    You have included the following parameter settings in your SPFILE://    SGA_MAX_SIZE=8G   SGA_TARGET=6G   DB_CACHE_SIZE=2G   SHARED_POOL_SIZE=1G   LOG_BUFFER=64M   DB_KEEP_CACHE_SIZE=960M   Which statement is true if you modify the SGA_TARGET initialization parameter？（）
    A

    The SGA_TARGET initialization parameter cannot be set to a value greater than 8G

    B

     The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G

    C

     The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G

    D

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M 

    E

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？
    A

     database buffer cache

    B

     shared pool

    C

     PGA

    D

     large pool


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You have created a password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3   Which of the following is true about this password file？（）
    A

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.

    B

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.

    C

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is

    D

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    多选题
    Given： String value = getServletContext（）.getInitParameter（"foo"）； in an HttpServlet and a web applicationdeployment descriptor that contains： foo frodo Which two are true？（）
    A

    The foo initialization parameter CANNOT be set programmatically.

    B

    Compilation fails because getInitParameter returns type Object.

    C

    The foo initialization parameter is NOT a servlet initialization parameter.

    D

    Compilation fails because ServletContext does NOT have a getInitParameter method.

    E

    The foo parameter must be defined within the  element of the deployment descriptor.


    正确答案： A,C
    解析： 暂无解析

  • 第13题：

    You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

    • A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
    • B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
    • C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
    • D、 Increase the value of the SGA_TARGET initialization parameter.

    正确答案:B

  • 第14题：

    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（）

    • A、The SGA advisor will be disabled.
    • B、The MTTR advisor will be disabled.
    • C、Automatic checkpoint tuning will be disabled.
    • D、Checkpoint information will not be written to the alert log file.

    正确答案:B,C

  • 第15题：

    Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）  

    • A、 Automatic PGA Memory Management
    • B、 Automatic SGA Memory Management
    • C、 Automatic Shared Memory Management
    • D、 Automatic Memory Management
    • E、 Manual SGA Memory Management
    • F、 None of the above

    正确答案:D

  • 第16题：

    多选题
    An RMAN backup job fails， displaying the following error：  ORA-19809： limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full.  Which two actions could you take to resolve the error and avoid this error in the future？ （）
    A

    take the backup of the flash recovery area less frequently

    B

    increase the value of the UNDO_RETENTION initialization parameter

    C

    change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO

    D

    change the backup retention policy to retain the backups for a smaller period of time

    E

    increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter

    F

    increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter


    正确答案： C,B
    解析： 暂无解析

  • 第17题：

    单选题
    You executed the following command to back up your control file：  ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  Which initialization parameter is used to specify the location of the trace file？（）
    A

    USER_DUMP_DEST

    B

    CORE_DUMP_DEST

    C

    TRACE_DUMP_DEST

    D

    BACKUP_DUMP_DEST

    E

    BACKGROUND_DUMP_DEST


    正确答案： A
    解析： 暂无解析

  • 第18题：

    多选题
    To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）
    A

    DB_CACHE_SIZE

    B

    SHARED_POOL_SIZE

    C

    LARGE_POOL_SIZE

    D

    JAVA_POOL_SIZE

    E

    SGA_MAX_SIZE

    F

    SORT_AREA_SIZE


    正确答案： B,D
    解析： 暂无解析

  • 第19题：

    单选题
    In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）
    A

    The STATISTICS_LEVEL initialization parameter is set to BASIC

    B

    The PGA_AGGREGATE_TARGET initialization parameter is set to zero.

    C

    The SGA_MAX_SIZE initialization parameter is set to less than 20 GB

    D

    The DB_CACHE_SIZE initialization parameter is set to less than 5 GB

    E

    The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    多选题
    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？（）
    A

    The SGA_TARGET initialization parameter cannot be set to a value less than 1G

    B

    The SGA_TARGET initialization parameter cannot be set to a value greater than 1G

    C

    The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA

    D

    The values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.

    E

    No minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and  JAVA_POOL_SIZE initialization parameters.

    F

    The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the  DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.


    正确答案： F,B
    解析： 暂无解析

  • 第21题：

    单选题
    You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）
    A

     only the INSTANCE_TYPE initialization parameter is set to an invalid value

    B

     only the ASM_POWER_LIMIT initialization parameter is set to an invalid value

    C

     only the LARGE_POOL_SIZE initialization parameter is set to an invalid value

    D

     both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values


    正确答案： D
    解析： 暂无解析

  • 第22题：

    多选题
    An RMAN backup job fails， displaying the following error：  ORA/x7f19809： limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）
    A

    take the backup of the flash recovery area less frequently

    B

    increase the value of the UNDO_RETENTION initialization parameter

    C

    change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO

    D

    change the backup retention policy to retain the backups for a smaller period of time

    E

    increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter

    F

    increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter


    正确答案： D,E
    解析： 暂无解析

  • 第23题：

    多选题
    When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）
    A

    create

    B

    import

    C

    load

    D

    sqlimport

    E

    update


    正确答案： B,D
    解析： 暂无解析

  • 第24题：

    单选题
    The SPFILE for the PROD database specifies the following initialization parameter values：   SGA_TARGET = 2G   DB_8K_CACHE_SIZE = 128M   You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay， you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M：   SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH；   What is the result of this statement？（）
    A

     The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.

    B

     The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.

    C

     The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.

    D

     The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.


    正确答案： B
    解析： 暂无解析

相关内容