Understanding DDL and DML Commands

What does DDL stand for in database management?

• Data Distribution Layer

• Data Definition Language

• Data Design Language

• Database Definition Logic

Which command is used to create a new table in SQL?

• CREATE TABLE

• INSERT TABLE

• ADD TABLE

• MODIFY TABLE

What is the purpose of the ALTER command in DDL?

• To delete an existing database object.

• To create a new database object.

• To retrieve data from a database object.

• To modify the structure of an existing database object.

Define DML and its primary function in databases.

• DML is used for creating database schemas.

• DML is used for managing data in databases, primarily for operations like inserting, updating, and deleting records.

• DML is primarily for managing user permissions.

• DML is focused on database performance optimization.

Which command would you use to insert new records into a table?

• UPDATE

• INSERT INTO

• SELECT * FROM

• DELETE FROM

What is the difference between UPDATE and INSERT in DML?

• UPDATE deletes records; INSERT modifies existing records.

• UPDATE and INSERT are the same operation.

• UPDATE modifies existing records; INSERT adds new records.

• UPDATE adds new records; INSERT removes existing records.

Explain the role of the DELETE command in DML.

• The DELETE command is used to update existing records in a database table.

• The DELETE command is used to remove records from a database table.

• The DELETE command is used to retrieve records from a database table.

• The DELETE command is used to create new records in a database table.

What does the DROP command do in DDL?

• The DROP command creates a new database object.

• The DROP command removes a database object.

• The DROP command modifies an existing database object.

• The DROP command retrieves data from a database.

Can you name a DDL command that modifies the structure of an existing table?

• SELECT TABLE

• DROP TABLE

• ALTER TABLE

• CREATE TABLE

What is the significance of the COMMIT command in DML transactions?

• The COMMIT command finalizes and saves changes made in a DML transaction.

• The COMMIT command is used to initiate a DML transaction.

• The COMMIT command undoes changes made in a DML transaction.

• The COMMIT command only applies to SELECT statements in DML transactions.