Exam 3: Creating Tables

The data type indicates the type of data that a column can contain.

In Oracle 10 G Express, the results of a SQL command appear in the ____________________ pane.

In this text, SQL commands are illustrated using ____________________.

Access does not use script files.

To change a value in a table, use the CHANGE command.

The Oracle Database Express edition allows you to save a command so you can use it again without retyping it.

A ____ file is a text file with a .sql extension that contains SQL commands.

In Oracle, the data type STRING(n) stores a character string n characters long.

Why does the ZIP column in the REP table have a data type of CHAR, if a ZIP Code is made up of numbers?

To create a table, type the word TABLE followed by the name of the table to be created and then by the names and data types of the columns that will comprise the table.

In Oracle, dates have the form ____.

A file containing SQL commands is called a(n) ____________________ file.

To run SQL commands in Access, you must first create a new query.

You can delete the entire table using the ____________________ TABLE command.

In SQL, there are special rules that specify that a particular word must begin in a particular position on the line.

In Access, it is common to create a table using SQL.

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

If you added a row that should not be in a table, use a REMOVE command to remove it.

SQL was developed in the mid-____.

SQL was developed as the data manipulation language for IBM's prototype relational model DBMS, System R.