You have a database that tracks customer complaints. The database contains a table named Complaints that includes the following columns:
You need to create a query that lists complaints about defective products. The report must include complaints where the exact phrase “defective product” occurs, as well as complaints where similar phrases occur.
Which Transact-SQL statement should you run?
A . SELECT ComplaintID, ComplaintTranscript FROM ComplaintsWHERE CONTAINS(CustomerTranscript, ‘defective’)AND CONTAINS(CustomerTranscript, ‘product’)
B . SELECT ComplaintID, CustomerTranscript FROM ComplaintsWHERE SOUNDEX(‘defective’) = SOUNDEX(‘product’)
C . SELECT ComplaintID, CustomerTranscript FROM ComplaintsWHERE FREETEXT(CustomerTranscript, ‘defective product’)
D . SELECT ComplaintID, Customer Transcript FROM ComplaintsWHERE CustomerTranscript like ‘%defective product%’
Answer: A
Explanation:
References: https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql?view=sql-server-2017