0
it contains meta data
A sub system that keeps track of the definitions of all data items in the database,relationships that exits between various data structures, indexes that are used too access data quickly,screen and report format definitions that may be used by various application programs.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
16 The DBMS stores definitions of the data elements and their relationships in?
data dictionary
When creating database with a DBMS you must create a description of the data called?
data dictionary
Use of data dictionary in a dbms?
enforcement of standards data analysis invoicing costing change improved documentation
Dbms and rdbms?
DBMS and RDBMS both are used for storing data. DBMS is the database management system that refers to the collection of interrelated data. RDBMS define relation between the tables in the database
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.
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.
Dbms and rdbms?
DBMS and RDBMS both are used for storing data. DBMS is the database management system that refers to the collection of interrelated data. RDBMS define relation between the tables in the database
What is Data Dictionary in DBMS?
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.
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 are the functions of a database administrator?
data base administrator is the person who control the data in the organisation its main function to control the information of the particular enterprise1.3 Functions of a DBMSThe functions performed by a typical DBMS are the following:· Data DefinitionThe DBMS provides functions to define the structure of the data in theapplication. These include defining and modifying the record structure, thetype and size of fields and the various constraints/conditions to be satisfied bythe data in each field.· Data ManipulationOnce the data structure is defined, data needs to be inserted, modified ordeleted. The functions which perform these operations are also part of theDBMS. These function can handle planned and unplanned data manipulationneeds. Planned queries are those which form part of the application.Unplanned queries are ad-hoc queries which are performed on a need basis.· Data Security & IntegrityThe DBMS contains functions which handle the security and integrity of datain the application. These can be easily invoked by the application and hencethe application programmer need not code these functions in his/herprograms.· Data Recovery & ConcurrencyRecovery of data after a system failure and concurrent access of records bymultiple users are also handled by the DBMS.· Data Dictionary MaintenanceMaintaining the Data Dictionary which contains the data definition of theapplication is also one of the functions of a DBMS.· PerformanceOptimizing the performance of the queries is one of the important functions ofa DBMS. Hence the DBMS has a set of programs forming the Query Optimizerwhich evaluates the different implementations of a query and chooses thebest among them.Thus the DBMS provides an environment that is both convenient and efficient to usewhen there is a large volume of data and many transactions to be processed.
Define DBMS What is its primary goal?
collection of interrelated data & set of program & access those programITS GOALprimary goal of dbms is store & retrieve the database information in convenient & efficient way
