Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 27 of 79

Table Creation and Data Manipulation Commands — Question 1

Back to all questions
1
Question

Question 1

Consider the following SQL statement. What type of statement is this ?

CREATE TABLE employee (name VARCHAR, id INTEGER)
  1. DML
  2. DDL
  3. DCL
  4. Integrity constraint
Answer

DDL

Reason — The SQL statement CREATE TABLE employee (name VARCHAR, id INTEGER) is a Data Definition Language (DDL) statement. DDL statements are used to define, modify, and delete database objects such as tables, views, indexes, etc. In this case, the statement is creating a new table named employee with columns, name of type VARCHAR and id of type INTEGER.