Can someone answer these database questions? 1 - The objective of _____ optimiza
ID: 3842957 • Letter: C
Question
Can someone answer these database questions?
1 - The objective of _____ optimization is to minimize the total cost associated with the execution of a request.
2 - _____ 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.
3 - _____ fragmentation allows a user to break a single object into two or more segments, or fragments.
4 - _____ fragmentation refers to the division of a relation into subsets of tuples.
5 - _____ fragmentation refers to the division of a relation into attribute subsets.
6 - The _____ rule requires that all copies of data fragments be identical.
7 - A(n) _____ database stores each database fragment at a single site.
8 - A _____ is optimized for decision support and is generally represented by a data warehouse or a data mart.
9 - _____ are in charge of presenting data to the end user in a variety of ways.
10 - _____ provide a unified, single point of entry for information distribution.
11 - In business intelligence framework, data are captured from a production system and placed in _____ on a near real-time basis.
12 - _____ tools focus on the strategic and tactical use of information.
13 - Which of the following is a personal analytics vendor for BI applications?
14 - From a data analyst’s point of view, decision support data differ from operational data in three main
15 - Operational data are commonly stored in many tables, and the stored data represent information about a given _____ only.
16 - The _____ schema must support complex (non-normalized) data representations.
Explanation / Answer
1. The objective of ___ optimization is to minimize the total cost associated with the execution of a request.
query
2._ 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.
network latency
3. _____ fragmentation allows a user to break a single object into two or more segments, or fragments.
Data
4 - _____ fragmentation refers to the division of a relation into subsets of tuples.
Horizontal
5 - _____ fragmentation refers to the division of a relation into attribute subsets.
Vertical
6 - The _____ rule requires that all copies of data fragments be identical.
mutual consistency
7 - A(n) _____ database stores each database fragment at a single site.
unreplicated
8.A _____ is optimized for decision support and is generally represented by a data warehouse or a data mart.
Data Store
9._____ are in charge of presenting data to the end user in a variety of ways.
Data presentation and visualization tools
10._____ provide a unified, single point of entry for information distribution.
Portals
11. In business intelligence framework, data are captured from a production system and placed in _____ on a near real-time basis.
data warehouse
12 _____ tools focus on the strategic and tactical use of information.
Business intelligence
13. Which of the following is a personal analytics vendor for BI applications?
microstrategy
14 - From a data analyst’s point of view, decision support data differ from operational data in three main
time span, granularity, and dimensionality
15 - Operational data are commonly stored in many tables, and the stored data represent information about a given _____ only.
transaction
16 - The _____ schema must support complex (non-normalized) data representations.
decision support database