SQL Database Concepts Question:

Download Job Interview Questions and Answers PDF

Can you explain Full-Text Query in SQL Server?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

Answer:

SQL Server supports searches on character string columns using Full-Text Query. This query uses full-text catalogs and indexes to perform activities which are managed by the Microsoft search service. The full-text catalogs and indexes are not stored in a SQL Server database and they can't be backed up and restored by using the Transact-SQL BACKUP and RESTORE statements. The full-text catalogs must be resynchronized separately after a recovery or restore operation.

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what is SQL Profiler?Do you know what is Similarity and Difference between Truncate and Delete in SQL?