To insert a new record for a book with an item code of KOB, a retail price of $12.95, and an item cost of $7.95 into the Product table of a database, the SQL statement is:
A) INSERT INTO Product Values('KOB', 'Book', 12.95, 7.95)
B) INSERT INTO Product Values('KOB', 'Book', '$12.95', '$7.95')
C) ADD INTO Product Values('KOB', 'Book', 12.95, 7.95)
D) ADD INTO Product Values('KOB', 'Book', '$12.95', '$7.95')
E) None of the above

Question

Quizplus · Accepted Answer

The correct SQL syntax to insert a new record into a table is "INSERT INTO table_name VALUES (value1, value2, ...);". Choice A correctly follows this syntax and does not include dollar signs for the numeric values, which is the proper format for inserting numeric data into SQL tables.

To Insert a New Record for a Book with an Item