2
c175 final Exam with precise detailed answers
3Vs - ✔✔volume, velocity, variety
active-active array - ✔✔- high-end storage system
- large number of controllers and cache memory
- large storage capacity
- large amounts of cache
- fault tolerance
- ability to handle large amounts of concurrent i/os
active passive arrays - ✔✔- aka midrange storage system
- provide optimal storage solutions at a lower cost
- less storage capacity and cache than high-end storage
- fewer front-end ports
- ensure high redundancy and high performance for applications with predictable workloads
ad hoc query - ✔✔A "spur-of-the-moment" question.
affinity grouping - ✔✔is a process of evaluating relationships or associations between data
elements that demonstrate some kind of affinity between objects.
ALTER TABLE - ✔✔The SQL command used to make changes to table structure. When the
command is followed by a keyword (ADD or MODIFY), it adds a column or changes
column characteristics.
, 2
American National Standards Institute (ANSI) - ✔✔The group that accepted the DBTG
recommendations and augmented database standards in 1975 through its SPARC
committee.
analytical database - ✔✔A database focused primarily on storing historical data and
business metrics used for tactical or strategic decision making.
and operator - ✔✔it displays a record if more than one condition is true
Application Programming Interface (API) - ✔✔Software through which programmers
interact with middleware. An API allows the use of generic SQL code, thereby allowing
client processes to be database server-independent.
Association Rules - ✔✔Descriptive; discovers links or associations amongst data.
Associative Entity - ✔✔An entity type that associates the instances of one or more entity
types and contains attributes that are peculiar to the relationship between those entity
instances.
atomic attribute - ✔✔An attribute that cannot be further subdivided to produce meaningful
components. For example, a person's last name attribute cannot be meaningfully
subdivided.
Atomicity - ✔✔The transaction property that requires all parts of a transaction to be treated
as a single, indivisible, logical unit of work. All parts of a transaction must be completed or
the entire transaction is aborted.
attribute - ✔✔an attribute is a property or characteristic of an entity
c175 final Exam with precise detailed answers
3Vs - ✔✔volume, velocity, variety
active-active array - ✔✔- high-end storage system
- large number of controllers and cache memory
- large storage capacity
- large amounts of cache
- fault tolerance
- ability to handle large amounts of concurrent i/os
active passive arrays - ✔✔- aka midrange storage system
- provide optimal storage solutions at a lower cost
- less storage capacity and cache than high-end storage
- fewer front-end ports
- ensure high redundancy and high performance for applications with predictable workloads
ad hoc query - ✔✔A "spur-of-the-moment" question.
affinity grouping - ✔✔is a process of evaluating relationships or associations between data
elements that demonstrate some kind of affinity between objects.
ALTER TABLE - ✔✔The SQL command used to make changes to table structure. When the
command is followed by a keyword (ADD or MODIFY), it adds a column or changes
column characteristics.
, 2
American National Standards Institute (ANSI) - ✔✔The group that accepted the DBTG
recommendations and augmented database standards in 1975 through its SPARC
committee.
analytical database - ✔✔A database focused primarily on storing historical data and
business metrics used for tactical or strategic decision making.
and operator - ✔✔it displays a record if more than one condition is true
Application Programming Interface (API) - ✔✔Software through which programmers
interact with middleware. An API allows the use of generic SQL code, thereby allowing
client processes to be database server-independent.
Association Rules - ✔✔Descriptive; discovers links or associations amongst data.
Associative Entity - ✔✔An entity type that associates the instances of one or more entity
types and contains attributes that are peculiar to the relationship between those entity
instances.
atomic attribute - ✔✔An attribute that cannot be further subdivided to produce meaningful
components. For example, a person's last name attribute cannot be meaningfully
subdivided.
Atomicity - ✔✔The transaction property that requires all parts of a transaction to be treated
as a single, indivisible, logical unit of work. All parts of a transaction must be completed or
the entire transaction is aborted.
attribute - ✔✔an attribute is a property or characteristic of an entity
