Which three actions can you perform on an existing table containing data? (Choose three.)
Which three actions can you perform on an existing table containing data? (Choose three.)
You can increase the width of a numeric column because this action does not affect the existing data in the column. Changing the default value of a column is also possible and will affect any new rows inserted after the change. Adding a new NOT NULL column with a DEFAULT value is permitted because the new column will use the specified default value for all existing rows, ensuring that the NOT NULL constraint is satisfied.
AEF B is wrong an additional column will appear at the end C is wrong default value will affect rows that will be inserted after creating default constraint
AEF for me
why not ADE? will E work? when we add a new column with default value, will it use that default value automatically for all the existing rows? im not sure, I know that it will do so for new ones though. as for D, shouldnt it be possible? as dates are stored as numeric value in the DB from what I know..
AEF is 100% correct.