Which of the following best describes the purpose of the CREATE statement in…
2025
Which of the following best describes the purpose of the CREATE statement in the Data Definition Language (DDL) subset of SQL?
- A.
It retrieves data from one or more database tables.
- B.
It defines a new structure, such as a table or a view, in the database.
- C.
It modifies the contents of an existing table.
- D.
It removes specific records based on a given condition.
Attempted by 137 students.
Show answer & explanation
Correct answer: B
The CREATE statement is used to allocate physical and logical space within a database system by building new database architecture from scratch. When you run a CREATE command, you are telling the Database Management System (DBMS) to set up a blueprint.