i have passed the OCA yesterday , there was 2 new questions, the first
which datafiles of the following taplespaces must be recovered when database is closed choose two
1-system
2-sysaux
3-undo
4-temp
i sugesset it's system and undo
second question,
how to know information the occurs to a certain table
1-segment advisor,
2-sql tunning and sql access advisor
3-ADDM
4-AWR

السؤال الاول صحيح و الثاني لم اتذكر انه اتى في الامتحان و مبروك الشهادة

طيب يا أخي ممكن نعرف إجابة السؤال الثاني :

؟؟

sorry there wad error in the second question , the question is how to know information about fragmnetation that occurs to a certain table. with the same choices,
But i don not know the answer it was my worng question

if the question is how to know information about fragmnetation that occurs to a certain table. with the same choices,
the answer is number 1 segment advicer

أوافقك الرأي أخي نعم الfragmentation من الSegment advisor

اجابة السؤال الثاني هي awr لان الا advisor يقوم اعطائك تقرير عن المشكلة وكيفية تصليحها لاكن لمعرفة معلومات عن هذا الخطاء عن طريق awr والله اعلم