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.
You might also like to view...
An example of ________ prototyping is programming a working model that has all the necessary features but is inefficient.
A) first-of-a-series B) patched-up C) nonoperational D) selected features
If you are sorting a table on two fields, Access will sort the field to the left first before sorting the field on the right
Indicate whether the statement is true or false
____ emphasize the "things" in a system.
A. Interaction diagrams B. Sequence diagrams C. Structure diagrams D. Behavior diagrams
The left and right margins must be adjusted simultaneously
Indicate whether the statement is true or false