To work with the data in a SQL Server database from a .NET application, you can use ADO.NET objects like

The rows in a table are kept in the sequence that’s based on its  __________________________ index.

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

An index can improve performance when SQL Server does a/an _________________ or a join based on a specific value in the indexed column.

When you code a column list in the INTO clause of an INSERT statement, you can’t include a/an _____________________ column.

Write an aggregate expression to find the oldest date in the InvoiceDate column:_________________________.

To concatenate character strings, you use the _____________ operator in a string expression.

The ________________________________________ is a graphical user interface for working with the objects in a SQL Server database.

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

Your network has 100 nodes on a single broadcast domain. You have implemented VLANs and segmented the network to have 2 VLANs of 50 nodes each. The resulting broadcast traffic effectively: