单项选择题
单项选择题 Evaluatethefollowingfunctioncode:CREATEFUNCTIONget_dept_avg(dept_idNUMBER)RETURNNUMBERRESULT_CACHERELIES_ON(EMPLOYEES)ISavgsalNUMBER(6);BEGINSELECTAVG(SALARY)INTOavgsalFROMEMPLOYEESWHEREDEPARTMENT_ID=dept_id;RETURNavgsal;ENDget_dept_avg;Whichstatementistrueregardingtheabovefunction?()A.ThecachedresultbecomesinvalidwhenanystructuralchangeisdonetotheEMPLOYEEStable.B.Ifthefunctionexecutionresultsinanunhandledexception,theexceptionresultisalsostoredinthecache.C.Eachtimethefunctionisinvokedinadifferentsession,thecurrentresultintheresultcachegetsoverwritten.D.Ifthefunctionisinvokedwithadifferentparametervalue,theexistingresultintheresultcache getsoverwrittenbythelatestvalue.
单项选择题 YouconfiguredthelargepoolforOraclebackupandrestoreoperations.Asaresult,whichcomponentwouldrequirelessmemory?()
单项选择题 Thesalesreportneedstodisplaythesalespersonwiththehighestordertotal.Whichbuildreportbuildercomponentwouldyouusetocreateaplaceholdercolumntodisplaythevalue?()
单项选择题 TheDB_BLOCK_CHECKINGinitializationparameterissettoFALSE.Whatlevelofblockcheckingwouldbeperformed?()
单项选择题 您有一台运行WindowsVista的计算机。您在计算机的新分区上安装Windows7。您需要确保计算机总是在默认状态下启动WindowsVista。您应该怎么办?()