CompTIA Tech+ FC0-U71 Practice Question
You are responsible for updating inventory records after a shipment has arrived. To accurately reflect the new stock levels, what direct/manual method would you use to update the existing records in the company's relational database?
Opening the database file in a text editor and manually changing the record values.
Editing a spreadsheet that is used to bulk import data at a later time.
Using a file transfer protocol to replace the database file with an updated version.
Executing an SQL
UPDATE
statement through the database's command-line interface.