C175 Final Test Questions with 100% Correct
Answers
3Vs
volume, velocity, variety
Abstract Data Type (ADT)
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.
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.
Answers
3Vs
volume, velocity, variety
Abstract Data Type (ADT)
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.
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.
