FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Creating Tables

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

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

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

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.

The ____________________ command adds rows to a 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.

In Access, dates have the form ____.

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

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

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

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

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

Table names cannot contain spaces.

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

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.

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

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

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