Oracle
1Z0-072 · Question #20
The DATA tablespace uses Automatic Segment Space Management. Examine this query and its output: SQL> SELECT tablespace_name, pct_free FROM user_tables WHERE table_name='EMP'; TABLESPACE_NAME…
The correct answer is A. 10%. See the full explanation below for the reasoning.
Question
The DATA tablespace uses Automatic Segment Space Management.
Examine this query and its output:
SQL> SELECT tablespace_name, pct_free
FROM user_tables
WHERE table_name='EMP';
TABLESPACE_NAME PCT_FREE
DATA 10 A block in EMP is 90% full. At what percentage of free space will INSERT operations into the block again be possible?
DATA 10 A block in EMP is 90% full. At what percentage of free space will INSERT operations into the block again be possible?
Options
- A10%
- B25%
- C50%
- D75%
- E90%
How the community answered
(34 responses)- A85% (29)
- B3% (1)
- D9% (3)
- E3% (1)
Community Discussion
No community discussion yet for this question.