Oxford, Cambridge and RSA (OCR) GCSE Computer Science Practice Exam

Question: 1 / 400

Which command specifies the tables to retrieve information from in SQL?

FROM

The command used to specify the tables from which to retrieve information in SQL is the "FROM" clause. This clause is fundamental in SQL queries as it designates the source of the data being requested. When you execute a SELECT statement, the FROM clause indicates one or more tables that contain the data needed.

For example, in the statement `SELECT * FROM Customers`, "Customers" is the table from which the data is being retrieved. This command allows the database to understand exactly where to look for the information specified in the SELECT part of the query.

The other options serve different purposes in SQL statements. The WHERE clause filters records based on specified conditions, the ORDER BY clause sorts the result set, and the INSERT INTO command adds new records to a table. None of these directly indicate the source of the data like the FROM clause does.

Get further explanation with Examzify DeepDiveBeta

WHERE

ORDER BY

INSERT INTO

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