NewsVine_Mariyam
Diamond Member
I'm interested in what others think about this.
I was taking a practice exam which outlined a requirement that the value contained in one of the fields in a database table being created could only be "positive". They offered as a solution a check constraint on the field of X >= 0 and wanted me to indicate whether their solution would ensure only positive values would be accepted.
I answered "No" that their solution did not comply with the requirement and my answer was marked as incorrect. To me, it's a no brainer because it should simply be x > 0 however apparently in some cases zero is considered a positive number.
I was just wondering what the average person thinks and why.
TIA...
I was taking a practice exam which outlined a requirement that the value contained in one of the fields in a database table being created could only be "positive". They offered as a solution a check constraint on the field of X >= 0 and wanted me to indicate whether their solution would ensure only positive values would be accepted.
I answered "No" that their solution did not comply with the requirement and my answer was marked as incorrect. To me, it's a no brainer because it should simply be x > 0 however apparently in some cases zero is considered a positive number.
I was just wondering what the average person thinks and why.
TIA...