Worksheets22IT4252-DBMS-1
Total questions: 20
Worksheet time: 20mins
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
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
Which SQL command is used to insert new records into a table?
UPDATE
CREATE
INSERT
ADD
What does the INSERT statement do in SQL?
To define and manage the structure of the database
To modify the structure of an existing table
To retrieve data from the database
To add new records to a table
What does the UPDATE statement do in SQL?
Adds new records to a table
Updates existing records in a table
Retrieves data from the database
Deletes data from a table
What does the SELECT statement do in SQL?
Retrieves data from the database
Defines and manages the structure of the database
Adds new records to a table
Modifies the structure of an existing table
Which SQL command is used to fetch data from the database?
SELECT
INSERT
UPDATE
DELETE
Which SQL command is used to fetch all records from a table?
SELECT *
RETRIEVE
GET
INSERT
What is the main goal of using the SELECT statement in SQL?
To retrieve data from the database
To organize and manage the database structure
To insert new records into a table
To alter the structure of an existing table
Which SQL command is used to add a new column to an existing table?
UPDATE TABLE
INSERT COLUMN
CREATE TABLE
ADD COLUMN
What is the main purpose of using the UPDATE statement in SQL?
To insert new data into a table
To modify existing data in a table
To fetch data from the database
To remove data from a table
