单项选择题 Becauseofhardwarefailure，youdecidedtodroparedologmemberfromthedatabase.Whichconditionshouldbemettodroparedologfile？（）

单项选择题 WhatdoestheFastConnectionFailoverfeatureofActiveGridLinkforRACprovide?（）

单项选择题 YouobservethatinyourPRODdatabase，customerinformationisbeingmodifiedbysomeunauthorizedusers.YouwanttokeeptrackofallofthetransactionshappeningonthetableusingPL/SQL.WhichtypeofPL/SQLsubprogramorconstructwouldyouusetoaccomplishthistask？（）A.functionsB.packagesC.proceduresD.databasetriggersE.anonymousPL/SQLblock

单项选择题 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？（）