> > Oracle MCQs > Managing Tablespaces MCQs

Managing Tablespaces MCQ

A set of bitmap blocks has media corruption which tasks call the procedure, either on all bitmap blocks, or on a single block if only one is corrupt?

TABLESPACE_VERIFY

None

TABLESPACE_REBUILD_BITMAPS

TABLESPACE_REBUILD_QUOTAS

Answer

Correct Answer: TABLESPACE_REBUILD_BITMAPS

Note: This Question is unanswered, help us to find answer for this one

In Viewing Tablespace Information which view gives Information for all extents in all locally managed temporary tablespaces?

V$TEMP_SPACE_HEADER

V$TEMP_EXTENT_MAP

V$TEMPSEG_USAGE

V$TEMP_EXTENT_POOL

Answer

Correct Answer: V$TEMP_EXTENT_MAP

Note: This Question is unanswered, help us to find answer for this one

A transportable tablespace set consists of datafiles for the set of tablespaces being transported and an export file containing structural information (metadata) for the set of tablespaces we use?

EXP

Data Pump

Data Pump And EXP

IMP

Answer

Correct Answer: Data Pump And EXP

Note: This Question is unanswered, help us to find answer for this one

You can use transportable tablespaces to perform tablespace point-in-time recovery (TSPITR)?

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

To create a new tablespace, we use the SQL statement?

CREATE TEMPORARY TABLESPACE

CREATE TABLESPACE And CREATE TEMPORARY TABLESPACE

CREATE TABLESPACE

CREATE UNDO TABLESPACE

Answer

Correct Answer: CREATE TABLESPACE And CREATE TEMPORARY TABLESPACE

Note: This Question is unanswered, help us to find answer for this one

Transporting tablespaces with XMLTypes has the following additional limitations?

All

Advanced Queues And Floating-Point Numbers

SYSTEM Tablespace Objects

Opaque Types

Answer

Correct Answer: All

Note: This Question is unanswered, help us to find answer for this one

Which utility ensure that the CONSTRAINTS and TRIGGERS parameters are set to Y the default?

IMP

None

IMP And EXP

EXP

Answer

Correct Answer: None

Note: This Question is unanswered, help us to find answer for this one

In Viewing Tablespace Information which view shows the Name and number of all tablespaces from the control file?

DBA_EXTENDS,USER_EXTENDS

DBA_TABLESPACE_GROUPS

V$DATAFILE

V$TABLESPACE

Answer

Correct Answer: V$TABLESPACE

Note: This Question is unanswered, help us to find answer for this one

The DBMS_SPACE_ADMIN package provides maintenance procedures for locally managed tablespaces?

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

AUTOALLOCATE causes the tablespace to be system managed with a minimum extent size of 6K?

True

False

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one