This forum is currently locked. You can't register or post questions at this time. (read more)

izo-030 Q2

All posts relating to Oracle certification (OCA, OCP, OCM).

Moderator: Tim...

Guest

izo-030 Q2

Postby Guest » Mon Nov 01, 2004 6:09 pm

Hi, Can you tell me the answer for this question?

Q 6.The database was started up using a text parameter file.

What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?



A. Only MEMORY is updated.

B. Only SPFILE values are updated.

C. Only init.ora parameters are updated.

D. Both SPFILE and MEMORY memory values are updated.

E. Boht init.ora parameters and SPFILE values are updated.



Ans: D

I would have thought that it's A. Which is the default operation on previous Oracle releases. D is if the instance
was started using a server parameter file.

thank

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

RE: izo-030 Q2

Postby Tim... » Mon Nov 01, 2004 6:09 pm

Hi.

The best thing to do is try it.

When I start up my test system with the pfile I'm able to alter parameters so the scope must be defaulting to memory. If not I would expect to see an error saying there is no spfile.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Certification”

Who is online

Users browsing this forum: No registered users and 2 guests