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

In distance vector routing, each node periodically shares its routing table with _________ and whenever there is a change.

To prevent duplicate rows from being returned by a SELECT statement, you can code the __________________ keyword in the SELECT clause.