Considere o modelo de dados relacionais HR ( Human Resources ).
Marque a alternativa que altera a definição da tabela job_history de forma restringir que a data final ( end_date ) seja maior que a data inicial ( start_date ).

Question

Considere o modelo de dados relacionais HR ( Human Resources ).  
 Marque a alternativa que altera a definição da tabela  job_history  de forma restringir que a data final ( end_date ) seja maior que a data inicial ( start_date ).

Accepted Answer

ALTER TABLE job_history  
   ADD CONSTRAINT e_date_greater_t_s_date CHECK (start_date < end_date);

Answer

ALTER TABLE job_history  
     ADD CONSTRAINT CHECK (end_date > start_date);

Answer

ALTER TABLE job_history  
     ADD CONSTRAINT e_date_greater_t_s_date CHECK (end_date < start_date);

Answer

ALTER TABLE job_history  
     CHECK (end_date > start_date) ADD CONSTRAINT e_date_greater_t_s_date;

Answer

ALTER TABLE job_history  
     ADD CHECK (end_date != start_date);

Crowdly

Considere o modelo de dados relacionais HR ( Human Resources ). Marque a alte...

Want instant access to all verified answers on moodle.utfpr.edu.br?