SQL Database Concepts Question:
Download Job Interview Questions and Answers PDF
Can you explain Full-Text Query in SQL Server?
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 Question | Next Question |
Tell me what is SQL Profiler? | Do you know what is Similarity and Difference between Truncate and Delete in SQL? |