What is the primary purpose of database test scripting?
- Automating test execution
- Generating test data
- Identifying bugs
- Validating data integrity
In database testing, the primary purpose of test scripting is to automate the execution of tests. Test scripts are written to perform specific actions on the database and verify the expected outcomes. Automating tests helps in improving efficiency, reducing human errors, and ensuring consistency in testing processes.
SQL ____________ is a technique that prevents SQL injection attacks by escaping special characters.
- Normalization
- Parameterization
- Sanitization
- Validation
Parameterization involves using parameterized queries to separate SQL code from user input. This technique helps prevent SQL injection attacks by automatically escaping special characters.
In ETL testing, the process of transforming data from source to target is known as ____________.
- Extraction
- Loading
- Migration
- Transformation
Transformation is the stage in ETL (Extract, Transform, Load) process where data is converted or modified according to business rules and requirements before loading it into the target system.