Exit 70-459 Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform
Question 1 of 5
0% complete
Q1 Single choice

You need to add a new column named Confirmed to the Employees table. The solution must meet the following requirements: Have a default value of TRUE.
Minimize the amount of disk space used.

Which code segment should you use?

  • A

    ALTER TABLE Employees
    ADD Confirmed bit DEFAULT 0;

  • B

    ALTER TABLE Employees
    ADD Confirmed char(1) DEFAULT "1";

  • C

    ALTER TABLE Employees
    ADD Confirmed char(1) DEFAULT '0';

  • D

    ALTER TABLE Employees
    ADD Confirmed bit DEFAULT 1;

Previous Next