单选题

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? ()

    单选题查看答案