NEW
Font size
WorksheetsDAY 17 - MySQL Commands: DDL, DML, TCL (2nd July 2024)
Total questions: 15
Worksheet time: 8mins
Which of the following is a DDL command in SQL?
SELECT
INSERT
CREATE
UPDATE
What does DML stand for in SQL?
Data Modification Language
Data Manipulation Language
Data Management Language
Data Mining Language
Which of the following commands is used to delete a table in
SQL?
DELETE
DROP
REMOVE
ERASE
Which command is used to insert new data into a table?
ADD
INSERT
UPDATE
APPEND
Which command is used to change the structure of a table?
ALTER
MODIFY
CHANGE
UPDATE
Which of the following commands is used to save all changes
made during the current transaction?
SAVE
APPLY
COMMIT
EXECUTE
Which command removes all rows from a table without
logging the individual row deletions?
DELETE
ERASE
CLEAR
TRUNCATE
Which command is used to undo transactions that have not
yet been saved to the database?
UNDO
REVERT
ROLLBACK
CANCEL
Which DML command is used to modify existing records in a
table?
CHANGE
UPDATE
MODIFY
ALTER
Which of the following commands is a TCL command?
SELECT
COMMIT
DELETE
CREATE
Which command is used to remove rows from a table
based on a condition?
DELETE
REMOVE
DROP
TRUNCATE
What does the SQL command GRANT do?
Removes user privileges
Creates a new user
Modifies table structure
Gives user access privileges to the database
Which command is used to permanently remove a table
from a database?
DELETE
ERASE
DROP
TRUNCATE
Which DML command is used to retrieve data from a
database?
SELECT
FETCH
GET
RETRIEVE
Which of the following commands can be used to
rename a table?
RENAME TABLE
MODIFY TABLE
CHANGE TABLE
ALTER TABLE
