An SQL statement to define the integrity constraint that the first character in the first name of an employee must be in upper case can be

Question

Answer

None of these

Answer

alter table employee add check (upper(substr(fname, 1, 1)) = substr(fname, 1, 1)

Answer

alter table employee add check (upper(substr(fname, 0, 1)) = substr(fname, 0, 1))

Answer

alter table employee add check (upper(substr(fname, 1, 1)) = substr(fname, 1, 1))

Crowdly