Blog

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

To accomplish flow control, TCP uses a ___________ window protocol.

What is the purpose of the Spanning Tree algorithm?

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

Which two statements are correct about IPv4 and IPv6 addresses? (Select Two)

To return all of the columns from the base table, you can code the ___________ operator in the SELECT clause.

What does a router do with a packet that it does not have a destination network for?

If you use the Management Studio to create a database, the Studio will automatically create a database file plus a ______________________ file.

For security reasons you would like a system message displayed when logging into a router. Which of the following allows you to create this message?

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