12.5. Safety Tips for QA When Using SQL

Try these first

1. 1.

   What SQL command should you use to view data without changing it?

   Hint

   Think about the command that retrieves data.

2. 2.

   Why is it important not to run DELETE on production databases?

   Hint

   Consider the consequences of deleting existing data.

3. 3.

   What is a general safety practice before executing DELETE?

   • Run SELECT first
   • Execute immediately
   • Ask a colleague

   Hint

   Consider steps to confirm your action!

4. 4.

   True or False: It's safe to perform destructive queries directly on production databases.

   • True
   • False

   Hint

   Think about the risks involved.

5. 5.

   Analyze a situation where a QA analyst executed a DELETE without testing. What could have been the repercussions?

   Hint

   Think of the critical roles that stored records play.

6. 6.

   Create an example of a complex JOIN that demonstrates why proper conditions are needed to avoid performance hits.

   Hint

   What happens when untamed queries lead to floods of data?