问答题

TheEMPtableexistsinyourschema.Youwanttoexecutethefollowingquery：SELECTename，salFROMempASOFTIMESTAMP（SYSTIMESTAMP-INTERVAL’6’MINUTE）WHEREename=’ALLEN’；Whataretheminimumrequirementsforthestatementtoexecutesuccessfully？（）
A.ARCHIVELOGmodemustbeenabled
B.RowMovementmustbeenabledforthetable
C.FLASHBACKmustbesettoONforthedatabase
D.TheUNDO_MANAGEMENTparametermustbesettoAUTO
E.TheUNDO_RETENTIONparametermustbesetappropriately

A.Youwanttoexecutethefollowingquery：SELECTename，salFROMempASOFTIMESTAMP（SYSTIMESTAMP-INTERVAL’6’MINUTE）WHEREename=’ALLEN’；Whataretheminimumrequirementsforthestatementtoexecutesuccessfully？（）
A.ARCHIVELOGmodemustbeenabled
B.RowMovementmustbeenabledforthetable
C.FLASHBACKmustbesettoONforthedatabase
D.TheUNDO_MANAGEMENTparametermustbesettoAUTO
E.TheUNDO_RETENTIONparametermustbesetappropriately

你可能感兴趣的试题

问答题

WhichtwoPL／SQL8featuresaresupportedinOracleForms?（）

A.methods
B.objecttables
C.objectcolumns
D.collectiontypes
E.objectasstoredprocedureparameters

问答题

OracleJRockitJVMuses－Xnsoptiontosetnurserysizewhenthegenerationalgarbagecollectionmodeisused.WhichtwoJVMpropertiesareaffectedbychangingitssize？（）

A.compactionratiolimit
B.garbagecollectionfrequency
C.garbagecollectiontimes
D.fragmentationheapsize