Discussion :: SQL Server MCQs
- Point out the correct 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
Answer : Option B
Explanation :
If either a schema or a database user named cdc currently exists in a database, the database cannot be enabled for change data capture until the schema and or user are dropped or renamed.
Be The First To Comment