Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Lesson 4: Advanced SQL (FLASH CARDS) - C170 - Database Management Applications (WGU)

Lesson 4: Advanced SQL (FLASH CARDS) - C170 - Database Management Applications (WGU)

memorize.ai

memorize.ai (lvl 286)

Section 1

Preview this deck

cross join

Front

1 / 8

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (8)

Section 1

(8 cards)

cross join

Front

A join that performs a relational product (or Cartesian product) of two tables.

Back

base tables

Front

The table on which a view is based.

Back

view

Front

A virtual table based on a SELECT query that is saved as an object in the database.

Back

correlated subquery

Front

A subquery that executes once for each row in the outer query.

Back

set-oriented

Front

Dealing with or related to sets, or groups of things. In the relational model, SQL operators are set-oriented because they operate over entire sets of rows and columns at once.

Back

batch update routine

Front

A routine that pools transactions into a single group to update a master table in a single operation.

Back

updatable view

Front

A view that can update attributes in base tables that are used in the view.

Back

CREATE VIEW

Front

A SQL command that creates a logical, "virtual" table. The view can be treated as a real table.

Back