Using standard ANSI SQL syntax (not vendor-specific extensions), which of the following statements correctly inserts a new record into the table Students so that Name is 'Alice' and Age is 10?
INSERT INTO Students (Name, Age) VALUES ('Alice', 10);
INSERT INTO Students SET Name='Alice', Age=10;
UPDATE Students ADD (Name, Age) VALUES ('Alice', 10);
The statement "INSERT INTO Students (Name, Age) VALUES ('Alice', 10);" follows ANSI SQL syntax for inserting a row: it names the target table, lists the columns, and supplies matching values in the VALUES clause. The other choices are invalid in standard SQL: the SET form is a MySQL-only extension, "ADD RECORD" is not an SQL command, and combining UPDATE with ADD and VALUES is syntactically incorrect.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is ANSI SQL?
Open an interactive chat with Bash
Why is the SET syntax in the first option incorrect for this scenario?
Open an interactive chat with Bash
How does the VALUES clause work in an INSERT statement?
Open an interactive chat with Bash
CompTIA ITF+ FC0-U61 (V5)
Database Fundamentals
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .