Managing Tablespaces MCQs
Managing Tablespaces MCQs
Our experts have gathered these Managing Tablespaces MCQs through research, and we hope that you will be able to see how much knowledge base you have for the subject of Managing Tablespaces by answering these multiple-choice questions.
Get started now by scrolling down!
1: AUTOALLOCATE causes the tablespace to be system managed with a minimum extent size of 6K?
A. True
B. False
2: The DBMS_SPACE_ADMIN package provides maintenance procedures for locally managed tablespaces?
A. False
B. True
3: In Viewing Tablespace Information which view shows the Name and number of all tablespaces from the control file?
A. DBA_EXTENDS,USER_EXTENDS
B. DBA_TABLESPACE_GROUPS
C. V$DATAFILE
D. V$TABLESPACE
4: Which utility ensure that the CONSTRAINTS and TRIGGERS parameters are set to Y the default?
A. IMP
B. None
C. IMP And EXP
D. EXP
5: Transporting tablespaces with XMLTypes has the following additional limitations?
A. All
B. Advanced Queues And Floating-Point Numbers
C. SYSTEM Tablespace Objects
D. Opaque Types
6: To create a new tablespace, we use the SQL statement?
A. CREATE TEMPORARY TABLESPACE
B. CREATE TABLESPACE And CREATE TEMPORARY TABLESPACE
C. CREATE TABLESPACE
D. CREATE UNDO TABLESPACE
7: You can use transportable tablespaces to perform tablespace point-in-time recovery (TSPITR)?
A. True
B. False
8: 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?
A. EXP
B. Data Pump
C. Data Pump And EXP
D. IMP
9: In Viewing Tablespace Information which view gives Information for all extents in all locally managed temporary tablespaces?
A. V$TEMP_SPACE_HEADER
B. V$TEMP_EXTENT_MAP
C. V$TEMPSEG_USAGE
D. V$TEMP_EXTENT_POOL
10: 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?
A. TABLESPACE_VERIFY
B. None
C. TABLESPACE_REBUILD_BITMAPS
D. TABLESPACE_REBUILD_QUOTAS
List of Managing Tablespaces M...
Available in:
Managing Tablespaces MCQs
