Examine the parameters set for your database instance:
You are asked by a developer to create a table for an application with these requirements:
The table will be used for a DSS application.
High volume bulk loads will be performed.
The table will be used to store archival data on which large full-table scans (FTS) will be performed.
Which attributes are the best for the tablespace in which this table should be created? (Choose the best
answer.)
A.
Create it in a locally managed tablespace with ASSM enabled and assign a high value for the PCTFREE
attribute.
B.
Create it in a locally managed tablespace with manual segment space management.
C.
Create it in a locally managed tablespace with a bigger nonstandard block size and ASSM enabled.
D.
Create it in locally managed tablespace with ASSM enabled and an additional freelist.