Question

Which of the following is not a SQL Server INFORMATION_SCHEMA view?

(a) INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE

(b) INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS

(c) INFORMATION_SCHEMA.KEY_COLUMN_USAGE

(d) sys.dm_exec_connections

I had been asked this question in an internship interview.

I'd like to ask this question from Views topic in portion Laying the Foundation of SQL Server

Answer 1

Right option is (d) sys.dm_exec_connections

Explanation: The INFORMATION_SCHEMA views allow you to retrieve metadata about the objects within a database.  These views can be found in the master database under Views / System Views and be called from any database in your SQL Server instance.