网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
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
参考答案
更多 “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” 相关考题
考题
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
考题
居民、文教区自备发电机组,治理后的环境噪音标准为( )。A.昼<50dBA夜<40dBA
B.昼<60dBA夜<50dBA
C.昼<65dBA夜<55dBA
D.昼<70dBA夜<55dBA
考题
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?()A
statistics recommendationsB
SQL profile recommendationsC
index-related recommendationsD
restructuring 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? ()A
DBA_USERS B
DBA_OBJECTS C
DBA_TS_QUOTAS D
DBA_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?()A
the alert.log fileB
the DBA_ALERTS viewC
the Database Control Home pageD
the Database Control performance pageE
the 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()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.
考题
多选题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.
热门标签
最新试卷