Question 1

The ____________________ operating system is an example of a popular open source program.

Accepted Answer

Linux

Question 2

The AUTHOR table is used to relate books and authors.

Accepted Answer

A) True 
 B)False  False

Question 3

At Premiere Products, the three sections of an order are the top, body, and bottom.

Accepted Answer

A) True 
 B)False  True

Question 4

Each row in the ORDER_LINE table has an order number, part number, number ordered, quoted price, and total amount.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The Unix operating system is an example of a popular open source program.

Accepted Answer

A) True 
 B)False

Question 7

Because Premiere Products wants the flexibility to quote and charge different prices to different customers, the QUOTED_PRICE column is included in the ORDER_LINE table.

Accepted Answer

A) True 
 B)False

Question 8

Premiere Products sells ____.

Accepted Answer

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

Question 9

Premiere Products sells software, hardware, and appliances.

Accepted Answer

A) True 
 B)False

Question 10

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 11

The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.

Accepted Answer

A) BOOKS 
B) BRANCH 
C) INVENTORY 
D) WROTE 
A) BOOKS 
B) BRANCH 
C) INVENTORY 
D) WROTE

Question 12

The Premiere Products database includes four tables.

Accepted Answer

A) True 
 B)False

Question 13

A(n)______________________________ is a software program that lets you create a database and then use it to add, change, delete, sort, and view the data in a database.

Accepted Answer

DBMS,datab

Question 14

The ____ field of the WROTE table of Henry Books indicates the order in which the authors of a particular book are listed on the cover.

Accepted Answer

A) ORDER 
B) SEQUENCE 
C) ORDERS 
D) NUMBER 
A) ORDER 
B) SEQUENCE 
C) ORDERS 
D) NUMBER

Question 15

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at Premiere Products were combined?

Accepted Answer

How much room do you allow for multiple

Question 16

Alexamara provides a variety of boat repair and maintenance services to the boat owners.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Alexamara Marina Group offers in-water storage to boat owners by providing boat ____________________ that boat owners can rent on an annual basis.

Accepted Answer

The answer of Alexamara Marina Group offers in-water storage to...

Question 19

Alexamara stores information about the boat owners to whom it rents slips in the ____________________ table.

Accepted Answer

The answer of Alexamara stores information about the boat owners...

Question 20

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

The ____________________ operating system is an example of a popular open source program.

The AUTHOR table is used to relate books and authors.

At Premiere Products, the three sections of an order are the top, body, and bottom.

Each row in the ORDER_LINE table has an order number, part number, number ordered, quoted price, and total amount.

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

The Unix operating system is an example of a popular open source program.

Because Premiere Products wants the flexibility to quote and charge different prices to different customers, the QUOTED_PRICE column is included in the ORDER_LINE table.

Premiere Products sells ____.

Premiere Products sells software, hardware, and appliances.

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.

The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.

The Premiere Products database includes four tables.

A(n)______________________________ is a software program that lets you create a database and then use it to add, change, delete, sort, and view the data in a database.

The ____ field of the WROTE table of Henry Books indicates the order in which the authors of a particular book are listed on the cover.

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at Premiere Products were combined?

Alexamara provides a variety of boat repair and maintenance services to the boat owners.

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

Alexamara Marina Group offers in-water storage to boat owners by providing boat ____________________ that boat owners can rent on an annual basis.

Alexamara stores information about the boat owners to whom it rents slips in the ____________________ table.

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

Database Design Fundamentals

An Introduction to SQL

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

MySQL Special Topics

Filters

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

The ____________________ operating system is an example of a popular open source program.

The AUTHOR table is used to relate books and authors.

At Premiere Products, the three sections of an order are the top, body, and bottom.

Each row in the ORDER_LINE table has an order number, part number, number ordered, quoted price, and total amount.

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

The Unix operating system is an example of a popular open source program.

Because Premiere Products wants the flexibility to quote and charge different prices to different customers, the QUOTED_PRICE column is included in the ORDER_LINE table.

Premiere Products sells ____.

Premiere Products sells software, hardware, and appliances.

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.

The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.

The Premiere Products database includes four tables.

A(n)______________________________ is a software program that lets you create a database and then use it to add, change, delete, sort, and view the data in a database.

The ____ field of the WROTE table of Henry Books indicates the order in which the authors of a particular book are listed on the cover.

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at Premiere Products were combined?

Alexamara provides a variety of boat repair and maintenance services to the boat owners.

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

Alexamara Marina Group offers in-water storage to boat owners by providing boat ____________________ that boat owners can rent on an annual basis.

Alexamara stores information about the boat owners to whom it rents slips in the ____________________ table.

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

Database Design Fundamentals

An Introduction to SQL

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

MySQL Special Topics

Filters