answersLogoWhite

0

What is Data Dictionary in DBMS?

Updated: 10/3/2023
User Avatar

Wiki User

14y ago

Best Answer

data dictionary- Used to store schema descriptions and other information such as design decisions, application program descriptions, user information, usage standards, etc. Active data dictionary is accessed by DBMS software and users/DBA. Passive data dictionary is accessed by users/DBA only.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

9y ago

A data dictionary contains a list of all files in the database, the number of records in each file, and the names and types of each field. Data dictionaries do not contain any actual data from the database, only bookkeeping information for managing it. Without a data dictionary, however, a database management system cannot access data from the database.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is Data Dictionary in DBMS?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

16 The DBMS stores definitions of the data elements and their relationships in?

data dictionary


What does DBMS use to perform validation checks?

data dictionary


When creating database with a DBMS you must create a description of the data called?

data dictionary


What is the Componentes of dbms?

Data Definition Lenguage (DDL) Data Manipulation Lenguage (DML) Data Dictionary


Which two file are used during the operation of dbms?

data dictionary and transaction log


Use of data dictionary in a dbms?

enforcement of standards data analysis invoicing costing change improved documentation


What is data dictionary of c plus plus?

A data dictionary is structured data about data (metadata), typically employed by a DBMS, either passively (requiring manual, independant updating), or actively (automatically updated alongside and prior to DBMS updates). Data dictionarie's don't really apply to the C++ language as such, but you can model a data dictionary using C++ wherever you need structured data about data within your database programs.


What is the difference between active and passive data dictionary?

The integrated data dictionary is called active if it is checked by DBMS every time a data base is accessed. It is always consistent with actual data base structure. It is automatically maintained by the system.The integrated data dictionary is called passive if it is not used in day to day database processing.


What does an DBMS do?

DBMS is database management system and it stores data that are related. DBMS maintains data security and integrity as well.


What is the characteristics of dbms?

Basic Characteristics of DBMS• Represents complex relationship between data• Controls data redundancy.• Enforces user defined rules.• Ensures data sharing.• It has automatic and intelligent backup and recovery procedures.• It has central dictionary to store information.• Pertaining to data and its manipulation.• It has different interfaces via which user can manipulate the data.• Enforces data access authorization.


With what other computer system software does a DBMS interact?

Data Dictionary Systems (Data Repository Systems) · Information Repository Systems · Application Development Environments · Communications Software Anonymous


What are three types of dbms?

Three types of DBMS (Database Management Systems) include relational DBMS, object-oriented DBMS, and NoSQL DBMS. Relational DBMS organizes data into tables with rows and columns, object-oriented DBMS stores data as objects and classes, and NoSQL DBMS handles unstructured and semi-structured data with flexible schemas.