You need to add a new column named Confirmed to the Attendees table. The solution must meet the following requirements: ✑ Have a default value of false. ✑ Minimize the amount of disk space used. Which code block should you use?
A.
ALTER TABLE Attendees ADD Confirmed bit DEFAULT 0;
B.
ALTER TABLE Attendees ADD Confirmed char(l) DEFAULT '1';
C.
ALTER TABLE Attendees ADD Confirmed bit DEFAULT 1;
D.
ALTER TABLE Attendees ADD Confirmed char(l) DEFAULT `1';
To be fair, a single bit column in a table takes as much space as a char(1) column.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.70-464 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Zikato
4 years, 4 months ago