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 1

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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 10 G Express, the results of a SQL command appear in the ____________________ pane.

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

In Oracle, dates have the form ____.

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

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

SQL was developed in the mid-____.

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

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

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

In this text, SQL commands are illustrated using ____________________.

Access does not use script files.

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

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

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

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

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

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