Computer Science
Answer
All of these
Reason — DDL (Data Definition Language) commands are used to create and define tables and other database objects in SQL (Structured Query Language). DDL commands such as CREATE, ALTER, and DROP, are used to create, define, change and delete objects like tables, indexes, views, and constraints.
Related Questions
Consider the following SQL statement. What type of statement is this ?
INSERT INTO instructor VALUES (10211, 'Shreya' , 'Biology', 66000 ) ;- Procedure
- DML
- DCL
- DDL
In the given query which keyword has to be inserted ?
INSERT INTO employee ............... (1002, Kausar, 2000) ;- Table
- Values
- Relation
- Field
In SQL, which command(s) is(are) used to change a table's structure / characteristics ?
- ALTER TABLE
- MODIFY TABLE
- CHANGE TABLE
- All of these
Which of the following commands will delete the table from MYSQL database ?
- DELETE TABLE
- DROP TABLE
- REMOVE TABLE
- ALTER TABLE