You administer a Microsoft SQL Server 2008 database. The database contains tables named Customer, Subscriptions, and Orders that have the following definitions:

Customers are considered active if they meet the following requirements:

You need to create a view that shows unique rows where the customer either has made an Order or has a Subscription. Which Transact-SQL statement should you use?

Question

You administer a Microsoft SQL Server 2008 database. The database contains tables named Customer, Subscriptions, and Orders that have the following definitions:

Customers are considered active if they meet the following requirements:

You need to create a view that shows unique rows where the customer either has made an Order or has a Subscription. Which Transact-SQL statement should you use?

Accepted Answer

A. Option A

Answer

B. Option B

Answer

C. Option C

Answer

D. Option D

You administer a Microsoft SQL Server 2008 database. The database contains tables named Customer, Subscriptions, and Orders that have the following definitions: Customers are considered active if…

Question

Exhibits

Options

How the community answered

Community Discussion