Exam 1z0-082 All QuestionsBrowse all questions from this exam
Question 102

You must create a tablespace of non-standard block size in a new file system and plan to use this command:

The standard block size is 8k but other non-standard block sizes will also be used.

Which two are requirements for this command to succeed? (Choose two.)

    Correct Answer: B, D

    To successfully create a tablespace with a non-standard block size of 32K, two requirements must be met. First, DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the System Global Area (SGA) because memory needs to be allocated for caching the blocks of this size. Second, the /u02 file system must have at least 100GB space available for the datafile, as specified in the command, to ensure the datafile can be created without running out of space.

Discussion
Oracle2020Options: BD

B,D TRUE E-FALSE: OS block size does not have to match Oracle block size

auwiaOptions: BD

Provided answer are corrects.