FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A Data Dictionary is an integral part of a database. It holds the information about the database and the data that it stores called as metadata. A meta data is the data about the data. It is the self-describing nature of databases.

Detailed explanation-2: -Data Dictionary in DBMS provides additional information about relationships between multiple database tables, helps to organize data, and prevents data redundancy in DBMS. A data dictionary is a set of files that contain a database’s metadata. Thus, it is also known as a metadata repository.

Detailed explanation-3: -Data dictionaries store and communicate metadata about data in a database, a system, or data used by applications. A useful introduction to data dictionaries is provided in this video. Data dictionary contents can vary but typically include some or all of the following: A listing of data objects (names and definitions)

Detailed explanation-4: -All the data dictionary tables and views for a given database are stored in that database’s SYSTEM tablespace.

Detailed explanation-5: -A dictionary is a general-purpose data structure for storing a group of objects. • A dictionary has a set of keys and each key has a single associated value. • When presented with a key the dictionary will • A dictionary has a set of keys and each key has a single associated value.