题目内容

What elements of globalization can be explicitly defined using the NLS_LANG environment variable?()

A. NLS_LANGUAGE
B. NLS_SORT
C. NLS_CALENDAR
D. NLS_CHARACTERSET
E. NLS_TERRITORY

查看答案
更多问题

Youarecreatingacluster.Thetablesintheclusterhavearelativelyuniformdistributionofvaluesintheindexcolumnandthequeriesagainsttheclusteredtablewillalmostuseanequalityoperatortoretrievethedesiredrow.Whichtypeofclusterwillyoucreate?()

A. Indexcluster
B. Hashcluster
C. SortedHashcluster
D. RealApplicationCluster

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

答案查题题库