Related InterviewSolutions

• CONTAINS and CONTAINSTABLE look for a _______ match for the phrase.(a) exact(b) similar(c) different(d) none of the mentionedThis question was posed to me by my school teacher while I was bunking the class.The question is from Full Text Search in chapter Beyond Relational of SQL Server
• The CONTAINS and FREETEXT predicates return a _________value.(a) TRUE or FALSE(b) Scalar(c) One(d) All of the mentionedThe question was posed to me by my college director while I was bunking the class.Question is taken from Full Text Search in portion Beyond Relational of SQL Server
• FREETEXTTABLE is a full text _____________(a) Predicate(b) Function(c) Procedure(d) All of the mentionedI got this question during an interview.The question is from Full Text Search in chapter Beyond Relational of SQL Server
• Which of the following predicates is used for full text search?(a) TEXT()(b) FREETEXT()(c) TEXT()(d) All of the mentionedI got this question in an online interview.My doubt stems from Full Text Search in portion Beyond Relational of SQL Server
• Full text indexing is a great feature that solves a database problem, the searching of _________ columns for specific words and phrases in SQL Server databases.(a) Textual data(b) Character data(c) String(d) All of the mentionedI had been asked this question in semester exam.I would like to ask this question from Full Text Search in section Beyond Relational of SQL Server
• Point out the wrong statement.(a) To define full-text searches, SQL Server full-text queries use the full-text predicates(b) Full-text queries perform linguistic searches against text data(c) Before you can run full-text queries on a table, the database administrator must create a full-text index on the table(d) Full-text search is applicable to a shorter range of business scenariosThis question was posed to me in final exam.Enquiry is from Full Text Search in section Beyond Relational of SQL Server
• Full-Text Search in SQL Server lets users and applications run _________ queries.(a) simple queries(b) full-text(c) scalar(d) none of the mentionedThis question was posed to me during an interview.My question comes from Full Text Search topic in division Beyond Relational of SQL Server
• Full-text search is an ________ component of the SQL Server Database Engine.(a) slower(b) optimal(c) faster(d) none of the mentionedThis question was posed to me during an online interview.Question is taken from Full Text Search topic in chapter Beyond Relational of SQL Server
• We can create a full-text index on _____________(a) table(b) view(c) indexed view(d) all of the mentionedThe question was asked in an online quiz.I want to ask this question from Full Text Search in portion Beyond Relational of SQL Server
• Point out the correct statement.(a) The full-text index includes only one character-based column in the table(b) The full-text index includes more than one character-based columns in the table(c) The full-text index includes one or more character-based columns in the table(d) None of the mentionedI got this question by my school principal while I was bunking the class.This is a very interesting question from Full Text Search in portion Beyond Relational of SQL Server