Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The ____ data type is used to store integers.

Accepted Answer

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

Question 3

In Oracle, what is the script repository?

Accepted Answer

The script repositor

Question 4

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

Accepted Answer

The answer of To view the data in a table,...

Question 5

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

Accepted Answer

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

Question 6

In general, SQL is case-sensitive.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

The answer of To indicate columns that cannot contain null...

Question 8

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 ____.

Accepted Answer

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

Question 9

How can you correct errors in data?

Accepted Answer

It depends on the type of error. If ther

Question 10

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

Accepted Answer

The names cannot exceed 30 cha

Question 11

The ____ data type stores only the actual character string.

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of In Access, use the ____________________ tool to...

Question 15

SQL is Structured ____________________ Language.

Accepted Answer

The answer of SQL is Structured ____________________ Language....

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

The ____ data type is used to store integers.

In Oracle, what is the script repository?

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

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

In general, SQL is case-sensitive.

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

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 ____.

How can you correct errors in data?

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

The ____ data type stores only the actual character string.

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

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

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

SQL is Structured ____________________ Language.

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Database Design Fundamentals

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

Exam 3: Creating Tables

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

The ____ data type is used to store integers.

In Oracle, what is the script repository?

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

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

In general, SQL is case-sensitive.

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

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 ____.

How can you correct errors in data?

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

The ____ data type stores only the actual character string.

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

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

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

SQL is Structured ____________________ Language.

Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Database Design Fundamentals

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters