nerdexam
Oracle

1Z0-064 · Question #11

1Z0-064 Question #11: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #11. The question stem and answer options stay visible for context.

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

Exhibit

1Z0-064 question #11 exhibit

Options

  • ACreate it in a locally managed tablespace with ASSM enabled and assign a high value for the
  • BCreate it in a locally managed tablespace with manual segment space management.
  • CCreate it in a locally managed tablespace with a bigger nonstandard block size and ASSM
  • DCreate it in locally managed tablespace with ASSM enabled and an additional freelist.

Unlock 1Z0-064 to see the answer

You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-064 Practice