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

The SQL command used to create a table with a specified number of fields is "CREATE TABLE." This command allows you to define the structure of a new table in a database, including its name and the types of fields (columns) it will contain. Through this command, you can establish the data types for each field, constraints (such as primary keys and foreign keys), and any other properties that the table should have.

The other commands serve different purposes. For instance, "INSERT INTO" is used to add new records to an existing table, but it does not create the table itself. "UPDATE" modifies existing records in a table, allowing you to change the values of certain fields. "DELETE" is employed to remove records from an existing table. Thus, while all these commands are important in SQL, only "CREATE TABLE" is specifically for defining a new table's structure.