Suppose you learn, after you have created a table and added records to the table, that additional fields are required in the table. Discuss the differences between using the ALTER TABLE statement to add the new fields vs. dropping the table and using CREATE TABLE to create a new table with the correct fields.
What will be an ideal response?
Dropping a table deletes all of the data in the table. If you then use CREATE TABLE to re-create the table
with the new fields / columns , you will have to re-populate the table to add the data that was deleted when the original table
was dropped. With the ALTER TABLE statement, the new fields are added to the existing records in the database. Once the
new fields are populated in all existing records, any fields / columns that may no longer be needed could be deleted. Using
ALTER TABLE in this way preserves the data in the table and eliminates the task of re-populating the table.
You might also like to view...
Why is Havender’s method for denying the “no-preemption” condition not a popular means for preventing deadlock?
What will be an ideal response?
The command used to change a picture to make it look more like a drawing or a painting
A) Picture Styles B) Picture Effects C) Artistic Effects
Systems with ECC memory module support use the same type of memory chips used by standard modules
Indicate whether the statement is true or false
The indirection operator in C is ____.
A. & B. * C. -> D. .