itgle.com

YouaremaintainingthePRODdatabaseofNetFxCorporation.YousetthevalueoftheSQL_TRACEparametertoTRUE.Whatwillbetheimpactofthissetting?()A.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforaninstanceandwritethemintheUSER_DUMP_DESTdi

题目
YouaremaintainingthePRODdatabaseofNetFxCorporation.YousetthevalueoftheSQL_TRACEparametertoTRUE.Whatwillbetheimpactofthissetting?()

A.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforaninstanceandwritethemintheUSER_DUMP_DESTdirectory.

B.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforasessionandwritethemintheUSER_DUMP_DESTdirectory.

C.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforaninstanceandwritethemintheBACKGROUND_DUMP_DESTdirectory.

D.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforasessionandwritethemintheBACKGROUND_DUMP_DESTdirectory.


相似考题