SQL Data Manipulation Quiz

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