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

Moderator: Tim...



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.

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

RE: izo-030

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


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 :)


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: https://oracle-base.com
My blog: https://oracle-base.com/blog

Return to “Oracle Certification”

Who is online

Users browsing this forum: No registered users and 1 guest