Interview Questions Answers in DB Administration

abul

{ City } calgary
< Country > canada
* Profession *
User No # 61603

Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 2

Questions / { abul }

Questions Answers Category Views Company eMail

Answers / { abul }

Question { 7138 }

How would you go about increasing the buffer cache hit ratio?

Answer

we can set db_catch_size using alter system command with
scope spfile sid='x';

Is This Answer Correct ?

0 Yes

2 No

Question { 11345 }

How would you determine who has added a row to a table?

Answer

setting up FGA(fine_grain_audit) properly and we can lookup
details who & when or what updated !

Is This Answer Correct ?

1 Yes

0 No