PrepAway - Latest Free Exam Questions & Answers

What type of database language is used to create, modify and delete tables?

What type of database language is used to create, modify and delete tables?

PrepAway - Latest Free Exam Questions & Answers

A.
Data Definition Language (DDL)

B.
Data Manipulation Language (DML)

C.
Database Management System (DBMS)

D.
Structured Query Language (SQL)

Explanation:
Answer A is correct; Data Definition Language (DDL) is used to create, modify and delete tables.

Incorrect Answers and Explanations: B, C, and D: Answers B, C, and D are incorrect. Data Manipulation Language (DML) is used to create, modify and delete tables. Data Manipulation Language (DML) is used to query and update data stored in the tables. Database Management System (DBMS) manages the database system and provides security features. Structured Query Language (SQL) is a database query language that includes both DDL and DML. DDL is more specific than SQL, or it is a better answer for this question.

One Comment on “What type of database language is used to create, modify and delete tables?

  1. joe says:

    Data Definition Language (DDL) is used to create, modify and delete tables.
    Data Manipulation Language (DML) is used to query and update data stored in the tables.
    SQL = DDL + DML




    0



    0

Leave a Reply