RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
Managing DB Objects
Oracle Space Management
Managing Oracle Tables
Managing Oracle Constraints
Oracle Indexes
Table Space Fragmentation -Quiz
Select the best answer or answers for each question.
1.
Which SQL command can be used to reduce the holes in a tablespace caused by different sized extents?
Please select the best answer.
A.
ALTER TABLESPACE tablespace_name COMPRESS
B.
ALTER TABLESPACE tablespace_name COALESCE
C.
ALTER TABLESPACE tablespace_name COALESCE PCTFREE 20 PCTUSED 60
D.
ALTER TABLESPACE COALESCE
2.
What are the effects of tablespace fragmentation?
Please select all the correct answers.
A.
Rows in the tablespace are different sizes.
B.
Extents in the tablespace are different sizes.
C.
Disk space in the tablespace is wasted.
D.
I/O performance is slower.
3.
How can you avoid tablespace fragmentation?
Please select the best answer.
A.
Frequently
COALESCE
the tablespace
B.
Use large extent sizes for the tablespace
C.
Use small extent sizes for the tablespace
D.
Use one extent size for all the extents in the tablespace
