Set 5 MCQ Questions and Answers
Home | SQL | Set 5SQL MCQ Questions and Answers : We provide sql quiz questions and answers, here learn mcq questions related to Structured Query Language and test online of objective questions and free download pdf.
1) Which of the following predicates is used for full text search ?
2) FREETEXTTABLE is a full text _________
3) The CONTAINS and FREETEXT predicates return a _________ value.
4) CONTAINS and CONTAINSTABLE look for an _______ match for the phrase.
5) What options did ALTER DATABASE statement add ?
Answer : D Discuss
6) Which of the following item is provided by CREATE DATABASE statement ?
7) Which of the following statement removes database including its related components ?
8) Which of the following database cannot be dropped ?
9) Which is the minimal permission that a user must have to drop the database ?
10) Which of the following statement removes sales and suppliers database ?
Answer : B Discuss