MCQ IN COMPUTER SCIENCE & ENGINEERING

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: -All the data dictionary tables and views for a given database are stored in that database’s SYSTEM tablespace. Not only is the data dictionary central to every Oracle database, it is an important tool for all users, from end users to application designers and database administrators.

Detailed explanation-4: -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-5: -The dictionary in data structure is an unordered collection of data items that are used to store the data in the form of key-value pairs. The dictionary data structure has an attribute called the key which helps us locate the data or value in the memory.