Name logical unit of storage which is combination of one of more datafiles.
-
Segment
-
Block
-
Tablespace
-
View
A tablespace is the logical unit of storage in Oracle that combines one or more datafiles. Segments (A) are database objects like tables or indexes stored within a tablespace, blocks (B) are the smallest unit of data storage, and views (D) are virtual tables. Tablespaces provide a layer of abstraction between physical datafiles and logical database objects.
To answer this question, you need to understand the concept of storage in a database system.
Option A) Segment - This option is incorrect. A segment is a logical unit of storage in a database that consists of one or more extents, which in turn are made up of multiple data blocks.
Option B) Block - This option is incorrect. A block is the smallest unit of storage in a database, and it is used to store data within a datafile.
Option C) Tablespace - This option is correct. A tablespace is a logical unit of storage in a database that is made up of one or more datafiles. It is used to group related data together and provides a way to manage and allocate storage for database objects such as tables, indexes, and partitions.
Option D) View - This option is incorrect. A view is a virtual table that is derived from one or more tables or other views. It does not represent a logical unit of storage.
The correct answer is C) Tablespace. This option is correct because a tablespace is a logical unit of storage that is made up of one or more datafiles.