Question

Which is used to specify the structure of database?

Answer 1

Answer:   DDL

Explanation:

Data Definition Language is used to specify the structure i.e. schema of a relational database. DDL provides commands for creation, modification and deletion of various database objects like tables, views, stored procedures, indexes, constraints etc.

Answer 2

Data Definition language is used to specify the structure of database.

Definition;

Data Definition language identifies the descriptions of the database schema.

The role of Data Definition language is to creates and modifies the structure of database objects.

Uses of Data Definition Language;

1. It creates the database objects such as rows, columns, views,s indexes, and many more.
2. The main use is to build the new table with a predefined syntax.
3. It also creates and modifies the additional elements like user profile and indexes.
4. Alter the statement is another use of data language definition. Using the alter command one can add up some column in the database table.
5. By the drop data definition language one can  delete the database, table or view or remove the information one wants.
6. This database can also remove the information only in the table content but the structure of the table remains the same. It is known as the truncate command.

Hence, the data definition language are specified in the structure of database with the numerous number of commands with the different technical uses.