Which two statements should you execute?

You have the following table.

You need to create a full-text index for the table.

Which two statements should you execute? Each correct answer presents part of the solution.
A . CREATE RULE KnowledgeBaseRuleAS @Problem LIKE ‘%’
B . CREATE FULLTEXT STOPLIST KnowledgeBaseStopListFROM KnowledgeBase
C . CREATE INDEX OurIndex ON KnowledgeBase(Problem, Solution) ON [Catalog]
D . CREATE FULLTEXT CATALOG [Catalog] WITH ACCENT_SENSITIVITY = ONAUTHORIZATION [dbo]
E . CREATE FULLTEXT INDEX ON KnowledgeBase(Problem, Solution) KEY INDEX PK_KnowledgeBase ON OurKB

View Answer

Answer: D,E

Explanation:

The CREATE FULLTEXT INDEX ON table_name command creates a full-text index on a table or indexed view in a database in SQL Server.

Example: The following example creates a full-text catalog, production_catalog, in the AdventureWorks sample database. The example then creates a full-text index that uses this new catalog.

CREATE FULLTEXT CATALOG production_catalog;

GO

CREATE FULLTEXT INDEX ON Production.ProductReview

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-fulltext-index-transact-sql