Blog

To model a database on a real-world system, you typically represent each real-world entity as a/an ____________________________.

____________________ characters can be used to encode the characters that are used in languages throughout the world.

When you code a DELETE statement for one or more rows, the _________________ clause specifies which row or rows are to be deleted.

To create a new table by using a SELECT statement, you code the ___________________________ clause.

Which of the statements below best describes the result set returned by this SELECT statement?SELECT VendorState, COUNT(*) AS Column2FROM VendorsGROUP BY VendorStateHAVING COUNT(*) > 1;

The ____________________ data types are used to store whole numbers.

By default, all duplicate values are included in the aggregate calculation, unless you specify the ___________________________ keyword.

To insert several rows selected from another table into a table, you can code an INSERT statement with a/an ______________ in place of the VALUES clause.

A _____________ is a type of nonclustered index that includes a WHERE clause.

To relate one table to another, a/an __________________ in one table is used to point to the primary key in another table.