Question 1

Why would you not combine the two tables ORDERS and ORDER_LINE at Premiere Products?

Accepted Answer

If the two tables were combined, the new

Question 2

The BRANCH, PUBLISHER, and ____ tables are part of the Henry Books Database.

Accepted Answer

A)  SALES 
B)  LOCATION 
C)  AUTHOR 
D)  PART 
A)  SALES 
B)  LOCATION 
C)  AUTHOR 
D)  PART

Question 3

The ____________________ of the order form at Premiere Products contains the order number and date; the customer's number, name, and address; and the sales rep's number and name.

Accepted Answer

The answer of The ____________________ of the order form at...

Question 4

In the WROTE table of the Henry Books database, the SEQUENCE field indicates the order in which the authors of a particular book are listed on the cover.

Accepted Answer

A) True 
 B)False

Question 5

Alexamara stores information about its marinas in the ____ table.

Accepted Answer

A)  SERVICE 
B)  MARINAS 
C)  MARINA 
D)  ALEXAMARA 
A)  SERVICE 
B)  MARINAS 
C)  MARINA 
D)  ALEXAMARA

Question 6

In the Henry Books database, the table named BOOK contains information about whether or not a book is available at a particular branch.

Accepted Answer

A) True 
 B)False

Question 7

Why does the Premiere Products database use the table ORDERS instead of ORDER?

Accepted Answer

In some database systems, the

Question 8

When designing tables a ____ structure is preferred.

Accepted Answer

A)  complex 
B)  simple 
C)  detailed 
D)  complete 
A)  complex 
B)  simple 
C)  detailed 
D)  complete

Question 9

Each publisher has a ____ that uniquely identifies the publisher at Henry Books.

Accepted Answer

A)  city 
B)  number 
C)  name 
D)  code 
A)  city 
B)  number 
C)  name 
D)  code

Question 10

An owner number in the OWNER table at Alexamara Marina consists of ____ uppercase letters followed by a two-digit number.

Accepted Answer

A)  2 
B)  3 
C)  4 
D)  5 
A)  2 
B)  3 
C)  4 
D)  5

Question 11

In some database systems, the word "order" has a special purpose.

Accepted Answer

A) True 
 B)False

Question 12

The LENGTH column in the MARINA_SLIP table in the Alexamara Marina Group stores the length of the boat in meters.

Accepted Answer

A) True 
 B)False

Question 13

Premiere Products sells ____.

Accepted Answer

A)  books 
B)  residential and commercial property 
C)  appliances, housewares, and sporting goods 
D)  electronic products 
A)  books 
B)  residential and commercial property 
C)  appliances, housewares, and sporting goods 
D)  electronic products

Question 14

At Alexamara Marina Group, marina slips are numbered within each section.

Accepted Answer

A) True 
 B)False

Question 15

The overall order total is stored in the Premiere Products database.

Accepted Answer

A) True 
 B)False

Why would you not combine the two tables ORDERS and ORDER_LINE at Premiere Products?

The BRANCH, PUBLISHER, and ____ tables are part of the Henry Books Database.

The ____________________ of the order form at Premiere Products contains the order number and date; the customer's number, name, and address; and the sales rep's number and name.

In the WROTE table of the Henry Books database, the SEQUENCE field indicates the order in which the authors of a particular book are listed on the cover.

Alexamara stores information about its marinas in the ____ table.

In the Henry Books database, the table named BOOK contains information about whether or not a book is available at a particular branch.

Why does the Premiere Products database use the table ORDERS instead of ORDER?

When designing tables a ____ structure is preferred.

Each publisher has a ____ that uniquely identifies the publisher at Henry Books.

An owner number in the OWNER table at Alexamara Marina consists of ____ uppercase letters followed by a two-digit number.

In some database systems, the word "order" has a special purpose.

The LENGTH column in the MARINA_SLIP table in the Alexamara Marina Group stores the length of the boat in meters.

Premiere Products sells ____.

At Alexamara Marina Group, marina slips are numbered within each section.

The overall order total is stored in the Premiere Products database.

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

Exam 1: Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

Why would you not combine the two tables ORDERS and ORDER_LINE at Premiere Products?

The BRANCH, PUBLISHER, and ____ tables are part of the Henry Books Database.

The ____________________ of the order form at Premiere Products contains the order number and date; the customer's number, name, and address; and the sales rep's number and name.

In the WROTE table of the Henry Books database, the SEQUENCE field indicates the order in which the authors of a particular book are listed on the cover.

Alexamara stores information about its marinas in the ____ table.

In the Henry Books database, the table named BOOK contains information about whether or not a book is available at a particular branch.

Why does the Premiere Products database use the table ORDERS instead of ORDER?

When designing tables a ____ structure is preferred.

Each publisher has a ____ that uniquely identifies the publisher at Henry Books.

An owner number in the OWNER table at Alexamara Marina consists of ____ uppercase letters followed by a two-digit number.

In some database systems, the word "order" has a special purpose.

The LENGTH column in the MARINA_SLIP table in the Alexamara Marina Group stores the length of the boat in meters.

Premiere Products sells ____.

At Alexamara Marina Group, marina slips are numbered within each section.

The overall order total is stored in the Premiere Products database.

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters