To set a column value to an initial value that is selected according to some business logic,you would use:
A)the SQL DEFAULT constraint with the CREATE TABLE command.
B)an SQL view.
C)embedded SQL.
D)an SQL trigger.
E)an SQL stored procedure.

Question

Quizplus · Accepted Answer

To set a column value to an initial value that is selected according to some business logic, an SQL trigger can be used. Triggers are database objects that respond automatically to predefined events, such as the insertion, modification or deletion of data in a table. This allows for the automatic execution of business logic when certain data changes occur, including setting initial values. The DEFAULT constraint, views, embedded SQL, and stored procedures are not specifically designed for this purpose.

To Set a Column Value to an Initial Value That