The "defect trend report" provides insights into the stability of a software application by tracking defects over time. This report helps stakeholders understand how the number and severity of defects change throughout the testing process and after releases. By analyzing the trends in defect occurrence and resolution, teams can identify patterns, assess the effectiveness of their testing efforts, and make informed decisions to improve product quality.

Data validation in ETL testing primarily aims at ensuring accuracy by verifying that the data is correctly transformed and loaded into the target system.

Data Consistency Testing involves verifying the integrity, accuracy, and consistency of data in the database. It checks for anomalies such as duplicate records, missing data, or inconsistent values, making it suitable for identifying and resolving issues like duplicate orders in the order history.

Spike Testing is a type of scalability testing that evaluates how a system handles sudden spikes or surges in traffic. Unlike gradual increases in load, spike testing specifically focuses on abrupt changes, simulating real-world scenarios such as flash sales or breaking news events. Conducting spike testing helps identify potential bottlenecks and weaknesses in the system under extreme conditions, allowing for better preparedness and optimization before such events occur.

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.

Parameterization involves using parameterized queries to separate SQL code from user input. This technique helps prevent SQL injection attacks by automatically escaping special characters.

SQL injection attacks can lead to unauthorized user access in a database. Attackers exploit vulnerabilities in input validation to inject malicious SQL code into an application's SQL statements, which can allow them to gain unauthorized access as regular users.

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.

The first six hexadecimal characters of the MAC address are known as the Organizationally Unique Identifier (OUI) and are assigned to NIC manufacturers. These characters help identify the manufacturer of the NIC.

The primary purpose of the DNS "A" record is to resolve hostnames to IPv4 addresses. This allows your web browser to find the IP address associated with a domain name when you enter a URL, enabling you to connect to the correct web server.