Busy Studying . . . but why..?

After studying for the OCA exam for the past few weeks I am now going through demo exams. I have to say, if these are the types of questions I will see on the exam I don't know if I will take the second one.

Alot of the questions are very subjective and you are not provided with enough information to choose the 'best' answer. For example, one question is that a database is having IO issues and is suffering from degraded performance. The available answers are:

1. standby database
2. SQL Tuning/Access Advisors
3. file system without RAID
4. ASM

Depending on the circumstances 1, 2 or 4 may be the answer.

1. I have implemented a few standby databases which are opened in read only mode so that reports could be executed against them. This helped reduce the load on production because they are IO intensive and long running. All of our production environments are on a SAN so there isn't much more tuning we can do there.

2. I've seen databases accessed by poorly written SQL. Look at my post A New Record! So this could be the best answer if this was the database in question.

4. Sure ASM can help but we will be making assumptions about their IO subsystem. For all we know they may only have 1 disk on the server.

BTW> The correct answer was 4.

So for questions like this, I find myself trying to determine the best answer that Oracle may choose, not what may be best given my years of real life experience. Maybe its easier for someone that hasn't worked in the real world to perform well on this exam? That would explain pretty much every OCP we have hired in the past hasn't performed well......

1 comment:

Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.