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



Leave a Reply 0

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