Question 1

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 
A)  sequence 
B)  owner 
C)  name 
D)  ID D

Question 2

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  False

Question 3

All the sales representatives at Premiere Products get the same commission rate.

Accepted Answer

A) True 
 B)False  False

Question 4

Alexamara owns ____ marinas.

Accepted Answer

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

Question 5

The branch number appears in the BRANCH table and the ____________________ table in the Hnery Books database.

Accepted Answer

The answer of The branch number appears in the BRANCH...

Question 6

A category name uniquely identifies each service that Alexamara performs.

Accepted Answer

A) True 
 B)False

Question 7

The part description is stored with the information about parts.

Accepted Answer

A) True 
 B)False

Question 8

If another appointment is required to complete additional service, the appointment date appears in the NEXT_SERVICE_DATE column of the ____________________ table of Alexamara.

Accepted Answer

The answer of If another appointment is required to complete...

Question 9

The Premiere Products database includes four tables.

Accepted Answer

A) True 
 B)False

Question 10

Combining the ORDER_LINE and ORDERS tables will ____.

Accepted Answer

A)  save space in the table 
B)  make the table more effective 
C)  increase space in the table 
D)  make the table more complicated 
A)  save space in the table 
B)  make the table more effective 
C)  increase space in the table 
D)  make the table more complicated

Question 11

In the AUTHOR table, Ray tracks for Henry Books each author's last and first names and a(n) ____________________.

Accepted Answer

author num

Question 12

Ray tracks the branch's name, location, and number of ____________________ for Henry Books.

Accepted Answer

The answer of Ray tracks the branch's name, location, and...

Question 13

An example of a relationship between categories is the relationship that exists in the Premiere Products database between sales reps and customers.

Accepted Answer

A) True 
 B)False

Question 14

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 
A)  total sales 
B)  commission rate 
C)  customers 
D)  order number

Question 15

The order number appears in the ORDERS table and the ____________________ table in the Premiere Products database.

Accepted Answer

The answer of The order number appears in the ORDERS...

Question 16

The AUTHOR table is used to relate books and authors.

Accepted Answer

A) True 
 B)False

Question 17

The WROTE table in the Henry Books database relates publishers and books.

Accepted Answer

A) True 
 B)False

Question 18

Alexamara provides boat maintenance service for owners at its two marinas. The SERVICE_CATEGORY table contains a ____.

Accepted Answer

A)  slip ID 
B)  marina number 
C)  description of the category 
D)  marina name 
A)  slip ID 
B)  marina number 
C)  description of the category 
D)  marina name

Question 19

For each book, Ray at Henry Books tracks the book code, ____________________, publisher code, type of book, price and whether the book is paperback.

Accepted Answer

The answer of For each book, Ray at Henry Books...

Question 20

In the Henry Books database, the AUTHOR table contains the author's number, name, and address.

Accepted Answer

A) True 
 B)False

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

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.

All the sales representatives at Premiere Products get the same commission rate.

Alexamara owns ____ marinas.

The branch number appears in the BRANCH table and the ____________________ table in the Hnery Books database.

A category name uniquely identifies each service that Alexamara performs.

The part description is stored with the information about parts.

If another appointment is required to complete additional service, the appointment date appears in the NEXT_SERVICE_DATE column of the ____________________ table of Alexamara.

The Premiere Products database includes four tables.

Combining the ORDER_LINE and ORDERS tables will ____.

In the AUTHOR table, Ray tracks for Henry Books each author's last and first names and a(n) ____________________.

Ray tracks the branch's name, location, and number of ____________________ for Henry Books.

An example of a relationship between categories is the relationship that exists in the Premiere Products database between sales reps and customers.

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

The order number appears in the ORDERS table and the ____________________ table in the Premiere Products database.

The AUTHOR table is used to relate books and authors.

The WROTE table in the Henry Books database relates publishers and books.

Alexamara provides boat maintenance service for owners at its two marinas. The SERVICE_CATEGORY table contains a ____.

For each book, Ray at Henry Books tracks the book code, ____________________, publisher code, type of book, price and whether the book is paperback.

In the Henry Books database, the AUTHOR table contains the author's number, name, and address.

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

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

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.

All the sales representatives at Premiere Products get the same commission rate.

Alexamara owns ____ marinas.

The branch number appears in the BRANCH table and the ____________________ table in the Hnery Books database.

A category name uniquely identifies each service that Alexamara performs.

The part description is stored with the information about parts.

If another appointment is required to complete additional service, the appointment date appears in the NEXT_SERVICE_DATE column of the ____________________ table of Alexamara.

The Premiere Products database includes four tables.

Combining the ORDER_LINE and ORDERS tables will ____.

In the AUTHOR table, Ray tracks for Henry Books each author's last and first names and a(n) ____________________.

Ray tracks the branch's name, location, and number of ____________________ for Henry Books.

An example of a relationship between categories is the relationship that exists in the Premiere Products database between sales reps and customers.

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

The order number appears in the ORDERS table and the ____________________ table in the Premiere Products database.

The AUTHOR table is used to relate books and authors.

The WROTE table in the Henry Books database relates publishers and books.

Alexamara provides boat maintenance service for owners at its two marinas. The SERVICE_CATEGORY table contains a ____.

For each book, Ray at Henry Books tracks the book code, ____________________, publisher code, type of book, price and whether the book is paperback.

In the Henry Books database, the AUTHOR table contains the author's number, name, and address.

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters