Oracle Exam 1Z0-072 Topic 2 Question 4 Discussion

Actual exam question for Oracle's 1Z0-072 exam

Question #: 4
Topic #: 2

In your database, you want to create a tablespace of non-standard block size by using this command:

CREATE TABLESPACE ns_tbs

DATAFILE '/u01oracle/data/nstbs_f01.dbf' SIZE 100M

BLOCKSIZE 16K;

Which is a requirement for this command to succeed?

AAll other DB_nK_CACHE_SIZE parameters should be set to zero.

BThe DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA.

CThe value of the DB_CACHE_SIZE parameter should not be 16 KB.

DThe DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE.

EThe DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB.

Show Suggested Answer

Suggested Answer: B

by Norah at Dec 26, 2022, 03:13 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!