A view is a SELECT statement that is stored with the ______________.

To maintain _________________________________, if you delete a row in a primary key table, you must also delete any related rows in foreign key tables.

The IIF function determines the value it returns based on a/an ____________________ expression.

When you use Windows authentication to connect to a database, SQL Server

You can create a database diagram for

The SQL dialect that Microsoft SQL Server uses is called _______________.

Within the Management Studio, you can build a SQL statement without having to write your own code by using the ____________________________________.

What happens if the UDP datagrams arrive at their destination out of sequence?

What is a characteristic of the operation of a Layer 2 switch?

Code example 5-1SELECT VendorState, VendorCity, VendorName, COUNT(*) AS InvoiceQty,    SUM(InvoiceTotal) AS InvoiceAvgFROM Invoices JOIN Vendors    ON Invoices.VendorID = Vendors.VendorIDWHERE VendorState < 'e'GROUP BY VendorState, VendorCity, VendorNameHAVING SUM(InvoiceTotal) > 500ORDER BY VendorState, VendorCity, VendorName; The GROUPING SETS operator works like the ROLLUP and CUBE operators, but it