Database Administration · Unit 4
Tablespace and Storage Management
Exam-focused notes for Tablespace and Storage Management (Database Administration, BIT352): what the TU syllabus asks and how it has actually been tested, with 6 solved past questions from this unit.
What this unit covers
- Tablespace concepts and types
- Datafile management and creation
- Adding new tablespaces and datafiles
- UNDO tablespace and UNDO RETENTION policy
- Viewing and altering UNDO RETENTION
- Space management and segment creation
- Extent and row chaining concepts
- Row migration in storage
Space management and segment creation
What is space management? How space management is done? How can you create tables without segments?[10]
Space management refers to the process of efficiently allocating, monitoring, and reclaiming storage space within a database. It involves managing how data is stored in segments, extents, and data blocks to ensure optimal use of physical disk space and to a...
Full solved answer →Adding new tablespaces and datafiles
What is tablespace and datafile in oracle? How can we add new tablespace and datafiles in oracle database? [5]
A tablespace is a logical storage unit in an Oracle database that groups related logical structures (tables, indexes, etc.) together. It is the bridge between the physical and logical components of an Oracle database. Every Oracle database has at least one ...
Full solved answer →What is tablespace and datafile in oracle? How we can add new tablespace and datafiles in oracle database? [5]
A tablespace is the logical storage unit in an Oracle database. It is a logical grouping of one or more datafiles that stores database objects such as tables, indexes, and other schema objects. Every Oracle database has at least one tablespace called the SY...
Full solved answer →UNDO tablespace and UNDO RETENTION policy
What is Tablespace? What is UNDO RETENTION Policy? Write different commands to manage the tablespaces in Oracle.[10]
Note: The reference notes did not contain material on this topic. The following answer is based on standard Oracle Database concepts as taught in TU BSc CSIT Database Administration curriculum. --- A Tablespace is the logical storage unit in an Oracle datab...
Full solved answer →What is UNDO tablespace and UNDO RETENTION policy? How to view and alter UNDO RETENTION Policy in oracle. [5]
An UNDO tablespace is a special type of tablespace in Oracle Database used to store undo data (also called rollback data). When a transaction modifies data, Oracle saves the before-image of the data in the undo tablespace so that: - Transaction Rollback - U...
Full solved answer →Extent and row chaining concepts
What is Extent? Explain Row chaining and Migration in brief. [5]
An extent is a contiguous set (group) of data blocks allocated to a segment (such as a table or index) within a tablespace in Oracle database storage. When a segment needs more space, the database allocates a new extent. An extent is the next level of logic...
Full solved answer →Make Unit 4 stick
Practice BIT352 with flashcards & quizzes