Oracle
1Z0-082 · Question #140
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…
The correct answer is C. db_32r_cache_si2e must be less than db_ca=he_size. D. db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size. See the full explanation below for the reasoning.
Manage Tablespaces and Datafiles
Question
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?
Options
- Ad3_32k_cache_size should be set to a value greater than db_cache_size.
- Bdb_32k_cache_size must be set to a value that can be accommodated in the SGA.
- Cdb_32r_cache_si2e must be less than db_ca=he_size.
- Ddb_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.
- EThe /u02 file system must have at least lOOg space for the datafile.
- FThe operating system must use a 32k block size.
How the community answered
(42 responses)- A12% (5)
- B7% (3)
- C74% (31)
- E5% (2)
- F2% (1)
Topics
#non-standard block size#db_32k_cache_size#SGA#tablespace creation
Community Discussion
No community discussion yet for this question.