which this table should be created?

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.)

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Fonx

Fonx

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