You need to insert the following data in the table: "Cheese", False Which statement should you use?

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?

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)



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Ralph

Ralph

answer is D. 0 is false, 1 is true