ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 21 discussion

Actual exam question from Oracle's 1z0-062
Question #: 21
Topic #: 1
[All 1z0-062 Questions]

Which two statements are true about extents? (Choose two.)

  • A. Blocks belonging to an extent can be spread across multiple data files.
  • B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.
  • C. The blocks of a newly allocated extent, although free, may have been used before.
  • D. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️
by khan at April 6, 2019, 10:34 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
khan
Highly Voted 5 years, 8 months ago
Answer BC https://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT1063 Deallocation of Extents: In general, the extents of a user segment do not return to the tablespace unless you drop the object using a DROP statement. For example, if you delete all rows in a table, then the database does not reclaim the data blocks for use by other objects in the tablespace. You can also drop the segment using the DBMS_SPACE_ADMIN package.
upvoted 8 times
...
_Cobra_
Most Recent 2 years, 7 months ago
B & C is correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago