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?
Using a file transfer protocol to replace the database file with an updated version.
Editing a spreadsheet that is used to bulk import data at a later time.
Opening the database file in a text editor and manually changing the record values.
Executing an SQL UPDATE statement through the database's command-line interface.
To perform direct updates to records in a relational database, you would typically use a command-line interface provided by the database management system, issuing specific commands such as UPDATE. This is assuming you have the necessary permissions to do so. Text editors and spreadsheets are tools for different contexts and would not be suitable for directly updating records in most database systems.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is an SQL `UPDATE` statement and why is it used?
Open an interactive chat with Bash
What is a relational database and how does it work?
Open an interactive chat with Bash
What are permissions in a database management system?