Section 1

Preview this deck

In standard SQL, the optimizer hint ALL_ROWS is generally used for _____ mode processes.

Front

Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

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

2 years ago

Date created

Mar 1, 2020

Cards (75)

Section 1

(50 cards)

In standard SQL, the optimizer hint ALL_ROWS is generally used for _____ mode processes.

Front

batch

Back

_____ transparency exists when the end user or programmer must specify both the fragment names and their locations.

Front

Local mapping

Back

If there is no index, the DBMS will perform a _____ scan.

Front

full table

Back

In the context of RAID levels, striped arrays provide:

Front

increased read performance but no fault tolerance.

Back

_____ fragmentation refers to the division of a relation into subsets of tuples.

Front

Horizontal

Back

A(n) _____ is a logical grouping of several data files that store data with similar characteristics.

Front

table space

Back

A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.

Front

file groups

Back

Distributed processing does not require:

Front

an existing distributed database.

Back

The _____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.

Front

Sort

Back

Under the _____ scenario, all record- and file-locking activities are performed at the end-user location.

Front

multiple-site processing, single-site data

Back

In the context of RAID levels, _____ refers to writing the same data blocks to separate drives.

Front

Mirroring

Back

The _____ table space is used for transaction-recovery purposes.

Front

Rollback Segment

Back

_____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

Front

Location

Back

A _____ contains the description of the entire database as seen by the database administrator.

Front

distributed data dictionary

Back

The _____ table space is used to store the data dictionary tables.

Front

System

Back

When moving data from permanent storage to RAM, an I/O disk operation retrieves:

Front

an entire physical disk block.

Back

The LIKE conditional operator is used by the _____ OPERAND1.

Front

V_CONTACT

Back

_____ transparency allows the integration of several different local database management systems (DBMS) under a common, or global, schema.

Front

Heterogeneity

Back

_____ transparency allows the system to operate as if it were a centralized database management system.

Front

Performance

Back

A distributed database is composed of several parts known as database _____.

Front

Fragments

Back

The _____ processor is the software component residing on each computer that stores and retrieves data located at the site.

Front

Data

Back

_____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.

Front

Network latency

Back

The _____ must be set large enough to permit as many data requests to be serviced from cache as possible.

Front

Data cache

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

A centralized database management is subject to a problem such as _____.

Front

a growing number of remote locations

Back

The DBMS _____ the SQL query and chooses the most efficient access/execution plan.

Front

Parses

Back

A DBA determines the initial size of the data files that make up the database; however, as required, the data files can automatically expand in predefined increments known as _____.

Front

extends

Back

_____ distributed database systems integrate different types of centralized database management systems (DBMS) over a network.

Front

Heterogeneous

Back

A(n) _____ database stores each database fragment at a single site.

Front

unreplicated

Back

The _____ is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions.

Front

Procedure Cache

Back

In theory, a(n) _____ can be an independent centralized database management system with proper interfaces to support remote access from other independent database management systems in the network.

Front

data processor

Back

Bitmap indexes tend to use less space than a _____ because they use bits instead of bytes to store their data.

Front

B-Tree Index

Back

Knowing the sparsity of a column helps you decide whether the use of _____ is appropriate.

Front

an index

Back

_____ transparency allows a physically dispersed database to be managed as though it were centralized.

Front

Distribution

Back

_____ transparency allows data to be updated simultaneously at several network sites.

Front

Transaction

Back

_____ transparency is the highest level of transparency. The end user or programmer does not need to know that a database is partitioned.

Front

Fragmentation

Back

To generate database object statistics manually, following syntax should be used in Oracle: _____.

Front

ANALYZE <TABLE/INDEX> object_name COMPUTE STATISTICS;

Back

In RAID level 5,:

Front

the data and the parity data are striped across separate drives.

Back

The _____ rule requires that all copies of data fragments be identical.

Front

mutual consistency

Back

On the server side, the database environment must be properly configured to respond to clients' requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve this goal are commonly referred to as _____ tuning.

Front

DBMS performance

Back

The _____ guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.

Front

two-phase commit protocol (2PC)

Back

_____ is a disadvantage of a distributed database management system (DDBMS).

Front

Security lapse

Back

_____ refers to the number of different values a column could possibly have.

Front

Data sparsity

Back

From the performance point of view, _____ databases eliminate disk access bottlenecks.

Front

in memory

Back

In standard SQL, the optimizer hint FIRST_ROWS is generally used for _____ mode processes.

Front

interactive

Back

A _____ lets a single SQL statement access the data that are to be processed by a single remote database processor.

Front

remote request

Back

_____ transparency ensures that the system will continue to operate in the event of a node or network malfunction.

Front

Failure

Back

A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

Front

Fully heterogeneous

Back

On the client side, the objective is to generate an SQL query that returns a correct answer in the least amount of time, using a minimum amount of resources at the server end. The activities required to achieve this goal are commonly referred to as _____ tuning.

Front

SQL Performance

Back

A database management system needs _____ to prepare the data for presentation to the end user or to an application program.

Front

formatting

Back

Section 2

(25 cards)

Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) _____.

Front

data warehouse

Back

In a typical star schema, each dimension record is related to thousands of _____ records.

Front

Fact

Back

_____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

Front

Partitioning

Back

Fact and dimension tables are related by _____ keys.

Front

Foreign key

Back

A _____ is optimized for decision support and is generally represented by a data warehouse or a data mart.

Front

data store

Back

The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.

Front

dimensions

Back

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

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

Front

Portals

Back

In star schema representation, a fact table is related to each dimension table in a _____ relationship.

Front

Many-to-one

Back

The attribute hierarchy provides a top-down data organization that is used for two main purposes: _____ and drill-down/roll-up data analysis.

Front

aggregation

Back

Data _____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.

Front

integration

Back

A _____ schema is a type of star schema in which dimension tables can have their own dimension tables.

Front

snowflake

Back

Operational data are commonly stored in many tables, and the stored data represent information about a given _____ only.

Front

transaction

Back

_____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

Front

Data Marts

Back

From a data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and _____.

Front

dimensionality

Back

Which of the following is a personal analytics vendor for BI applications?

Front

MicroStrategy

Back

The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.

Front

normalization

Back

Decision support data tend to be non-normalized, _____, and pre-aggregated.

Front

duplicated

Back

An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in _____ n-dimensional arrays.

Front

Matrix Like

Back

Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a _____.

Front

data cube

Back

The _____ schema must support complex (non-normalized) data representations.

Front

decision support database

Back

In a star schema, attributes are often used to search, filter, or classify _____.

Front

facts

Back

_____ are in charge of presenting data to the end user in a variety of ways.

Front

data visualization tools

Back

Computed or derived facts, at run time, are sometimes called _____ to differentiate them from stored facts.

Front

Metrics

Back

In business intelligence framework, data are captured from a production system and placed in _____ on a near real-time basis.

Front

data warehouse

Back