Set 5 MCQ Questions and Answers

Home | SQL | Set 5

SQL 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.

Page: 1/7

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 ?

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 ?