Solved

If a DEFAULT Constraint Is Included When a New Column

Question 96

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) A and B
E) A and C

Correct Answer:

verifed

Verified

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

Related Questions

Q13: Changing table names is complicated by the

Q43: There are several difficulties with increasing cardinalities

Q84: Converting date,money,or other more specific data types

Q92: Which of the following SQL statements is

Q93: Which of the following are difficulties when

Q94: To change a table name,we _.<br>A)use the

Q95: When decreasing cardinalities,there will always be _.<br>A)relationship

Q99: When making any change to the database

Q100: When dropping a primary key column from

Q101: When decreasing cardinalities,there will always be data