Microsoft
98-361 · Question #117
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…
Sign in or unlock 98-361 to reveal the answer and full explanation for question #117. The question stem and answer options stay visible for context.
Understanding Databases
Question
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?
Options
- AINSERT INTO ITEMS (ID, Description, Completed) VALUES (1, 'Cheese', 0)
- BINSERT INTO ITEMS (Description, Completed) VALUES ('Cheese', 1)
- CINSERT INTO ITEMS (10, Description, Completed) VALUES (NEWID(), 'Cheese', 6)
- DINSERT INTO ITEMS (Description, Completed) VALUES ('Cheese', 0)
Unlock 98-361 to see the answer
You've previewed enough free 98-361 questions. Unlock 98-361 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SQL INSERT#DML#auto-increment#boolean values