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% PGAB、 25% SGA 75% PGAC、 50% SGA 50% PGAD、 75% SGA 25% PGAE、 80% SGA 20% PGA

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

相关考题:

Youwanttoviewthenameofaprogramassociatedwithajobformakingsomechangestotheprogram.Whichviewwillyouquerytofindthenameoftheprogramassociatedwiththejob?() A.DBA_SCHEDULER_JOB_RUN_DETAILSB.DBA_SCHEDULER_RUNNING_JOBSC.DBA_SCHEDULER_JOBSD.DBA_SCHEDULER_JOB_LOG

Whichviewwillyouusetoviewinformationregardingthejobsthatarecurrentlyrunninginadatabase?() A.DBA_SCHEDULER_RUNNING_JOBSB.DBA_SCHEDULER_JOB_RUN_DETAILSC.DBA_SCHEDULER_JOBSD.DBA_SCHEDULER_JOB_LOG

YouworkasadatabaseadministratorforCertkiller.com.Inyourdevelopmentenvironmentenvironment,thedevelopersareresponsibleformodifyingthetablestructureaccordingtotheapplicationrequirements.However,youwanttokeeptrackoftheALTERTABLEcommandsbeingexecutedbydevelopers,soyouenableauditingtoachievethisobjective.Whichtwoviewswouldyourefertofindouttheauditinformation?()A.DBA_AUDIT_TRAILB.DBA_AUDIT_SESSIONC.DBA_FGA_AUDIT_TRAILD.DBA_COMMON_AUDIT_TRAIL

下面关于DBA的描述,正确的是A.DBA用于分配上下行带宽,确保服务质量B.DBA可以提高带宽利用率C.DBA可以减少延时D.DBA可以实现动态带宽按需分配

查看审计策略是否生效的视图是?() A. DBA_AUDIT_EXISTSB. DBA_AUDIT_OBJECTC. DBA_AUDIT_POLICY_COLUMNSD. DBA_AUDIT_POLICIESE. DBA_AUDIT_SESSION

Inordertofindouthowmanydatabaseobjectsauserhascreated,whichviewwouldtheDBAqueryintheOracledatadictionary?() A.DBA_USERSB.DBA_OBJECTSC.DBA_TS_QUOTASD.DBA_TAB_PRIVS

Todeterminethespaceallocatedfortemporarysegments,theDBAcanaccesswhichofthefollowingviews?() A.DBA_TABLESPACESB.DBA_TABLESC.DBA_SEGMENTSD.DBA_FREE_SPACE

数据库系统包括(  )。A.DB、DBMS B.DB、DBA C.DB、DBMS、DBA、用户 D.DB、DBMS、DBA、OS、用户

居民、文教区自备发电机组,治理后的环境噪音标准为( )。A.昼<50dBA夜<40dBAB.昼<60dBA夜<50dBAC.昼<65dBA夜<55dBAD.昼<70dBA夜<55dBA

请简述什么是DBA及DBA的作用。

下面关于DBA的描述错误的是()。A、DBA用于分配下行带宽确保服务质量B、DBA可以提高带宽利用率C、DBA可以减少数据传输平均时延D、DBA功能依靠绑定DBA模板来实现

In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()A、DBA_USERS B、DBA_OBJECTS C、DBA_TS_QUOTAS D、DBA_TAB_PRIVS

()DBA视图中含有所有表空间的描述。A、DBA_VIEWSB、DBA_TABLESC、DBA_TABLESPACESD、DBA_DATA_FILES

下面关于DBA的描述,正确的是()A、 DBA用于分配上下行带宽,确保服务质量B、 DBA可以提高带宽利用率C、 DBA可以减少延时D、 DBA可以实现动态带宽按需分配

下面关于DBA的描述错误的是?()A、DBA功能依靠绑定DBA模板实现B、DBA可以提高带宽利用率C、DBA可以减少数据传输平均时延D、DBA用于分配上下行带宽,确保服务质量

Which view will you use to view information regarding the jobs that are currently running in a database?()A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command:  SQL SELECT reason,metric_value FROM dba_outstanding_alerts; REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output()A、An Automatic Workload Repository snapshot has been taken recently.B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to, in order to confirm that the alert has been raised due the event?()A、the alert.log fileB、the DBA_ALERTS viewC、the Database Control Home pageD、the Database Control performance pageE、the Database Control Maintenance page

Which Scheduler view(s) can be queried to see which jobs are currently executing?()A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_CURRENT_JOBSD、 DBA_SCHEDULER_JOBSE、 DBA_SCHEDULER_EXECUTING_JOBS

Which Scheduler view(s) can be queried to see which jobs are currently executing? ()A、DBA_SCHEDULER_JOB_RUN_DETAILSB、DBA_SCHEDULER_RUNNING_JOBS DBAC、DBA_SCHEDULER_CURRENT_JOBSD、DBA_SCHEDULER_JOBS DBAE、DBA_SCHEDULER_EXECUTING_JOBS

汽车喇叭声级合格范围应为()A、A、85dB~100dBA.B、B、90dB~100dBA.C、C、90dB~105dBA.D、D、90dB~115dBA.

填空题声压为80dBA和70dBA的声源叠加后是()dBA。

单选题The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()A statistics recommendationsB SQL profile recommendationsC index-related recommendationsD restructuring of SQL recommendations

单选题The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()Astatistics recommendationsBSQL profile recommendationsCindex-related recommendationsDrestructuring of SQL recommendations

单选题In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()ADBA_USERS BDBA_OBJECTS CDBA_TS_QUOTAS DDBA_TAB_PRIVS

单选题You define an alert to be raised when the USERS tablespace usage has reached 80%of the total space. Which area would you refer to, in order to confirm that the alert has been raised due the event?()Athe alert.log fileBthe DBA_ALERTS viewCthe Database Control Home pageDthe Database Control performance pageEthe Database Control Maintenance page

单选题View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command:  SQL SELECT reason,metric_value FROM dba_outstanding_alerts; REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output()AAn Automatic Workload Repository snapshot has been taken recently.BThe non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.CThe threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.DThe threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

多选题As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query?() SQL select group_number, name, state from v$ASM_DISKGROUP;  GROUP_NUMBER NAME STATE  0 DGROUP1 DISMOUNTED  2 DGROUP2 MOUNTED  3 DGROUP3 MOUNTEDAThe DGROUP1 disk group was unmounted by another DBA.BA datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED stateCOne of the redundant disks (DGROUP1) has been lost in a disk group.DThis query has no meaning in an ASM instance.EA disk associated with a disk group was discovered after the ASM instance initially opened.