Data-Dictionary Storage - DBMS

1.

A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

   A.) Segments
   B.) Tablespace
   C.) Extents
   D.) Blocks

Answer: Option 'B'

Tablespace

2.

A data dictionary is created when a __________ created.

   A.) Instance
   B.) Segment
   C.) Database
   D.) Dictionary

Answer: Option 'C'

Database

3.

A tablespace is further broken down into ________

   A.) Segments
   B.) Tablespace
   C.) Extents
   D.) Blocks

Answer: Option 'A'

Segments

4.

A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called

   A.) Catalog
   B.) Log
   C.) Metadata
   D.) Dictionary

Answer: Option 'C'

Metadata

5.

__________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.

   A.) Segment
   B.) Instance
   C.) Database
   D.) Tablespace

Answer: Option 'B'

Instance

Data-Dictionary Storage Download Pdf