WorksheetsMastering SQL DDL and DML Commands
Total questions: 15
Worksheet time: 8mins
What SQL command is used to create a new table?
INSERT TABLE
MODIFY TABLE
ADD TABLE
CREATE TABLE
How do you add a new column to an existing table?
CREATE TABLE table_name ADD column_name data_type;
UPDATE table_name SET column_name = value;
ALTER TABLE table_name ADD COLUMN column_name data_type;
INSERT INTO table_name (column_name) VALUES (value);
What command would you use to remove a table from a database?
DELETE TABLE table_name;
CLEAR TABLE table_name;
DROP TABLE table_name;
REMOVE TABLE table_name;
Which SQL statement is used to insert new data into a table?
INSERT INTO
DELETE FROM
UPDATE
SELECT * FROM
How can you update existing records in a table?
Create a new table with the updated records.
Use the SQL SELECT statement to retrieve records.
Delete the records using the SQL DELETE statement.
Use the SQL UPDATE statement with SET and WHERE clauses.
What is the SQL command to delete records from a table?
DELETE FROM table_name WHERE condition;
REMOVE FROM table_name WHERE condition;
DELETE table_name WHERE condition;
DROP table_name WHERE condition;
How can you rename an existing column?
ALTER TABLE table_name RENAME COLUMN column_name;
ALTER COLUMN table_name RENAME column_name;
sp_name 'column_name', 'new_name';
sp_rename 'table_name.column_name', 'new_name', 'COLUMN';
How do you change the data type of a column in a table?
Change column_name data_type in the database settings;
Use ALTER COLUMN column_name SET DATA TYPE new_data_type;
Use ALTER TABLE table_name ALTER COLUMN column_name new_data_type;
Use UPDATE table_name SET column_name = new_data_type;
What command would you use to drop a column from a table?
ALTER TABLE table_name DROP COLUMN column_name;
REMOVE column_name FROM table_name;
DROP column_name IN table_name;
DELETE COLUMN column_name FROM table_name;
What is the correct syntax to insert multiple records to a database table at once?
INSERT INTO table_name (column1, column2) VALUES (value1a, value2a, value1b, value2b);
INSERT table_name (column1, column2) VALUES (value1a, value2a), (value1b, value2b);
INSERT INTO table_name (column1, column2) VALUES (value1a, value2a), (value1b, value2b), (value1c, value2c);
INSERT ONTO table_name VALUES (value1a, value2a), (value1b, value2b);
What SQL command is used to modify the structure of a table?
ALTER TABLE
SELECT * FROM
DROP TABLE
CREATE TABLE
How do you delete all records from a table without removing the table itself?
REMOVE FROM table_name;
DROP TABLE table_name;
DELETE FROM table_name;
TRUNCATE table_name;
What is the difference between DROP and TRUNCATE?
There's no difference, both DROP and TRUNCATE delete all rows from a table
DROP removes the entire table and its structure, while TRUNCATE deletes all rows but keeps the table structure intact.
TRUNCATE removes the entire table and its structure, while DROP deletes all rows but keeps the table structure intact.
There's no difference, both DROP and TRUNCATE remove the entire table
How can you update specific records based on a condition?
Use SQL UPDATE with a WHERE clause.
Use SQL INSERT with a WHERE clause.
Use SQL SELECT with a WHERE clause.
Use SQL DELETE with a WHERE clause.
What is the difference between DDL and DML commands in SQL?
DDL commands manipulate data; DML commands define structure.
DDL commands define database structure; DML commands manipulate data within that structure.
DDL commands are only for deleting data; DML commands are for updating data.
DDL commands are used for querying data; DML commands are for creating tables.
