SQL MCQ - English

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 ?

    TEXT()
    FREETEXT()
    TEXT()
    All of the mentioned

Answer : B Discuss

2) FREETEXTTABLE is a full text _________

    Predicate
    Function
    Procedure
    All of the mentioned

Answer : B Discuss

3) The CONTAINS and FREETEXT predicates return a _________ value.

    TRUE or FALSE
    Scalar
    One
    All of the mentioned

Answer : A Discuss

4) CONTAINS and CONTAINSTABLE look for an _______ match for the phrase.

    exact
    similar
    different
    none of the mentioned

Answer : A Discuss

5) What options did ALTER DATABASE statement add ?

    DATABASE SNAPSHOT syntax
    ATTACH_REBUILD_LOG clause
    DB_CHAINING option
    READ_COMMITTED_SNAPSHOT

Answer : D Discuss

6) Which of the following item is provided by CREATE DATABASE statement ?

    Service Broker options
    ALLOW_SNAPSHOT_ISOLATION
    DB_CHAINING
    Database mirroring

Answer : A Discuss

7) Which of the following statement removes database including its related components ?

    DROP DATABASE
    DELETE DATABASE
    REMOVE DATABASE
    None of the mentioned

Answer : A Discuss

8) Which of the following database cannot be dropped ?

    TEMPDB
    Master
    MSDB
    All of the mentioned

Answer : D Discuss

9) Which is the minimal permission that a user must have to drop the database ?

    READ
    WRITE
    VIEW
    CONTROL

Answer : D Discuss

10) Which of the following statement removes sales and suppliers database ?

    DROP DATABASE Sales, NewSales
    DROP DATABASE Sales, suppliers
    DROP DATABASE Sales and suppliers
    DROP DATABASE Sales-suppliers

Answer : B Discuss

Jump to Pages:

1 2 3 4 5 6 7

MCQ Category