CSE MCQs :: SQL Server MCQs
- Point out the correct statement :
- Which of the following is catalog view used for change tracking ?
- Point out the wrong statement:
- Which of the following tool is used for purpose of data auditing for SQL Server only?
- Which of the following catalog view is used for SQL Server Extended Events ?
- Which of the following mode allows for the collection and uploading of data to occur on demand ?
- Which of the following is one of the most crucial performance counters for monitoring ?
- Which of the following stored procedure will stop the trace ?
- Point out the wrong statement :
- Point out the wrong statement :
|
A.
To determine if a database is already enabled, query the is_cdc_enabled column in the sys.database catalog view.
|
|
B.
Change data capture requires exclusive use of the cdc schema and cdc user
|
|
C.
If a change data capture enabled database is dropped, change data capture jobs are not removed
|
|
D.
All of the mentioned
|
Whatsapp
Facebook
|
A.
If a filter is set, all events of the selected event classes are returned in the trace output
|
|
B.
A trace captures data based on selected event classes, data columns, and filters. For example, you can create a trace to monitor exception errors
|
|
C.
A data column is an attribute of an event classes captured in the trace
|
|
D.
All of the mentioned
|
|
A.
When the query processor parameterizes the query, the parameter can appear in the audit event log instead of the column values of the query
|
|
B.
To access the triggering event we can use the EventData function in our DDL trigger
|
|
C.
AUDIT_DATABASE_CHANGE_GROUP event is raised whenever CREATE DATABASE AUDIT is issued
|
|
D.
None of the mentioned
|