Top 50+ Solved SQL MCQ Questions Answer

a. Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view

b. These are stored only in the Master database

c. These types of view are defined by users on a specified schema

d. These are used to show database self describing information

a. INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE

b. INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS

c. INFORMATION_SCHEMA.KEY_COLUMN_USAGE

d. sys.dm_exec_connections

a. Database-scoped Dynamic Management View

b. Complex View

c. Catalog View

d. None of the mentioned