Question: Which of the following is a correctly formatted INSERT statement that will insert three records into the artist table? a . ) INSERT INTO artist

Which of the following is a correctly formatted INSERT statement that will insert three records into the artist table?
a.)
INSERT INTO artist (artist_id, name)
VALUES (400, 'Jonas Brothers'),
(401, 'Adele'),
(401, 'Pink');
b.)
INSERT INTO artist (name, artist_id)
VALUES (400, 'Jonas Brothers'),
(401, 'Adele'),
(402, 'Pink');
c.)
INSERT INTO artist (artist_id, name)
VALUES (400, 'Jonas Brothers')
(401, 'Adele')
(402, 'Pink');
d.)
INSERT INTO artist (artist_id, name)
VALUES (400, 'Jonas Brothers'),
(401, 'Adele'),
(402, 'Pink');

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!