WorksheetsSQL Data Manipulation Quiz
Total questions: 10
Worksheet time: 5mins
What does DML stand for?
Data Manipulation Language
Data Management Language
Data Model Language
What are the three core statements of DML?
INSERT, UPDATE, DELETE
SELECT, INSERT, DELETE
UPDATE, DELETE, CREATE
What is the purpose of the INSERT statement?
To add new records to a database table
To modify existing data
To remove unwanted records
What does the UPDATE statement do?
Modifies existing data within a table
Adds new records
Removes records
What is the purpose of the DELETE statement?
To remove unwanted records from a table
To modify existing data
To add new records
What is a NULL value in a database?
Represents missing information
Represents a zero value
Represents a default value
What is the ISNULL function used for?
To replace NULL values with a placeholder
To check for NULL values
To count NULL values
What are Check Constraints used for?
To enforce specific data formats or ranges
To delete unwanted records
To update existing data
What is a key security consideration for DML?
User Permissions
Data Redundancy
Data Backup
What is the purpose of parameterized queries?
To prevent SQL injection attacks
To speed up data retrieval
To simplify SQL syntax
