Ciência da Computação Banco de Dados Linguagem SQL

  • A. create subtable FUNCIONARIO01 as select FunNo, FNome, FCargo, FSal+FComis as FSalTotal from FUNCIONARIO where DepNo=30;
  • B. create table FUNCIONARIO01 as select FunNo, FNome, FCargo, FSal+FComis as FSalTotal from FUNCIONARIO where DepNo=30;
  • C. alter table FUNCIONARIO01 as select FunNo, FNome, FCargo, FSal+FComis as FSalTotal from FUNCIONARIO where DepNo=30;
  • D. create table FUNCIONARIO01 as select FunNo, FNome, FCargo, FSal+FComis from FUNCIONARIO where DepNo=30;
  • E. create table FUNCIONARIO01 as select FunNo, FNome, FCargo, FSal*FComis as FSalTotal from FUNCIONARIO where DepNo=30;