Question no.8

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';

Correct Answer: A 
Explanation

Explanation/Reference: 
Explanation: http://msdn.microsoft.com/en-us/library/ms177603.aspx