MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 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. |
_____________DISPLAYS_THE_CONDITION_EXPRESSIONS_THAT_WERE_EXECUTED,?$ |
| A. | syspolicy_policy_execution |
| B. | syspolicy_policy_execution_history_details |
| C. | syspolicy_policy_execution_history |
| D. | syspolicy_policy_group_subscriptions |
| Answer» C. syspolicy_policy_execution_history | |
| 2. |
Purpose_of_syspolicy_system_health_state_in_policy_based_management_is_:$ |
| A. | Displays one row for each Policy-Based Management policy |
| B. | Organize policies when you have many policies |
| C. | Displays the time when policies were executed, the result of each execution, and details about errors if any occurred |
| D. | None of the mentioned |
| Answer» B. Organize policies when you have many policies | |
| 3. |
How many types of execution mode are present in syspolicy_policies ? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» D. 5 | |
| 4. |
Which of the following column is a part of syspolicy_policies result ? |
| A. | name |
| B. | root_condition_id |
| C. | date_created |
| D. | All of the mentioned |
| Answer» E. | |
| 5. |
Policy based management view is owned by _______ schema. |
| A. | dbo |
| B. | db |
| C. | dbos |
| D. | All of the mentioned |
| Answer» B. db | |
| 6. |
Which of the following is Policy-based management view? |
| A. | sys_policies |
| B. | syspolicy_policies |
| C. | syspolicy |
| D. | All of the mentioned |
| Answer» C. syspolicy | |
| 7. |
Which of the following is policy based management tip related to administration ? |
| A. | Evaluate and Implement Policies in Multiple SQL Server Instances |
| B. | Identify SQL Server Databases Not in Full Recovery Model |
| C. | SQL Server Policy Based Management Has Clustered Index Condition |
| D. | None of the mentioned |
| Answer» B. Identify SQL Server Databases Not in Full Recovery Model | |
| 8. |
Point out the correct statement related to database configuration : |
| A. | Enable Data File Growth for all the Databases Using Policy Based Management |
| B. | Monitor Your SQL Server Linked Server Configurations with Policy Based Management |
| C. | Configuring Alerts for SQL Server Policy Based Management |
| D. | None of the mentioned |
| Answer» B. Monitor Your SQL Server Linked Server Configurations with Policy Based Management | |
| 9. |
Policy based management views are present in _________ database. |
| A. | Master |
| B. | Msdb |
| C. | Tempdb |
| D. | Model |
| Answer» C. Tempdb | |