MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
THE_CONTAINS_AND_FREETEXT_PREDICATES_RETURN_A___________VALUE.?$ |
| A. | TRUE or FALSE |
| B. | Scalar |
| C. | One |
| D. | All of the mentioned |
| Answer» B. Scalar | |
| 2. |
CONTAINS_and_CONTAINSTABLE_look_for_an_________match_for_the_phrase.$ |
| A. | exact |
| B. | similar |
| C. | different |
| D. | none of the mentioned |
| Answer» B. similar | |
| 3. |
FREETEXTTABLE is a full text ____________? |
| A. | Predicate |
| B. | Function |
| C. | Procedure |
| D. | All of the mentioned |
| Answer» C. Procedure | |
| 4. |
Which of the following predicates is used for full text search ? |
| A. | TEXT() |
| B. | FREETEXT() |
| C. | TEXT() |
| D. | All of the mentioned |
| Answer» C. TEXT() | |
| 5. |
We can create a full-text index on : |
| A. | table |
| B. | view |
| C. | indexed view |
| D. | all of the mentioned |
| Answer» E. | |
| 6. |
Full-text search is an ________ component of the SQL Server Database Engine |
| A. | slower |
| B. | optimal |
| C. | faster |
| D. | none of the mentioned |
| Answer» C. faster | |
| 7. |
Full-Text Search in SQL Server lets users and applications run _________ queries. |
| A. | simple queries |
| B. | full-text |
| C. | scalar |
| D. | none of the mentioned |
| Answer» C. scalar | |