You have a table named ITEMS with the following fields:
ID (integer, primary key. auto generated)
Description (text)
Completed (Boolean)
You need to insert the following data in the table:
“Cheese”, False
Which statement should you use?
A.
INSERT INTO ITEMS (Description, Completed) VALUES (‘Cheese’, 1)
B.
INSERT INTO ITEMS (ID, Description, Completed) VALUES (NEWID(), ‘Cheese’,
0)
C.
INSERT INTO ITEMS (ID, Description, Completed) VALUES (1, ‘Cheese”, 0)
D.
INSERT INTO ITEMS (Description, Completed) VALUES (‘Cheese’, 0)
answer is D. 0 is false, 1 is true