How will you make sure that the value used in GENDER CHAR(1) column is either ‘M’ or ‘F’ only?

What will be an ideal response?

CONSTRAINT employee_gender_cc CHECK ((Gender = ‘M’) or (Gender = ‘F’))

Computer Science & Information Technology

You might also like to view...

The Table Styles gallery is displayed by clicking Format as Table in the ________

A) Themes group on the HOME tab B) Styles group on the HOME tab C) Themes group on the PAGE LAYOUT tab D) Styles group on the PAGE LAYOUT tab

Computer Science & Information Technology

When using multiple control breaks,

a. All control break modules must be executed when one control field changes. b. Only the modules associated with the control field that changed are executed. c. Modules associated with the control field along with any modules that have control fields that are subordinate to that control field are executed. d. None of the above.

Computer Science & Information Technology