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.

Which of the following is the difference between static and dynamic routing?

Which of the following best characterizes TCP versus UDP?

What three items are contained in an Ethernet frame? (Select Three)