What is the basic building block of a data query that pulls data from a table?

What is the basic building block of a data query that pulls data from a table?

• A. SELECT Statement
• B. UPDATE Statement
• C. INSERT Statement
• D. DELETE Statement

Answer: (A)

Pulling data from a table is done with a SELECT statement. It specifies what data to return—which columns, from which table (or tables), and any conditions that filter the results. The simplest form is SELECT * FROM table, which retrieves all columns and rows from that table. The other statements are for changing data: UPDATE modifies existing rows, INSERT adds new rows, and DELETE removes rows, none of which are used to fetch data. So the building block for a data query that pulls data from a table is the SELECT statement.

Pulling data from a table is done with a SELECT statement. It specifies what data to return—which columns, from which table (or tables), and any conditions that filter the results. The simplest form is SELECT * FROM table, which retrieves all columns and rows from that table. The other statements are for changing data: UPDATE modifies existing rows, INSERT adds new rows, and DELETE removes rows, none of which are used to fetch data. So the building block for a data query that pulls data from a table is the SELECT statement.