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

Question

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

Accepted Answer

D. Create it in locally managed tablespace with ASSM enabled and an additional freelist.

Answer

A. Create it in a locally managed tablespace with ASSM enabled and assign a high value for the

Answer

B. Create it in a locally managed tablespace with manual segment space management.

Answer

C. Create it in a locally managed tablespace with a bigger nonstandard block size and ASSM

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…

Question

Exhibit

Options

How the community answered

Community Discussion