Solved

If a DEFAULT Constraint Is Included When a New Column

Question 78

Multiple Choice

If a DEFAULT constraint is included when a new column is added to a table,the default value is applied to ________.


A) all existing rows at the time the column is added
B) all new rows
C) all new rows but only after the UPDATE command is issued
D) Both A and B are correct

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q73: There is a common trap in writing

Q74: Changing cardinalities _.<br>A)never occurs in database redesign<br>B)rarely

Q75: Dependency graphs are graphical displays like bar

Q76: When running a correlated subquery,the DBMS _.<br>A)runs

Q77: The data model produced by reverse engineering

Q79: EXISTS and NOT EXISTS are actually just

Q80: What is a dependency graph,and what is

Q81: In a correlated subquery,the DBMS can run

Q82: Explain and contrast the results provided by

Q83: Why do databases need redesigning?