1Z0-082 - Oracle Database Administration I Managing Storage Structures Questions and Answers

Question 1

A database administrator is creating a new tablespace for a large-scale data warehousing application that will store terabytes of data.
To simplify file management and support extremely large data volumes within a single file, which type of tablespace should be created?

Accepted Answer

Bigfile tablespace

Answer

Smallfile tablespace

Answer

Undo tablespace

Answer

Temporary tablespace

Question 2

Which of the following represents the correct hierarchy of logical storage structures in an Oracle database, from smallest to largest unit?

Accepted Answer

Data Block, Extent, Segment, Tablespace

Answer

Extent, Data Block, Segment, Tablespace

Answer

Data Block, Segment, Extent, Tablespace

Answer

Segment, Extent, Data Block, Tablespace

Question 3

A DBA is creating a new locally managed tablespace and wants to simplify space management within segments by letting Oracle manage free and used space automatically using bitmaps. Which clause should be included in the `CREATE TABLESPACE` statement?

Accepted Answer

SEGMENT SPACE MANAGEMENT AUTO

Answer

SEGMENT SPACE MANAGEMENT MANUAL

Answer

EXTENT MANAGEMENT DICTIONARY

Answer

EXTENT MANAGEMENT AUTO

Question 4

You are tasked with reclaiming fragmented free space within a table's segment to improve the performance of full table scans. The space is currently below the high water mark (HWM). Which Oracle feature must be used to accomplish this online?

Accepted Answer

Online Segment Shrink

Answer

ALTER TABLE ... DEALLOCATE UNUSED

Answer

Resumable Space Allocation

Answer

Data Pump Export/Import

Question 5

An extent is a logical unit of database storage allocation. Which of the following statements is true regarding extents?

Accepted Answer

An extent is allocated to a segment, and all extents for a segment must be in the same tablespace.

Answer

An extent can contain data from multiple data files.

Answer

An extent is made up of a number of non-contiguous data blocks.

Answer

A segment can only have one extent.

Question 6

What is the primary content of the Row Directory section within an Oracle data block header?

Accepted Answer

Address information for each row piece stored in that block.

Answer

The actual row data, including all column values.

Answer

A bitmap indicating the free space within the block.

Answer

Information about the tables that have rows stored in the block.

A database administrator is creating a new tablespace for a large-scale data warehousing application that will store terabytes of data.To simplify file management and support extremely large data volumes within a single file, which type of tablespace should be created?

A database administrator is creating a new tablespace for a large-scale data warehousing application that will store terabytes of data.
To simplify file management and support extremely large data volumes within a single file, which type of tablespace should be created?