Name logical unit of storage which is combination of one of more datafiles.

  1. Segment

  2. Block

  3. Tablespace

  4. View


Correct Option: C

AI Explanation

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.

Find more quizzes: