题目内容

Theperformanceofyourdatabaseisaffectedbythepresenceoftwologmembersineachonlineredologgroupandtheplacementofredologmembersofagrouponthesamedisk.Youdecidetoplacetheredologmembersofagrouponseparatedisks.Whichviewwillyouquerytofindthenameandlocationofalltheonlineredologmembers？（）

A. V$LOG
B. V$LOGFILE
C. DBA_LOG_GROUPS
D. V$LOG_HISTORY

查看答案

搜索结果不匹配？点我反馈

更多问题

WhenmanuallyconfiguringtheSGA，whichofthefollowingparameterchangesrequiresaninstancerestarttotakeeffect？（）"FirstTest，FirstPass"-www.lead2pass.com97Oracle1Z0-053Exam

A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE

查看答案

ThedatabaseusersareconnectingtothePRODdatabasefromdifferentapplications，therebydegradingthedatabaseperformance.Theseniordatabaseadministratorsuspectsthelargenumberofconcurrentconnectionstobethereasonforlowperformanceandasksyoutorestrictthenumberconcurrentconnectionsperdatabaseusertoone.Whichactionwouldyoutaketoachievethisobjective？（）

A. settheSESSIONSto1intheparameterfile
B. grantSINGLESESSIONprivilegetoalloftheusers
C. settheSESSIONS_PER_USERto1intheusers’profile
D. grantRESTRICTEDSESSIONprivilegetoallofthedatabaseusers
E. createarolewithSINGLESESSIONprivilegeandassigntheroletotheusers

查看答案

TheDatabaseResourceManagerisnotcurrentlyactiveinyourdatabasethatisupandrunning.YoucreatedaresourceplannamedDAY_PLANthatcontainstwosub-plansnamedMANAGERS_PLANandCLERKS_PLAN.YoudecidedtoactivateDAY_PLANbyexecutingthefollowingstatement：SQL>ALTERSYSTEMSETRESOURCE_MANAGER_PLAN=’managers_plan’；Whatwillbetheoutcomeofthisstatement？（）

A. ThestatementwilldeactivateDAY_PLAN.
B. ThestatementwillactivateDAY_PLANasthetopplan.
C. ThestatementwillactivateMANAGERS_PLANasthetopplan.
D. ThestatementwillreturnanerrorbecauseMANAGERS_PLANisnotthetopplan.

查看答案

Which Scheduler view（s) can be queried to see which jobs are currently executing？（）

A. DBA_SCHEDULER_JOB_RUN_DETAILS
B. DBA_SCHEDULER_RUNNING_JOBS DBA
C. DBA_SCHEDULER_CURRENT_JOBS
DBA_SCHEDULER_JOBS DBA
E. DBA_SCHEDULER_EXECUTING_JOBS

查看答案

Theperformanceofyourdatabaseisaffectedbythepresenceoftwologmembersineachonlineredologgroupandtheplacementofredologmembersofagrouponthesamedisk.Youdecidetoplacetheredologmembersofagrouponseparatedisks.Whichviewwillyouquerytofindthenameandlocationofalltheonlineredologmembers？（）

A. V$LOG B. V$LOGFILE C. DBA_LOG_GROUPS D. V$LOG_HISTORY

WhenmanuallyconfiguringtheSGA，whichofthefollowingparameterchangesrequiresaninstancerestarttotakeeffect？（）"FirstTest，FirstPass"-www.lead2pass.com97Oracle1Z0-053Exam

Which Scheduler view（s) can be queried to see which jobs are currently executing？ （）

A. V$LOG
B. V$LOGFILE
C. DBA_LOG_GROUPS
D. V$LOG_HISTORY

Which Scheduler view（s) can be queried to see which jobs are currently executing？（）