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

izo-030

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

Moderator: Tim...

Guest

izo-030

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

Could you tell me which is the correct answer for this:

Which of the following parameters must be set to create a tablespace with a nonstandard block size?
a. db_keep_cache_size
b. db_block_size
c. db_cache_size
d. db_nK_cache_size

According to the book it's C. I thought it's D since C is used for standard block size.

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

RE: izo-030

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

Hi.

I would say D also. As you areprobably aware you cannot use alternative block sizes in tablespaces without configuring a buffer cache with that blocksize. With this in mind D is the only sensible answer.

Alot of people of pointed out incorrect questions in the study guides. Take heart that you spotted it :)

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 3 guests