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
thePCTFREEattribute.
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.
agree, C
C
C because others are more silly but… the exhibits is just here to show there is no memory allocated for any nk_cache_size => So why is it here ??
The question is missing details