C# Mastery Hub
Home
Challenges
Discussion
Lessons
Core Topics
C# Fundamentals
Console Applications
Classes & OOP
Windows Forms
ASP.NET Core
SQL Server
VS & SQL Connection
RDLC Reports
.NET MAUI
Getting Started
Getting Started
Website Development
SEO Guide
Security
Project Workflow
Extra Topics
Cloud & Deployment
AWS Cloud
Deployment
About
Contact
Test Your Knowledge
SQL Server - Lesson 6: INSERT, UPDATE, DELETE Quiz
Answer all questions to test your understanding
1
What does INSERT do?
Adds new rows to a table
Modifies existing rows
Removes rows from a table
Creates a new table
2
What does UPDATE do?
Modifies existing rows
Adds new rows
Removes rows
Creates a new table
3
What does DELETE do?
Removes rows from a table
Adds new rows
Modifies existing rows
Creates a new table
4
What is the most important rule for UPDATE and DELETE?
Always use a WHERE clause
Always use ORDER BY
Always use SELECT first
Always use JOIN
5
How can you safely test a DELETE statement?
Run SELECT with the same WHERE clause first
Run the DELETE and hope for the best
Use a transaction
Backup the database
Submit Quiz