To set a column value to an initial value that is selected according to some business logic,you would use the SQL DEFAULT constraint with the CREATE TABLE command.
Correct Answer:
Verified
Q42: If a trigger is being written to
Q46: If the values in an SQL view
Q51: Unlike application code,stored procedures are never distributed
Q51: If the table PRODUCT has a column
Q53: The SQL keyword used to limit column
Q55: Given the SQL statement
CREATE TABLE SALESREP (
SalesRepNo
Q57: Because SQL stored procedures allow and encourage
Q57: Which SQL keyword is used to change
Q59: Which SQL keyword is used to impose
Q61: Which SQL statement is used to retrieve
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