Deck 3: Creating Tables

Question 1

Table names cannot contain spaces.

Answer 1

True

Question 2

To move back one or more pages in Oracle Database Express, click the pages in the task bar.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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.

Question 5

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

Question 6

To enter a null value into a table, you use a special format of the NULL command.

Question 7

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

Question 8

In general, SQL is case-sensitive.

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

Unlike Oracle, Access does not support the DECIMAL data type.

Question 14

This text uses Oracle Database Express Edition as the DBMS in which to create and run SQL commands.

Question 15

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

Question 16

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

Question 17

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

Question 18

In Oracle, the date, November 12, 2010 would be stored as '12-NOV-2010'.

Question 19

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.

Question 20

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

Question 21

The ____ data type is used to store integers.

A) INTEGER
B) NUMERAL
C) NUMBER
D) INT

Question 22

In SQL Server, execute the sp_columns command to list all the columns in a table.

Question 23

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

Question 24

What is the original name of SQL?

A) SEQUEL
B) MYSEQUEL
C) DBase
D) MySQL

Question 25

In Oracle, dates have the form ____.

A) DD-MON-YY
B) MON-DD-YY
C) YYYY-MON-DD
D) DD-MON-YYYY

Question 26

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

Question 27

In SQL, table names cannot exceed ____ characters.

A) 12
B) 14
C) 24
D) 30

Question 28

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

Question 29

In Access, dates have the form ____.

A) DD/MM/YY
B) MM/DD/YYYY
C) YYYY/MON/DD
D) DD/MON/YYYY

Question 30

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

Question 31

SQL was developed in the mid-____.

A) 1960s
B) 1970s
C) 1980s
D) 1990s

Question 32

To delete an entire table, use the ____ command and then re-create the table.

A) REMOVE TABLE
B) DELETE TABLE
C) ERASE TABLE
D) DROP TABLE

Question 33

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

A) TBL_1
B) 2_TBL
C) TBL 3
D) 4 tbl

Question 34

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

Question 35

You indicate the end of a command by typing a ____.

A) column
B) comma
C) semicolon
D) period

Question 36

Access does not use script files.

Question 37

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

Question 38

In Access, use the Documenter tool to describe the tables in a database.

Question 39

If your screen displays the SQL Commands page, the Home>SQL>SQL Commands reference at the top of the SQL editor pane is called a ____.

A) command sequence
B) page sequence
C) breadcrumb
D) page trail

Question 40

Oracle stores script files is a special location called Saved Commands.

Question 41

You can use the ____________________ data type to store date data.

Question 42

SQL is Structured ____________________ Language.

Question 43

In Oracle 10G Express, you enter commands on the SQL ____________________ page.

Question 44

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

Question 45

Which of the following commands changes the value in a column?

A) UPDATE
B) CHANGE
C) REPLACE
D) ADD

Question 46

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

Question 47

The ____ data type stores only the actual character string.

A) CHAR
B) VARCHAR
C) TEXT
D) STRING

Question 48

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

A) command
B) batch
C) sequel
D) script

Question 49

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

A) CHAR
B) CHARACTER
C) TEXT
D) STRING

Question 50

Access does not support the ____ data type.

A) DECIMAL
B) CURRENCY
C) INT
D) NUMBER

Question 51

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

A) NEW TABLE
B) DEFINE TABLE
C) CREATE TABLE
D) ADD TABLE

Question 52

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

Question 53

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

Question 54

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

Question 55

In this text, SQL commands are illustrated using ____________________.

Question 56

For any column whose data type is CHAR, values must be enclosed in ____.

A) double quotation marks
B) parentheses
C) single quotation marks
D) square brackets

Question 57

The correct data type for the BALANCE column in the CUSTOMER table is ____.

A) CHAR
B) INT
C) SMALLINT
D) DECIMAL

Question 58

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.

A) single quote
B) asterisk
C) double quote
D) slash

Question 59

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

Question 60

When a script file contains more than one command, each command must end with a(n) ____.

A) apostrophe
B) semicolon
C) period
D) colon

Question 61

To view the data in a table, you use the ____________________ command.

Question 62

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

Question 63

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.

Question 64

You must enclose values in ____________________ quotation marks for any column whose type is character (CHAR), even when the data contains numbers.

Question 65

How can you correct errors in data?

Question 66

In Oracle, what is the script repository?

Question 67

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

Question 68

What are the common restrictions placed on table and column names?

Question 69

In Access, use the ____________________ tool to describe the tables and other objects in a database.

Question 70

The ____________________ command adds rows to a table.

Question 71

To indicate columns that cannot contain null values, use the ____________________ clause in a CREATE TABLE statement.

Question 72

If you need to delete a row from a table, you can use the ____________________ command.

Question 73

Should a user be allowed to enter null values for the primary key?

Question 74

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

Question 75

You can use the ____________________ command to update a value in a table.