Pular para o conteúdo principal

Questão de Banco de Dados — SQL Server — FCC 2011

Banco de DadosSQL Server
Código
fc112611
Banca
FCC
Órgão
INFRAERO
Ano
2011
Nível
Superior
Cargo
Analista de Sistemas - Administrador de Banco de Dados
São expressões corretas no MS SQL Server, os exemplos:
  1. ADROP COLUMN table_name column_name eSELECT FROM table_nameAVG(column_name)
  2. BDROP INDEX index_name ON table_name eSELECT FROM table_nameAVG(column_name)
  3. CDROP COLUMN table_name column_name eSELECT AS alias_name column_name(s)FROM table_name
  4. DDROP INDEX index_name ON table_name eALTER COLUMN TABLE table_namecolumn_name datatype
  5. EDROP INDEX table_name.index_name eSELECT column_name(s)FROM table_name WHERE column_nameIN (value1,value2,...)
Revelar gabarito e comentário

GabaritoE — DROP INDEX table_name.index_name e SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,...)

Link permanente: /questoes/fc112611