单项选择题
A. The parameter DB_CACHE_SIZE must be a multiple of 8.
B. The value of the parameter SGA_MAX_SIZE must be increased.
C. The tablespace must be created with a uniform extent size of 8 KB
D. The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
单项选择题 YouareshrinkingtheSCOTT.EMPtablebyexecutingtheALTERTABLESCOTT.EMPSHRINKSPACECASCADEstatement.WhatisaprerequisiteforshrinkingtheSCOTT.EMPtable?()
单项选择题 YouaremaintainingyourdatabaseinOracle10g.YouhavesetthevalueoftheSTATISTICS_LEVELinitializationparametertoTYPICALandthevalueoftheFAST_START_MTTR_TARGETparameterto900seconds.Toincreasetheperformanceofthedatabase,youwanttodeterminethelogfilesizethatshouldequaltheminimumsizeofalltheonlineredologfiles.Whichcolumnwillenableyoutoperformthedesiredtask?()
单项选择题 Youarecreatingacluster.Thetablesintheclusterhavearelativelyuniformdistributionofvaluesintheindexcolumnandthequeriesagainsttheclusteredtablewillalmostuseanequalityoperatortoretrievethedesiredrow.Whichtypeofclusterwillyoucreate?()