A query is the most common method used by developers to insert data into a database table. SQL (Structured Query Language) queries are written to perform actions like adding, retrieving, or updating records in the database. For example, an INSERT INTO query would add new data to a specific table.
A . Concatenation is used to combine strings or data but not for adding data to a database.
C . Loop refers to repeating actions in programming, unrelated to database inserts.
D . Macro automates tasks, but it's not specifically used for inserting data into a table.
Reference:
CompTIA IT Fundamentals (ITF+) Certification Study Guide
Official CompTIA Database Fundamentals Materials