Which command would be used to add a record under specific criteria?

Disable ads (and more) with a premium pass for a one time $4.99 payment

Prepare for the OCR GCSE Computer Science Paper 2 exam. Practice with diverse questions, flashcards, and detailed explanations. Boost your confidence and ace your test!

The command used to add a record under specific criteria in a database is the "INSERT INTO" command. This SQL command is specifically designed to insert new records into a database table. When using "INSERT INTO," you specify the target table and the values for the fields you want to populate, effectively creating a new entry based on the specified criteria.

For example, if you have a table for storing user information, using the "INSERT INTO" command allows you to add a new user with defined attributes, such as name, email, and age. This operation is fundamental in creating and managing data within relational databases, providing a way to expand data sets according to the requirements of the application.

The other commands serve different purposes: "UPDATE" modifies existing records, "SELECT" retrieves data from a database without altering the data, and "DELETE" removes records from a table. Each of these commands plays a crucial role in database management but does not pertain to the action of adding new records.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy