COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data Management Language
|
|
|
Data Manupulation Language
|
|
|
Data Development Language
|
|
|
Data Definition Language
|
Detailed explanation-1: -Data Definition Language (DDL) is a subset of SQL. It is a language for describing data and its relationships in a database. You can generate DDL in a script for database objects to: Keep a snapshot of the database structure. Set up a test system where the database acts like the production system but contains no data.
Detailed explanation-2: -Data definition language (DDL) statements let you to perform these tasks: Create, alter, and drop schema objects. Grant and revoke privileges and roles. Analyze information on a table, index, or cluster.
Detailed explanation-3: -A Data Definition Language (DDL) refers to a language that is used to modify data and define data structures. For instance, the DDL commands could be used to remove, add, or modify tables within a database. The DDLs used in DB applications are considered to be a subset of the Structured Query Language.
Detailed explanation-4: -DDL is Data Definition Language which is used to define data structures. For example: create table, alter table are instructions in SQL. DML: DML is Data Manipulation Language which is used to manipulate data itself. For example: insert, update, delete are instructions in SQL.
Detailed explanation-5: -DDL stands for Data Definition Language. DML stands for Data Manipulation Language. DCL stands for Data Control Language.