Exam 3: Creating Tables

Use the ____ data type for columns that contain letters and special characters and for columns containing numbers that will not be used in calculations.

Dropping a table also deletes any data that you entered into the table.

When you enter a new row into a table or modify an existing row, the values for one or more columns can be unknown or unavailable.

When adding rows to character columns, make sure you enclose the values in single quotation marks.

To view data in a table, use the VIEW command.

In Oracle, use the ____________________ command to list all columns in a table and their properties.

Table names cannot contain spaces.

To display all the rows and columns in a table, type the word SELECT, followed by a(n) ____, followed by the word FROM and then the name of the table containing the data you want to view.

The ____________________ data type stores integers but uses less space than the INT data type.

You use the ____________________ command to describe the layout of a table.

In Oracle 10 G Express, you enter a command in the SQL editor pane and then click the ____________________ button to execute the command.

In Access, dates have the form ____.

To list all the columns in a table, use the LIST COLUMNS command.

Which of the following is a valid name for a table?

The ____________________ command adds rows to a table.

In SQL, you cannot enter an apostrophe into a column whose type is character (CHAR).

The DESCRIBE TABLE command defines a table's structure by listing its columns, data types, and column lengths.

The data type DECIMAL(5,2) represents a number with three places to the left and two places to the right of the decimal.

Microsoft SQL Server 2005 is a DBMS designed for use in client-server applications.

You can use a special value to represent situations in which an actual value is unknown, unavailable, or not applicable. This special value is called a(n) ____________________ data value.