If a DEFAULT constraint is included when a new column is added to a table,the default value is only applied to new rows and not to the existing rows at the time the new column is added.
Correct Answer:
Verified
Q53: Which of the following is not a
Q54: In the database redesign process,an SQL tool
Q55: When decreasing maximum cardinalities,there will always be
Q56: In a correlated subquery of a database
Q57: To add a NULL column to a
Q59: To change the minimum cardinality on the
Q60: To add a NOT NULL column to
Q61: In a doubly nested set of NOT
Q62: The data model produced by reverse engineering
Q63: A doubly nested set of NOT EXISTS
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents