首页计算机考试Oracle认证
(单选题)

The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA,based on the amount of memory available on the system?()

A 20% SGA  80% PGA

B 25% SGA  75% PGA

C 50% SGA  50% PGA

D 75% SGA  25% PGA

E 80% SGA  20% PGA

正确答案

来源:www.examk.com

答案解析

相似试题

  • (多选题)

    In which of the scenarios will the DBA perform recovery()

    答案解析

  • (单选题)

    To determine the space allocated for temporary segments, the DBA can access which of the following views? ()

    答案解析

  • (单选题)

    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA?()

    答案解析

  • (单选题)

    To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()  

    答案解析

  • (单选题)

    What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED; command?()

    答案解析

  • (单选题)

    The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?()

    答案解析

  • (单选题)

    As A DBA, which of the following methods can you use to make a backup of your table?()

    答案解析

  • (单选题)

    To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?()  

    答案解析

  • (单选题)

    When creating a SQL tuning set,which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?()

    答案解析

  • (单选题)

    In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()

    答案解析

快考试在线搜题