Blog

To maintain _________________________________, if you delete a row in a primary key table, you must also delete any related rows in foreign key tables.

A database __________________ is a schematic drawing that shows you the relationships between the tables you’re working with.

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.