>>>PREVIOUS>>>




Question Database



Q1) what is a data dictionary?

A data dictionary is a centralized storage location for information about the data that is stored in a database. This information is often called “metadata” (data about data).

A data dictionary provides answers to questions


such as:


* What data is contained in the database?

* What are the attributes of this data: name, length, format, etc.?

* What relationships exist among different data objects?



Q2) what is SAP’s data dictionary?


SAP’s data dictionary is called the ABAP Dictionary.


The ABAP Dictionary:


– Enforces data integrity

– Manages data definitions without redundancy

– Is tightly integrated with the rest of the ABAP Workbench



Q3) what is database utility?


The database utility provides the interface between the ABAP Dictionary and the underlying database management system (DBMS). It supports the creation of tables and secondary indices in the database both online and in the background.

Whenever you make a change to a dictionary object that affects the underlying database, the database utility is activated. Usually it works silently behind the scenes, but occasionally the database utility will prompt you for information. This occurs when an error is encountered or when existing data must be converted.

The database utility provides the interface to the DBMS by automatically generating the Data Definition Language (DDL) that the DBMS understands.



Q4) what is a data element?


A data element provides a meaningful description for a field. You will hear it called a semantic domain. The data element description appears beside a field in a table definition. These descriptions are language-dependent.


>>>NEXT>>>