22IT4252-DBMS-1

Which SQL command is used to remove a specific customer's data from the customer table?

• DELETE

• UPDATE

• SELECT

• INSERT

What is the main purpose of Data Definition Language (DDL) in SQL?

• To create the ultimate blueprint of the database and determine the organization and layout of the data

• To query and modify the data stored in the database

• To define and manage the structure of the database

• To retrieve, insert, update, and delete data within the database

Which SQL command is used to add a new column to an existing table?

• UPDATE
• INSERT
• CREATE TABLE
• ADD COLUMN

What is the purpose of the CREATE TABLE statement in SQL?

• To delete data from a table
• To retrieve data from the database
• To add new records to a table
• To create a new table within the database

What's the magic SQL command to sprinkle new records into a table?

• SELECT

• INSERT

• UPDATE

• DELETE

Which SQL command is used to jazz up the structure of an existing table?

• INSERT

• UPDATE

• CREATE TABLE

• ALTER TABLE

What's the connection between DDL and DML in managing and manipulating relational databases?

• DDL is like the architect, designing and managing the structure of the database, while DML is the builder, retrieving, inserting, updating, and deleting data within the database

• DDL and DML are like two ships passing in the night, unrelated and not interacting with each other

• DDL is the master planner, defining and managing the structure of the database, while DML is the executor, retrieving, inserting, updating, and deleting data within the database

• DDL and DML are like two sides of the same coin, interchangeable and used for the same purposes

What does the DELETE statement do in SQL?

• Deletes data from a table

• Retrieves data from the database

• Adds new records to a table

• Modifies the structure of an existing table

What is the purpose of Data Manipulation Language (DML) in SQL?

• To define and manage the structure of the database
• To establish the blueprint of the database and determine the organization and layout of the data
• To retrieve, insert, update, and delete data within the database
• To create, modify, and delete database objects such as tables, indexes, views, and schemas

Which SQL command is used to insert new records into a table?

• UPDATE

• CREATE

• INSERT

• ADD