You must create a tablespace of nonstandard block size in a new file system and...

Vendor: Oracle
Product: 1z0-182
Update on: Jul 21, 2025
Questions: 94

Oracle 1z0-182 Question Answer

You must create a tablespace of nonstandard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE '/u02/oracle/data/nstbs_f01.dbf' SIZE 100G BLOCKSIZE 32K; The standard block size is 8K, but other nonstandard block sizes will also be used. Which two are requirements for this command to succeed?

DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.

The operating system must use a 32K block size.

DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.

The /u02 file system must have at least 100G space for the datafile.