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)

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.