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:
Verified
Q61: In a doubly nested set of NOT
Q62: The data model produced by reverse engineering
Q63: A doubly nested set of NOT EXISTS
Q64: When running an SQL query that uses
Q65: To add a NULL column to a
Q67: When running a correlated subquery,the DBMS _.
A)runs
Q68: In order to make sure the database
Q69: The data model produced by reverse engineering
Q70: In the SQL statements SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER
Q71: A dependency graph should include all of
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