SQL MCQ - English

Set 8 MCQ Questions and Answers

Home | SQL | Set 8

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) Users need _________ permission to create collection model object in MDS.

    Delete
    Create
    Update
    Read

Answer : C Discuss

2) Policy based management views are present in _________ database.

    Master
    Msdb
    Tempdb
    Model

Answer : B Discuss

3) Point out the correct statement related to database configuration :

    Enable Data File Growth for all the Databases Using Policy Based Management
    Monitor Your SQL Server Linked Server Configurations with Policy Based Management
    Configuring Alerts for SQL Server Policy Based Management
    None of the mentioned

Answer : A Discuss

4) Which of the following is policy based management tip related to administration ?

    Evaluate and Implement Policies in Multiple SQL Server Instances
    Identify SQL Server Databases Not in Full Recovery Model
    SQL Server Policy Based Management Has Clustered Index Condition
    None of the mentioned

Answer : A Discuss

5) Which of the following is Policy-based management view?

    sys_policies
    syspolicy_policies
    syspolicy
    All of the mentioned

Answer : B Discuss

6) Policy based management view is owned by _______ schema.

    dbo
    db
    dbos
    All of the mentioned

Answer : A Discuss

7) Which of the following column is a part of syspolicy_policies result ?

    name
    root_condition_id
    date_created
    All of the mentioned

Answer : D Discuss

8) How many types of execution mode are present in syspolicy_policies ?

    2
    3
    4
    5

Answer : C Discuss

9) ________ displays the condition expressions that were executed,

    syspolicy_policy_execution
    syspolicy_policy_execution_history_details
    syspolicy_policy_execution_history
    syspolicy_policy_group_subscriptions

Answer : B Discuss

10) Purpose of syspolicy_system_health_state in policy based management is :

    Displays one row for each Policy-Based Management policy
    Organize policies when you have many policies
    Displays the time when policies were executed, the result of each execution, and details about errors if any occurred
    None of the mentioned

Answer : A Discuss

Jump to Pages:

1 2 3 4 5 6 7

MCQ Category