izo-030

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

Moderator: Tim...

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.
Guest
 

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
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Certification

Who is online

Users browsing this forum: No registered users and 1 guest

cron