Enrol to start learning
Reading is open to everyone. Enrolling is free, and it is what unlocks the audio lessons, practice tests and progress tracking.
12.5. Safety Tips for QA When Using SQL
This section
Practice test
10 questions on this section. Wrong answers show you what to read again.
Sign up to take itWhole chapter
Revision test
Mixed questions from across the chapter. Your answers get marked.
Sign up to take itQuick
Flashcard drill
2 cards from this lesson. Good the night before a test.
Try these first
- 1.
What SQL command should you use to view data without changing it?
Hint
Think about the command that retrieves data.
- 2.
Why is it important not to run DELETE on production databases?
Hint
Consider the consequences of deleting existing data.
- 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.
True or False: It's safe to perform destructive queries directly on production databases.
- True
- False
Hint
Think about the risks involved.
- 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.
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?
Exercises
Total Questions
2
Estimated Time
4 min
Passing Score
70%
Instructions
- Read each question carefully
- You can use hints if you need help
- Complete all questions before submitting
4 more questions available
Enrol freeQuiz
Total Questions
2
Estimated Time
4 min
Passing Score
70%
Instructions
- Read each question carefully
- You can use hints if you need help
- Complete all questions before submitting
Get your answers marked and your progress tracked
Enrol freeChallenge Problems
Total Questions
2
Estimated Time
4 min
Passing Score
70%
Instructions
- Read each question carefully
- You can use hints if you need help
- Complete all questions before submitting