Blog

If two tables have a many-to-many relationship, you need to define a/an _____________ table that relates their records.

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

If you omit both NULL and NOT NULL from the list of column attributes in a CREATE TABLE statement, the default setting is __________________________.

A table that’s used to create a view is called a/an ______________________________ table.

If CustomerAddress contains “  178 E Center Street  ”, what will the Solution column contain when this code is executed?LEN(LTRIM(RTRIM(CustomerAddress)))

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

Which of the following is not a valid way to avoid search problems when you want to search for rows that have a specific date in a column that’s defined with the datetime data type and which might include time values?

When you use the Management Studio to create a database, including its tables and indexes, the Studio actually generates and runs the _________________________ statements that are necessary to create the database.

Write the code for a DELETE statement that deletes every row in the Vendors table:_______________________________________________________________

In most cases, the join condition of an inner join compares the primary key of one table to the ____________________ key of another table.