SQL Interview Questions #32: How avoid accidental deletion?

SQL code copied to buffer

Group tasks by:

complexity

category

database

Task 32:

How can you know in advance which records will be deleted when performing DELETE?

Replace DELETE with SELECT *, because otherwise the DELETE syntax is similar to the syntax of a simple SELECT.

Make DELETE with LIMIT 1: one record is not a pity.

Why in advance? Just call it and see what records are missing.

SQL is created to store data, it cannot be deleted.

Mark all correct answers and click the "Check!" button

SQL in 10 Minutes a Day by Ben Forta

SQL in 10 Minutes a Day by Ben Forta

Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.