Ace the 2026 OCR GCSE Computer Science Challenge – Code Your Way to Success!

Question: 1 / 400

Which SQL command is used to add data to an existing table?

UPDATE

INSERT INTO

The command used to add data to an existing table in SQL is "INSERT INTO." This command allows you to insert new records into the specified table. When using "INSERT INTO," you typically provide the name of the table and the values you want to add for each of the columns. This is essential for populating a database with new entries, enabling the storage of large amounts of information in structured formats.

In contrast, the other commands serve different purposes. "UPDATE" is utilized for modifying existing records within a table, not for adding new ones. "CREATE TABLE" is meant for creating a new table from scratch, establishing the structure for storing data. "SELECT" is primarily used to retrieve data from a database, allowing users to view records within the table but not to add new data to it. Understanding the specific functions of these commands helps in effectively managing and manipulating data in relational databases.

Get further explanation with Examzify DeepDiveBeta

CREATE TABLE

SELECT

Next Question

Report this question

Download Oxford, Cambridge and RSA (OCR) GCSE Computer Science Practice Exam PDF Study Guide
Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy