Blog

Which ORDER BY clause will cause 10 rows to be retrieved from the result set, starting with the 20th row?

SQL statements that define the tables in a database are referred to as _______________ statements.

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.