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:
Verified
Q63: Which of the following SQL statements is
Q64: A double nested set of NOT EXISTS
Q65: When running a correlated subquery,the DBMS always
Q66: To change a table name,we _.
A)use the
Q67: The data model produced by reverse engineering
Q69: When running an SQL query that uses
Q70: In the SQL statements SELECT C1.CustName,C1.SalesRepNo
FROM CUSTOMER
Q71: In a double nested set of NOT
Q72: When running a correlated subquery,the DBMS _.
A)runs
Q73: To add a NULL column to a
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