单选题Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）A To limit the User Global Area （UGA） memory allocated to 

题目
单选题
Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）
A

To limit the User Global Area （UGA） memory allocated to a session from the SGA

B

To limit the amount of memory to be used for the dispatcher queue of a session in SGA

C

To limit the amount of memory to be used for the request pool in System Global Area （SGA）

D

To control the amount of memory allocated in SGA for the local variables for each shared server process

相似考题

1.In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?()A. Setting a metric thresholdB. Implementing Database Resource ManagerC. Enabling resumable timeout for user sessionsD. Decreasing the value of the IDLE_TIME resource limit in the default profile

2. Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA，  which configuration would you set to support more than 1，500 connections at a time（）A、You would configure more listeners for the database.B、You would configure the database in shared server mode to use the connection pooling feature.C、You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.D、You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

3.Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）A、modify the HASH_AREA_SIZE initialization parameterB、modify the PGA_AGGREGATE_TARGET initialization parameterC、modify the WORK_AREASIZE_POLICY initialization parameterD、increase the value of the SGA_TARGET initialization parameterE、increase the value of the SGA_MAX_SIZE initialization parameterF、increase the value of the SORT_AREA_SIZE initialization parameter

4.You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()A. User session dataB. Stack spaceC. Private SQL areaD. Location of the runtime area for DML and DDL StatementsE. Location of a part of the runtime area for SELECT statements

更多“单选题Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）A To limit the User Global Area （UGA） memory allocated to ”相关问题

  • 第1题：

    Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）

    • A、To limit the User Global Area （UGA） memory allocated to a session from the SGA
    • B、To limit the amount of memory to be used for the dispatcher queue of a session in SGA
    • C、To limit the amount of memory to be used for the request pool in System Global Area （SGA）
    • D、To control the amount of memory allocated in SGA for the local variables for each shared server process

    正确答案:A

  • 第2题：

    SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）

    • A、The User Global Area （UGA） is not configured.
    • B、The sessions were started using the login name SYS.
    • C、The sessions are running in the Automatic Shared Memory Management mode.
    • D、The sessions are running in the automatic Program Global Area （PGA） memory management mode.

    正确答案:D

  • 第3题：

    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

    • A、to enable operating system authentication for a remote client
    • B、to restrict the scope of administration to identical operating systems
    • C、to allow the start up and shut down of the database from a remote client
    • D、to enable the administration of the operating system from a remote client
    • E、to disable the administration of the operating system from a remote client

    正确答案:A

  • 第4题：

    You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）

    • A、Configure Java Pool to cache the java objects.
    • B、Configure Streams Pool to enable parallel processing.
    • C、Increase Shared Pool size to cache more PL/SQL objects.
    • D、Increase Database Buffer Cache size to increase cache hits.
    • E、Configure Large Pool to be used by RMAN and shared server.
    • F、Increase the total System Global Area （SGA） size to increase memory hits.

    正确答案:E

  • 第5题：

    Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）

    • A、large pool
    • B、streams pool
    • C、keep buffer cache
    • D、recycle buffer cache

    正确答案:A

  • 第6题：

    You are the network administrator for Your network consists of two Active Directory domains. Each department has its own organizational unit (OU) for departmental user accounts. Each OU has a separate Group Policy object (GPO) A single terminal server named TestKingTerm1 is reserved for remote users. In addition, several departments have their own terminal servers for departmental use. Your help desk reports that user sessions on TestKingTerm1 remain connected even if the sessions are inactive for days. Users in the accounting department report slow response times on their terminal server. You need to ensure that users of TestKingTerm1 are automatically logged off when their sessions are inactive for more than two hours. Your solution must not affect users of any other terminal servers. What should you do?（）

    • A、For all accounting users, change the session limit settings.
    • B、On TestKingTerm1, use the Terminal Services configuration tool to change the session limit settings.
    • C、Modify the GPO linked to the Accounting OU by changing the session limit settings in user-level group polices.
    • D、Modify the GPO linked to the Accounting OU by changing the session limit settings in computer-level group polices.

    正确答案:B

  • 第7题：

    单选题
    You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）
    A

    Configure Java Pool to cache the java objects.

    B

    Configure Streams Pool to enable parallel processing.

    C

    Increase Shared Pool size to cache more PL/SQL objects.

    D

    Increase Database Buffer Cache size to increase cache hits.

    E

    Configure Large Pool to be used by RMAN and shared server.

    F

    Increase the total System Global Area （SGA） size to increase memory hits.


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

  • 第8题：

    单选题
    Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）
    A

    to limit the User Global Area （UGA） memory allocated to a session from the SGA

    B

    to limit the amount of memory to be used for the dispatcher queue of a session in SGA

    C

    to limit the amount of memory to be used for the request pool in System Global Area （SGA）

    D

    to control the amount of memory allocated in SGA for the local variables for each shared server process


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

  • 第9题：

    单选题
    SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）
    A

    The User Global Area （UGA） is not configured.

    B

    The sessions were started using the login name SYS.

    C

    The sessions are running in the Automatic Shared Memory Management mode.

    D

    The sessions are running in the automatic Program Global Area （PGA） memory management mode.


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

  • 第10题：

    单选题
    Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）
    A

    To limit the User Global Area （UGA） memory allocated to a session from the SGA

    B

    To limit the amount of memory to be used for the dispatcher queue of a session in SGA

    C

    To limit the amount of memory to be used for the request pool in System Global Area （SGA）

    D

    To control the amount of memory allocated in SGA for the local variables for each shared server process


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

  • 第11题：

    单选题
    You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.  Which action would you consider to overcome the performance degradation？（）
    A

    Configure Java Pool to cache the java objects.

    B

    Configure Streams Pool to enable parallel processing.

    C

    Increase Shared Pool size to cache more PL/SQL objects.

    D

    Increase Database Buffer Cache size to increase cache hits.

    E

    Configure Large Pool to be used by RMAN and shared server.

    F

    Increase the total System Global Area （SGA） size to increase memory hits.


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

  • 第12题：

    单选题
    Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time.  You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA，  which configuration would you set to support more than 1，500 connections at a time（）
    A

    You would configure more listeners for the database.

    B

    You would configure the database in shared server mode to use the connection pooling feature.

    C

    You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.

    D

    You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.


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

  • 第13题：

    Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）

    • A、to limit the User Global Area （UGA） memory allocated to a session from the SGA
    • B、to limit the amount of memory to be used for the dispatcher queue of a session in SGA
    • C、to limit the amount of memory to be used for the request pool in System Global Area （SGA）
    • D、to control the amount of memory allocated in SGA for the local variables for each shared server process

    正确答案:A

  • 第14题：

    You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）

    • A、LOGICAL_READS_PER_SESSION 
    • B、CONNECT_TIME 
    • C、COMPOSITE_LIMIT 
    • D、CPU_PER_SESSION 
    • E、PRIVATE_SGA

    正确答案:C

  • 第15题：

    You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）

    • A、The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
    • B、The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
    • C、Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.
    • D、The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

    正确答案:B,D

  • 第16题：

    A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work.  ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）

    • A、Modify the profile assigned to the user.
    • B、Modify the roles assigned to the users.
    • C、Modify the object privileges assigned to the user.
    • D、Modify the system privileges assigned to the users.
    • E、Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

    正确答案:A

  • 第17题：

    You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.  Which action would you consider to overcome the performance degradation？（）

    • A、Configure Java Pool to cache the java objects.
    • B、Configure Streams Pool to enable parallel processing.
    • C、Increase Shared Pool size to cache more PL/SQL objects.
    • D、Increase Database Buffer Cache size to increase cache hits.
    • E、Configure Large Pool to be used by RMAN and shared server.
    • F、Increase the total System Global Area （SGA） size to increase memory hits.

    正确答案:E

  • 第18题：

    多选题
    You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）
    A

    User session data

    B

    Stack space

    C

    Private SQL area

    D

    Location of the runtime area for DML and DDL Statements

    E

    Location of a part of the runtime area for SELECT statements


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

  • 第19题：

    单选题
    Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）
    A

    large pool

    B

    streams pool

    C

    keep buffer cache

    D

    recycle buffer cache


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

  • 第20题：

    单选题
    You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）
    A

    to enable operating system authentication for a remote client

    B

    to restrict the scope of administration to identical operating systems

    C

    to allow the start up and shut down of the database from a remote client

    D

    to enable the administration of the operating system from a remote client

    E

    to disable the administration of the operating system from a remote client


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

  • 第21题：

    多选题
    You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）
    A

    The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.

    B

    The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.

    C

    Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.

    D

    The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.


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

  • 第22题：

    单选题
    Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）
    A

    modify the HASH_AREA_SIZE initialization parameter

    B

    modify the PGA_AGGREGATE_TARGET initialization parameter

    C

    modify the WORK_AREASIZE_POLICY initialization parameter

    D

    increase the value of the SGA_TARGET initialization parameter

    E

    increase the value of the SGA_MAX_SIZE initialization parameter

    F

    increase the value of the SORT_AREA_SIZE initialization parameter


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

  • 第23题：

    单选题
    In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?（）
    A

    Setting a metric threshold

    B

    Implementing Database Resource Manager

    C

    Enabling resumable timeout for user sessions

    D

    Decreasing the value of the IDLE_TIME resource limit in the default profile


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

  • 第24题：

    单选题
    Your database is running on the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）
    A

     modify the HASH_AREA_SIZE initialization parameter

    B

     modify the PGA_AGGREGATE_TARGET initialization parameter

    C

     modify the WORK_AREASIZE_POLICY initialization parameter

    D

     increase the value of the SGA_TARGET initialization parameter

    E

     increase the value of the SGA_MAX_SIZE initialization parameter

    F

     increase the value of the SORT_AREA_SIZE initialization parameter


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

相关内容