> > Oracle MCQs > Managing Tablespaces MCQs

Managing Tablespaces MCQ

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

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

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

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

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

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

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

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

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

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

Oracle MCQs | Topic-wise

MCQ on Basic Oracle	MCQ on Managing Archived Redo Logs
MCQ on Managing Clusters	MCQ on Managing Control Files
MCQ on Managing Data-files And Temp-files	MCQ on Managing Hash Clusters
MCQ on Managing Indexes	MCQ on Managing Oracle Database Processes
MCQ on Managing Oracle Distributed Transactions	MCQ on Managing Partitioned Tables And Indexes
MCQ on Managing Space For Schema Objects	MCQ on Managing Tables
MCQ on Managing Tablespaces	MCQ on Managing The Redo Log
MCQ on Managing The Undo Tablespace	MCQ on Managing Views, Sequences, And Synonyms
MCQ on Oracle Distributed Transactions Concepts	MCQ on Oracle WebLogic
General Oracle MCQs