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
查看审计策略是否生效的视图是?() 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
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
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
单选题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.