Passed A&A 023

[D Maverick]

NDT,

Thanks! I used the Oracle Student Guide, Sybex and STS.
although Sybex is a good book for A&A (for concepts and illustration) it's not as complete as the Student Guide. it's a good suplement though.

Real exam questions are a bit harder than the STS, but if you understand the concepts behind the questions of STS. you're gonna be Ok.

I'll try to post some questions that i can remenber.

Thanks again.

The Maverick

[D Maverick]

Here are some Q&A that i can remember. I'm not sure of the answer though. you guys can correct me if im wrong.

What are two reasons for changing user quotas on a tablespace?

A. Datafile becomes full.
B. User encounters slow response time from the application.
C. Tables owned by a user exhibit rapid and unanticipated growth.
D. Database objects are reorganized and placed in different tablespace.

My answer is A and D.

An Oracle user receives the following error:
ORA-01555 SNAPSHOP TOO OLD
What are two possible solutions?

A. Increase the extent size of the rollback segments.
B. Perform media recovery.
C. Increase the number of rollback segments.
D. Increase the size of the rollback segment tablespace.
E. Increase the value of the OPTIMAL storage parameter

My answer is A & E

Consider the following command to create the user Peter?
CREATE USER peter
IDENTIFIED by pan
TEMPORARY TABLESPACE temp
PASSWORD EXPIRE;
Since no default tablespace was specified, what will happen if this command is executed?

A. The user will not own a home directory.
B. User peter will have TEMP tablespace as the default.
C. User peter will have SYSTEM tablespace as the default.
D. The code will produce an error message, the user peter will not be created.

My answer is C

The Maverick

[Edited by D Maverick on 09-20-2001 at 08:59 AM]

[NDT]

THanks for your help Maverick, I'm also preparing for the A&A exam, probably try to write one next week.

One more thing:
=================
Here are some Q&A that i can remember. I'm not sure of the answer though. you guys can correct me if im wrong.

What are two reasons for changing user quotas on a tablespace?

A. Datafile becomes full.
B. User encounters slow response time from the application.
C. Tables owned by a user exhibit rapid and unanticipated growth.
D. Database objects are reorganized and placed in different tablespace.

My answer is A and D.
===================================

Should the answer for the above question be C,D ??
I'm not sure changing the user quota would reduce the size of the datafile at all but correct me if I am wrong. THanks

[D Maverick]

Hi guys! help us out here, NDT and I are not sure about our answers to this question.

What are two reasons for changing user quotas on a tablespace?

A. Datafile becomes full.
B. User encounters slow response time from the application.
C. Tables owned by a user exhibit rapid and unanticipated growth.
D. Database objects are reorganized and placed in different tablespace.

Thank you very much.

The Maverick

[Raminder]

TS_quotas are for creating new objects in the table space not for inserting/updating records in existing table.

Thus (c) cannot be correct. I think its (a) & (d).

[Edited by Raminder on 09-22-2001 at 10:41 PM]

[julian]

This is one of those tricky A&A questions.

After insert into a table you/user might get:
ORA-1536 "space quota exceeded for tablespace ..."
The error comes because a new extent needs to be created and the user has already reached his quota of space in the tablespace in question. Now, what do you do next: you grant additional quota on the tablespace to the user in question!

From the question it is a bit unclear: is there one or more than one datafile in the TS :-)

[grjohnson]

An Oracle user receives the following error:
ORA-01555 SNAPSHOP TOO OLD
What are two possible solutions?

A. Increase the extent size of the rollback segments.
B. Perform media recovery.
C. Increase the number of rollback segments.
D. Increase the size of the rollback segment tablespace.
E. Increase the value of the OPTIMAL storage parameter

Personally, I would say, A, C.

[NDT]

According to one of the Study Guides for Oracle 8i A&A Exam that I've read, the main reasons that we may be required to modify a user's qouta are:
1. The users tables start to grow alot
2. an application requires additional tables or indexes
3. if objects are reorganized and moved to different tablespaces

Based on the above circumstances I think C, D are the appropriate answers

Radminder:
I think your accessment is ALMOST accurate:
=============================
TS_quotas are for creating new objects in the table space not for inserting/updating records in existing table.

Thus (c) cannot be correct. I think its (a) & (d).
==============================

but from what I know, if you're the owner of the objects in a tablespace then the sum of all the objects current sizes (not the inital) in that tablespace must be less than or equal to the assigned qouta therefore you may get ORA-1536 error when the table grows beyond the usage quota specified. In my opinion, I think if you can create a small object which eventually grows bigger than the qouta then what's the point of specifying a quota. And I do agree with you that inserts, updates and deletes are controlled by privileges not qoutas. Plse correct me if Im wrong.

( plse don't take this personal, I think it's rude to make a correction since you're certified and I've never written any ocp exams before but this where I can learn from you all. )


[Edited by NDT on 09-24-2001 at 01:51 AM]

[julian]

Originally posted by NDT
According to one of the Study Guides for Oracle 8i A&A Exam that I've read, the main reasons that we may be required to modify a user's qouta are:
1. The users tables start to grow alot
2. an application requires additional tables or indexes
3. if objects are reorganized and moved to different tablespaces

Based on the above circumstances I think C, D are the appropriate answers

True!

[julian]

Originally posted by grjohnson
An Oracle user receives the following error:
ORA-01555 SNAPSHOP TOO OLD
What are two possible solutions?

A. Increase the extent size of the rollback segments.
B. Perform media recovery.
C. Increase the number of rollback segments.
D. Increase the size of the rollback segment tablespace.
E. Increase the value of the OPTIMAL storage parameter

Personally, I would say, A, C.

You have to recreate the RBSs in a way that A & E are fulfilled. Also, you could think of making the rBS with anough high minimum number of extents, for example 20. I always craete RBS with 20 initial extents (there is a reason for that :-))