Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL Chap. 1

memorize.ai (lvl 286)

Section 1

Preview this deck

SEQUENCE

Front

1 / 50

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

7 years ago

Date created

Mar 1, 2020

Cards (50)

Section 1

(50 cards)

SEQUENCE

Front

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.

Back

service_request

Front

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

Back

owner

Front

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

Back

description of the catagory

Front

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

Back

make a more complicated table

Front

Combining the ORDER_LINE and ORDERS tables will ...

Back

quantity ordered

Front

Each line in the Premiere Products order form contains a part number, the number of units of the ordered part, the quoted price, and ...

Back

body

Front

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

Back

AUTHOR_NUMBER

Front

Ray tracks for Henry Books each author's last and first names and an ...

Back

False

Front

SQL stands for Syntactical Question Language.

Back

False

Front

The BRANCH table is used to indicate the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.

Back

total

Front

The computer calculates the ... for Premiere Products whenever an order is printed or displayed on the screen.

Back

code

Front

Each book at Henry Books is uniquely identified with a ...

Back

inventory

Front

The table named ... is used to indicate the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.

Back

False

Front

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

Back

total

Front

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

Back

My SQL

Front

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

Back

appliances, housewares, and sporting goods.

Front

Premiere Products sells...

Back

Database Management System (DBMS)

Front

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

Back

line items

Front

The body of a Premiere Products order contains a number of order lines, sometimes called ...

Back

items

Front

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

Back

Open source software

Front

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

Back

employees

Front

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

Back

False

Front

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

Back

True

Front

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

Back

MARINA

Front

Alexamara stores information about its marinas in the ... table.

Back

False

Front

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

Back

2

Front

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

Back

Linux

Front

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

Back

slips

Front

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

Back

heading

Front

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.

Back

True

Front

Each branch of Henry Books has a number that uniquely identifies the branch.

Back

database

Front

A ... is a structure that contains different categories of information and the relationships between these categories.

Back

customer number

Front

The ORDERS table consists of the order number, order date, and ...

Back

title

Front

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

Back

code

Front

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

Back

WROTE

Front

Which of the following tables relates books to authors?

Back

simple

Front

When designing tables a ... structure is preferred.

Back

extension

Front

The order line in a Premiere Products order form contains a total that is called an...

Back

False

Front

The BOOK table at Henry Books includes the author number.

Back

INVENTORY

Front

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

Back

SERVICE_REQUEST

Front

Information about the Alexamara services requested by boat owners is stored in the ... table.

Back

2

Front

Alexamara owns ___ marinas.

Back

5

Front

How many tables make up the Premiere Products database?

Back

number

Front

A marina ... uniquely identifies each marina in the MARINA table.

Back

ID

Front

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

Back

extension

Front

Each order line at Premiere Products contains a total, usually called an ...

Back

False

Front

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

Back

commission rate

Front

The REP table consists of the order number, order date, and ...

Back

False

Front

The customer's name and address and the number of the sales rep who represents the customer are stored with sales rep information.

Back

AUTHOR

Front

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

Back