Passed A&A 023

Quote:

---

adding more RBS may or may not help

---

That's correct!

Quote:

---

but increase OPTIMAL and extent size or higher number of extents DOES help for sure

---

True. The question is made so, that you have to choose 2 of the 3 remaining options :-)

One has to choose the best answers.....

What a dooozzzey of a question. I hope the Backup and Recovery exams is a little more clearer in what it asks... PHEW!

Hi here are some more question from 023 exam. please correct me if im wrong.

1. Which two parameters might affect the concurrency of transactions on a data block? (choose 2)

A. PCTUSED
B. PCTFREE
C. INITRANS
D. MAXEXTENTS
E. NEXTEXTENT

My answer is B & C

2. What are two effects of setting REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE? (choose 2)

A. Password file can be stored remotely
B. Password file access is restricted to local users
C. Only one instance on the database can use the password file
D. Remote connection using the SYSDBA privileges are allowed
E. Remote connection using the SYSDBA privileges are prohibited

My answer is B & C


Thanks

The Maverick

Quote:

---

Originally posted by grjohnson
What a dooozzzey of a question. I hope the Backup and Recovery exams is a little more clearer in what it asks... PHEW!

---

It is in fact.

1. B & C If you run out of ITL slots in the data block, and processes queue for access to an ITL slot, you might get a dead lock. This is likely to happend if you have INITRANS 1 and PCTFREE 0.

2. D & C With Exclusive REMOTE_LOGIN_PASSWORDFILE any user/password combination in the password file can can log to Oracle remotely and adminster the instance.

Thanks Julian

Just failed the A&A, went in confident and finished the last question with the biggest smile on my face THEN, couldn't believe my eyes I had scored 40/64.. I am still recovering from shock! I had done the Sybex tests and the Sybex Virtual Test Center tests and found one of the Sybex VTs far more difficult but still passed them. Went through several questions on this thread which I've just discovered I ended up answering today and my answers concurr with what you guys choose and of course there was the usual dose of a couple of stupid Oracle Certifiaction questions where more than 1/2 options could be arguably right.

I feel absolutely decimated simply cos "I knew" I'd passed, if you can understand what I mean. If I was unsure of my chances I wouldn't be feeling so bad, the problem is I don't know where I lost the marks and I'm not sure I can do any better, sure I have the section analysis and I can sit here and argue with myself that I definitely picked up more correct answers than what I'm seeing and may have dropped some there but to get 24 wrong it just dosen't match up !! This I felt was an easier exam than the PL/SQL by far....

Well it's a double dose for me A&A and R&R in December, and I really don't know what to say right now but my confidence has just taken a kicking.

Rex

Rex,
I'm sure you will pass it next time you attend. A&A is the trickest of all 5 exams. It has probably the most complicated questions. Did you go for 8 or 8i A&A?

Rex,

Im sorry to hear that. Anyway, i hope you can put the past behind and move on. Its natural to feel angry and sad about it, but dont let failure hinder you from striving even harder.

I know you'll pass it next time. Dont worry! Good luck.