Managing Tablespaces - Oracle placement test

Managing Tablespaces - Oracle placement test

1) Using multiple tablespaces allows you more flexibility in performing database operations, when a database has multiple tablespaces, you can?

A) Separate user data from data dictionary data to increase I/O contention
B) Store different the datafiles of different tablespaces on different disk drives to reduce I/O contention
C) Take individual tablespaces offline while others remain online, providing better overall availability
D) Both B & C
E) None of the bove
View Answer / Hide Answer


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

A) CREATE TABLESPACE
B) CREATE TEMPORARY TABLESPACE
C) CREATE UNDO TABLESPACE
D) Both A & B
View Answer / Hide Answer


3) The DBMS_SPACE_ADMIN package provides maintenance procedures for locally managed tablespaces?

A) True
B) False
View Answer / Hide Answer


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

A) True
B) False
View Answer / Hide Answer


5) In Diagnosing and Repairing Locally Managed Tablespace Problems which migrates a locally managed tablespace to dictionary-managed?

A) TABLESPACE_MIGRATE_TO_LOCAL
B) TABLESPACE_REBUILD_QUOTAS
C) TABLESPACE_MIGRATE_FROM_LOCAL
D) TABLESPACE_VERIFY
View Answer / Hide Answer


6) 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_REBUILD_QUOTAS
B) TABLESPACE_REBUILD_BITMAPS
C) TABLESPACE_VERIFY
D) None of the above
View Answer / Hide Answer


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

A) EXP
B) IMP
C) Both A & B
D) None of the above
View Answer / Hide Answer


8) Transporting tablespaces with XMLTypes has the following additional limitations?

A) Advanced Queues
B) SYSTEM Tablespace Objects
C) Opaque Types
D) Floating-Point Numbers
E) All the mentioned above
View Answer / Hide Answer


9) 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) Data Pump
B) EXP
C) IMP
D) Both A & B
View Answer / Hide Answer


10) Which parameter specifies the exported file containing the metadata for the tablespaces to be imported?

A) TRANSPORT_DATAFILES
B) DUMPFILE
C) DIRECTORY
D) REMAP_SCHEMA
View Answer / Hide Answer


11) Which parameter if not specified all database objects are created in the same user schema as in the source database, and those users must already exist in the target database?

A) TRANSPORT_DATAFILES
B) DUMPFILE
C) DIRECTORY
D) REMAP_SCHEMA
View Answer / Hide Answer


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

A) DBA_TABLESPACE_GROUPS
B) V$TABLESPACE
C) V$DATAFILE
D) DBA_EXTENDS,USER_EXTENDS
View Answer / Hide Answer


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

A) V$TEMP_EXTENT_POOL
B) V$TEMP_EXTENT_MAP
C) V$TEMPSEG_USAGE
D) V$TEMP_SPACE_HEADER
View Answer / Hide Answer


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

A) True
B) False
View Answer / Hide Answer