List out various functions performed by DDL.
CS Professional · Information Technology and Systems Audit · PYQS · December 2017
List out various functions performed by DDL.
Answer & Explanation:
Data Description Language (DDL) is used to define the various types of data in the database and their relationship with each other. Basic functions performed by DDL are given as under:- To create tables, files, databases and data dictionaries; To specify the storage structure of each table on disk; To enforce Integrity constraints on various tables; To provide security and authorization information of each table; To specify the structure of each table; To make overall design of the Database.
Topics: Database Management
Related Questions in this Topic
- What is Data Model? Briefly explain the different types of Data base models.
- On the basis of primary job function, define various types of users in the data base system.
- Distinguish between the following: Database and Data warehouse.
- Write short notes on the following: Online Transaction Processing (OLTP).
- Write short notes on the following: Modem