Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL

memorize.ai (lvl 286)

(0)

25 cards

()

Section 1

Preview this deck

A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.

Front

1 / 25

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (25)

Section 1

(25 cards)

A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.

Front

materialized view

Back

A(n) _____ plan is a set of instructions generated at application compilation time that predetermines how the application will connect to and communicate with the database at run time.

Front

access

Back

The external model is the representation of the database as "seen" by the DBMS.

Front

False

Back

A primary key's main function is to uniquely identify a(n) _____ within a table.

Front

entity instance or row

Back

The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of _____ integrity.

Front

entity

Back

The traditional Systems Development Life Cycle (SDLC) is divided into _____ phases.

Front

five

Back

A _____ request lets a single SQL statement reference data located at several different local or remote DP sites.

Front

distributed

Back

Data is the result of processing raw facts to reveal its meaning.

Front

False

Back

From a structural point of view, 2NF is better than _____.

Front

1NF

Back

The data cache or _____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.

Front

buffer cache

Back

The conceptual model can handle _____ relationships and multivalued attributes.

Front

M:N

Back

Software vendors have adopted the Chen representation because of its compact representation.

Front

False

Back

______ focuses on filtering data as it enters the system to determine which data to keep and which to discard.

Front

Stream processing

Back

Durability requires that all portions of the transaction must be treated as a single, logical unit of work in which all operations are applied and completed to produce a consistent database.

Front

False

Back

Dependencies based on only a part of a composite primary key are known as _____ dependencies.

Front

partial

Back

Data type selection is usually dictated by the nature of the data and by the intended use.

Front

True

Back

One important inheritance characteristic is that all entity subtypes inherit their _____ key attribute from their supertype.

Front

primary

Back

What is a rule that applies to the two-phase locking protocol.

Front

two transaction cannot have conflicting lock.

Back

A database management system (DBMS) must have validation, transformation, and mapping functions, as well as other functions, in order to be classified as distributed.

Front

True

Back

An XML database supports the storage and management of _____ XML data.

Front

semistructured

Back

The _____ data model is said to be a semantic data model.

Front

object-oriented

Back

The only time the client and server computers communicate is when the client requests a page and the server sends the requested page to the client.

Front

True

Back

In Oracle, the _____ command is used to change the display for a column, for example, to place a $ in front of a numeric value.

Front

FORMAT

Back

If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.

Front

JOIN ON

Back

_____ provide a unified, single point of entry for information distribution.

Front

Portals

Back