Questões de Concurso

No âmbito do MS SQL Server 2014, assinale a sequência de comandos que cria um índice FULL TEXT corretamente.

(a)

CREATE FULLTEXT CATALOG X AS DEFAULT

CREATE FULLTEXT INDEX ON T1(Y)

KEY INDEX IND_OBJETO1

WITH CHANGE_TRACKING OFF

(b)

CREATE FULLTEXT INDEX ON T1

KEY INDEX Y

WITH CHANGE_TRACKING OFF

(c)

CREATE FULLTEXT CATALOG X AS DEFAULT

WITH nome OVER T1

WITH CHANGE_TRACKING OFF

(d)

CREATE FULLTEXT X ON T1(Y)

WITH CHANGE_TRACKING OFF

(e)

CREATE FULLTEXT INDEX X

WITH FULLTEXT CATALOG ON T1(Y)

WITH CHANGE_TRACKING OFF