Oracle
1Z0-052 · Question #147
1Z0-052 Question #147: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #147. The question stem and answer options stay visible for context.
Managing Database Storage Structures
Question
You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace? (Choose two)
Options
- AThe database automatically determines the extent-sizing policy for the tablespace.
- BThe segments are automatically shrunk when the contents are removed from them.
- CThe allocation of extents within the tablespace is managed through the dictionary tables.
- DThe space utilization description of the data blocks in segments is recorded in bitmap blocks.
- EThe space utilization description of the data blocks in segments is managed through free lists.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#tablespace creation#ASSM#bitmap blocks#extent management