Question

Which of the following property is equivalent to NOT NULL? (a) Length (b) Default (c) Required (d) Format

Answer 1

"Option (c) Required.

The property that is equivalent to NOT NULL is Required. In the Forms, when the user specifies the property as ""Required"" that particular field cannot be left blank. This is similar to the case of NOT NULL in the query. For example, Create table tablename (""col_name"" VAR_CHAR(25) NOT NULL); specifies that the column col_name requires a value in the field and it cannot be left blank, This is similar to the Required property in the forms."