nerdexam
Microsoft

DP-900 · Question #23

Which of the following is used to create and modify the structure of database objects?

The correct answer is B. DDL (Data Definition Language). SQL is a database language used to create a database and perform certain operations on the existing database. There are four different types of SQL commands: DDL (Data Definition Language) DQL (Data Query Language) DML (Data Manipulation Language) DCL (Data Control Language)…

Submitted by obi.ng· Mar 30, 2026Describe core data concepts

Question

Which of the following is used to create and modify the structure of database objects?

Options

  • ADQL (Data Query Language)
  • BDDL (Data Definition Language)
  • CDCL (Data Control Language)
  • DDML (Data Manipulation Language)

How the community answered

(30 responses)
  • A
    7% (2)
  • B
    90% (27)
  • C
    3% (1)

Explanation

SQL is a database language used to create a database and perform certain operations on the existing database. There are four different types of SQL commands: DDL (Data Definition Language) DQL (Data Query Language) DML (Data Manipulation Language) DCL (Data Control Language) Data Definition Language (DDL) used to create and modify the structure of database objects. Option A is incorrect. Data Query Language (DQL) is used to perform queries on the data within Option B is correct. Data Definition Language (DDL) used to create and modify the structure of database objects. Option C is incorrect. Data Control Language (DCL) is used for the permissions, rights, and other controls of the database system. Option D is incorrect. Data Manipulation Language (DML) is used for the manipulation of data present in the database.

Topics

#DDL#SQL language types#database structure#data definition

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice