Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Basic INSERT statement

Find the correct query

Report a typo

The table "animals" is defined by the following statement:

CREATE TABLE animals (
 name VARCHAR(10) NOT NULL,  
 owner VARCHAR(20), 
 age INT NOT NULL
);

Choose the correct query.

Select one option from the list

INSERT INTO animals (name, owner, age) VALUES ('Max', 'Ted', 1);

INSERT INTO animals (owner, age) VALUES ('Tom', 5);

INSERT INTO (name, owner, age) VALUES ('Bobby', 'Steve', 2);

INSERT INTO animals (owner) VALUES ('Anna');

___

Create a free account to access the full topic