What is the outcome of using the DELETE command?

• A. Removes an existing row
• B. Adds a new record to the database
• C. Updates information in the database
• D. Filters the rows shown in a query

Answer: (A)

Using the DELETE command in a database context is specifically designed to remove existing rows from a table. When this command is executed, it permanently eliminates the specified records from the database, based on the condition provided in the query. This action alters the data stored within the database by eliminating the entries that match the criteria.

In contrast, other commands serve different purposes: adding a new record is accomplished through the INSERT command, updating existing information relies on the UPDATE command, and filtering displayed data in a query is achieved through the SELECT command combined with a WHERE clause. Thus, the understanding of the DELETE command’s function centers around its role in data removal, making the choice that states it removes an existing row the accurate conclusion.