Multiple choice technology databases

Which SQL statement inserts data into a table called Projects?

  1. INSERT Projects ('Content Development', 'Website content development project')

  2. INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

  3. INSERT Projects VALUES ('Content Development', 'Website content development project')

  4. SAVE INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

INSERT INTO is the standard SQL statement with the syntax requiring column names in parentheses followed by VALUES and the data to insert. Option B correctly specifies both column names (ProjectName, ProjectDescription) and their corresponding values. Options A and C miss the required INTO keyword and column specification, while D uses SAVE which is not a SQL keyword.

Keep practicing — related questions