Questões de Concurso

Para excluir todos os funcionários que tenham o cargo (FCargo) iniciados por 'An' e salário (FSal) menor ou igual a 800, utiliza-se a instrução:

(a)

delete from funcionario where FCargo='An%' and FSal<=800;

(b)

delete from funcionario where FCargo like 'An%' and FSal<=800;

(c)

delete * from funcionario where (select FCargo like 'An%' and FSal<=800);

(d)

delete from funcionario where FCargo like '%An' and FSal<=800;

(e)

delete * from funcionario where FCargo like 'An%' and FSal<=800;