Loading...

SQL Server

Point out the correct statement
  1. The full-text index includes only one character-based column in the table
  2. The full-text index includes more than one character-based columns in the table
  3. The full-text index includes one or more character-based columns in the table
  4. None of the mentioned
Full-text search is an ________ component of the SQL Server Database Engine
  1. slower
  2. optimal
  3. faster
  4. none of the mentioned
We can create a full-text index on
  1. table
  2. view
  3. indexed view
  4. all of the mentioned
Point out the wrong statement
  1. To define full-text searches, SQL Server full-text queries use the full-text predicates
  2. Full-text queries perform linguistic searches against text data
  3. Before you can run full-text queries on a table, the database administrator must create a full-text index on the table
  4. Full-text search is applicable to a shorter range of business scenarios
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
  1. Textual data
  2. Character data
  3. String
  4. All of the mentioned
Which of the following predicates is used for full text search
  1. TEXT()
  2. FREETEXT()
  3. TEXT()
  4. All of the mentioned
FREETEXTTABLE is a full text ____________
  1. Predicate
  2. Function
  3. Procedure
  4. All of the mentioned
The CONTAINS and FREETEXT predicates return a _________ value
  1. TRUE
  2. Scalar
  3. One
  4. All of the mentioned
CONTAINS and CONTAINSTABLE look for an _______ match for the phrase
  1. exact
  2. similar
  3. different
  4. none of the mentioned
Magic table comes under ?
  1. Procedure
  2. Function
  3. Trigger
  4. View