PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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)

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


Leave a Reply