Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The footing of the order at Premiere Products contains the order ____________________.

Accepted Answer

The answer of The footing of the order at Premiere...

Question 3

At Premiere Products, the body of the order contains the order number and date; the customer's number, name, and address; and the sales rep number and name.

Accepted Answer

A) True 
 B)False

Question 4

Each book at Henry Books is uniquely identified with a(n)____.

Accepted Answer

A) title 
B) code 
C) publisher 
D) author

Question 5

Alexamara stores information about its marinas in the ____ table.

Accepted Answer

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

Question 6

____________________ is currently the world's most popular open source database.

Accepted Answer

The answer of ____________________ is currently the world's most popular...

Question 7

The Premiere Products order form was not created in MySQL.

Accepted Answer

A) True 
 B)False

Question 8

The Alexamara Marina Group database uses two uppercase letters to represent an owner number.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The answer of Why would you not combine the two...

Question 10

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

Accepted Answer

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

Question 11

Which of the following tables relates books to authors?

Accepted Answer

A) BOOK 
B) AUTHOR 
C) WROTE 
D) INVENTORY

Question 12

The three components of a Premiere Products order are the heading, ____________________, and footing.

Accepted Answer

The answer of The three components of a Premiere Products...

Question 13

The INVENTORY table at Henry Books includes a column that stores the number of books on hand.

Accepted Answer

A) True 
 B)False

Question 14

The order line in a Premiere Products order form contains a total that is called a(n)____.

Accepted Answer

A) footing 
B) extension 
C) trailer 
D) sum

Question 15

The part description is stored with the information about parts.

Accepted Answer

A) True 
 B)False

Question 16

Each row in the table MARINA_SLIP at Alexamara contains a slip ____ that identifies the particular slip.

Accepted Answer

A) sequence 
B) owner 
C) name 
D) ID

Question 17

The body of the order contains one or more order lines, sometimes called line ____________________.

Accepted Answer

The answer of The body of the order contains one...

Question 18

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

Accepted Answer

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

Question 19

The REP table consists of the sales representatives' number, last name, first name, address, total commission, and ____.

Accepted Answer

A) total sales 
B) commission rate 
C) customers 
D) order number

Question 20

____________________ is software for which the source code is freely and publicly available

Accepted Answer

The answer of ____________________ is software for which the source...

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

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

The footing of the order at Premiere Products contains the order ____________________.

At Premiere Products, the body of the order contains the order number and date; the customer's number, name, and address; and the sales rep number and name.

Each book at Henry Books is uniquely identified with a(n) ____.

Alexamara stores information about its marinas in the ____ table.

____________________ is currently the world's most popular open source database.

The Premiere Products order form was not created in MySQL.

The Alexamara Marina Group database uses two uppercase letters to represent an owner number.

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.

Which of the following tables relates books to authors?

The three components of a Premiere Products order are the heading, ____________________, and footing.

The INVENTORY table at Henry Books includes a column that stores the number of books on hand.

The order line in a Premiere Products order form contains a total that is called a(n) ____.

The part description is stored with the information about parts.

Each row in the table MARINA_SLIP at Alexamara contains a slip ____ that identifies the particular slip.

The body of the order contains one or more order lines, sometimes called line ____________________.

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

The REP table consists of the sales representatives' number, last name, first name, address, total commission, and ____.

____________________ is software for which the source code is freely and publicly available