ACD300 practice - PrepKeys

Q1 Multiple choice

As part of an upcoming release of an application, a new nullable field is added to a table that contains customer dataThe new field is used by a reportin the upcoming release, and is calculated using data from another table.

Which two actions should you consider when creating the script to add the new field?

Select all that apply.

A
Create a script thatadds the held and leaves it null.
B
Create a rollback script that removes the field.
C
Create a script that adds the field and then populate it
D
Create a rollback script that clears the data from the field
E
Add a view that joins the customer data to the data used in calculation