Question

12 multiple choice 1 point in sql testing, what is the purpose of using mock data? to create a fake database for testing purposes. to replicate the production database for testing. to simulate different scenarios and test edge cases. to test the database performance under high load.

Explanation:

Mock data in SQL testing is used to simulate various scenarios and test edge cases. It helps in validating the functionality of SQL queries without relying on real - world data. Creating a fake database (first option) is not the main purpose. Replicating the production database (second option) is more about having an exact copy rather than using mock data. Testing database performance under high load (fourth option) is usually done with tools for load testing rather than mock data.

Answer:

To simulate different scenarios and test edge cases.