A. OMF implements an automatic file name and location option. This is done at file level and has nothing to do with how the tablespace is "managed".
B is wrong. Segment shrink operations are only available with ASSM, which in turn requires LMTBS.
C is wrong. Same feature as option B.
D is correct. AUTOEXTEND is done at file level.
E is correct. Reports are always available through the AWR and has nothing to do with tablespace management type.
A - TRUE; Release 19, Database Administrator’s Guide, 17.3.3.6 CREATE DATABASE Statement Using Oracle Managed Files: Examples
B - FALSE; Release 19, Database Administrator’s Guide, 19.3.3 Shrinking Database Segments Online; Shrink operations can be performed only on segments in locally managed tablespaces with automatic segment space management (ASSM). Within an ASSM tablespace, all segment types are eligible for online segment shrink except these: IOT mapping tables, Tables with rowid based materialized views,...
C - FALSE; see B
D - TRUE; no restriction for autoextension mentioned with DMT in Oracle documentation
E - TRUE; see D
Online segment shrink only works whit local managed tablespaces and ASMM is activated.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
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.
Ekos
Highly Voted 3 years, 1 month agobaeji
3 years agoFranky_T
Highly Voted 1 year, 8 months agonautil2
Most Recent 3 months, 2 weeks agoauwia
6 months, 1 week agoraferen10
1 year, 1 month ago