Question

1. Which of the following database functions would be performed using a Data Definition Language (DDL)?

		Creating a new table in a database
		Retrieving data from a database
		Updating data in a database
		Inserting new data into a database

Answer 1

Answer: Creating a new table in a database,

Data Definition Language (DDL):

SQL can be categorized into 4 categories :

1. DDL – Data Definition Language
2. DQl – Data Query Language
3. DML – Data Manipulation Language
4. DCL – Data Control Language

Data Definition Language consists of SQL commands that can be used to define the data schema. It is used to create and modify the structure of database objects.

DDL consists of the following commands:

1. Create (Create the database or its objects )
2. Drop (Delete objects from database)
3. Alter (Alter the structure of the database)
4. Truncate (Remove all records from database as well as the space allocated )
5. Comment (Add comments to the data dictionary)
6. Rename (Rename an existing object )