What is the role of data definition language in DBMS?

Question 2Answer

a.
To provide backup and recovery of data in the database

b.
To define the data as it appears in the database before it is translated into the forms required by application programs

c.
To extract data from the database to satisfy information requests and develop applications

d.
To define the structure of the database

1 answer

d. To define the structure of the database

Data Definition Language (DDL) in DBMS is used to define the structure of the database such as defining tables, views, indexes, constraints, etc. It allows users to create, modify, and delete database objects and their attributes. It is used to specify the data types, relationships, and other constraints that should be applied to the data in the database.