Prof. Sarita Gupta

Question

Identify the most appropiate INSERT query from the following: A). `INSERT INTO Persons('xxx1', 'yyy1');` B). `INSERT INTO Persons (LastName, FirstName) Values ('xxx', 'yyy');` C). `INSERT INTO Persons Values('xxx1', 'yyy1');` D). `INSERT INTO Persons Value('xxx1', 'yyy1');`

Edvaya · Accepted Answer

The correct answer is `INSERT INTO Persons Values('xxx1', 'yyy1');`. The standard syntax for inserting values into all columns of a table without explicitly naming the columns is: `INSERT INTO table_name VALUES (value1, value2, ...);` Option (A) is missing the `VALUES` keyword. Option (D) incorrectly uses `VALUE` instead of `VALUES`. While Option (B) is also valid SQL, the marking scheme identifies Option (C) `INSERT INTO Persons Values('xxx1', 'yyy1');` as the most appropriate standard answer expected for this question.

Edvaya Target

Edvaya Aspire

Take a Free Mock Test

Target Subjects

Aspire Subjects

Subject Mastery

Informatics Practices > Database Query Using Sql > Querying And Grouping

Keep Practicing

Current Question

Community Stats

Track Your Progress

Quick Actions

We Value Your Privacy