题目内容

ForwhichofthefollowingcanyouuseSegmentShrink?()

A. Heaptables
B. Tableswithfunction-basedindexes
C. Indexes
D. Partitionsandsubpartitions
E. Noneoftheabove

查看答案
更多问题

YouaremaintainingyourdatabaseinOracle10g.YouhavesetthevalueoftheSTATISTICS_LEVELinitializationparametertoTYPICALandthevalueoftheFAST_START_MTTR_TARGETparameterto900seconds.Toincreasetheperformanceofthedatabase,youwanttodeterminethelogfilesizethatshouldequaltheminimumsizeofalltheonlineredologfiles.Whichcolumnwillenableyoutoperformthedesiredtask?()

A. theWRITES_LOGFILE_SIZEcolumnoftheV$INSTANCE_RECOVERYview
B. thecolumnoftheV$INSTANCE_RECOVERYview
C. theOPTIMAL_LOGFILE_SIZEcolumnoftheV$INSTANCE_RECOVERYview
D. theLOG_FILE_SIZE_REDO_BLKScolumnoftheV$INSTANCE_RECOVERYview

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

答案查题题库