If a column named SAL_PCT is to be defined to ensure a value of 100 is input if a NULL value is provided when a new row is inserted, which column definition should be used??
A) ?SAL_PCT NULL 100 DEFAULT.
B) ?SAL_PCT DEFAULT ON NULL 100.
C) ?SAL_PCT DEFAULT 100.
D) ?SAL_PCT ON NULL 100.
Answer: B) ?SAL_PCT DEFAULT ON NULL 100.
Computer Science & Information Technology
You might also like to view...
The Mark as Final command is a security feature
Indicate whether the statement is true or false
Computer Science & Information Technology
Name the organizational scheme used in each of the following examples. Justify your answer.
This is an image of a map, which makes this a geographical organization scheme.
Computer Science & Information Technology