Data Management - Foundations - C175
questions and answers latest top score.
ad hoc query CORRECT ANSWER.A "spur-of-the-moment" question.
analytical database CORRECT ANSWER.A database focused primarily on storing
historical data and business metrics used for tactical or strategic decision
making.
availability CORRECT ANSWER.In the context of data security, it refers to the
accessibility of data whenever required by authorized users and for
authorized purposes.
Centralized CORRECT ANSWER.A database located at a single site.
cloud database CORRECT ANSWER.A database that is created and maintained
using cloud services, such as Microsoft Azure or Amazon AWS.
data CORRECT ANSWER.Raw facts, or facts that have not yet been processed to
reveal their meaning to the end user.
data anomaly CORRECT ANSWER.A data abnormality in which inconsistent
changes have been made to a database. For example, an employee moves,
but the address change is not corrected in all files in the database.
data dependence CORRECT ANSWER.A data condition in which data representation
and manipulation are dependent on the physical data storage characteristics.
,data 2dictionary 2CORRECT 2ANSWER.A 2DBMS 2component 2that 2stores 2metadata—
data 2about 2data. 2Thus, 2the 2data 2dictionary 2contains 2the 2data 2definition 2as
2well 2as 2their 2characteristics 2and 2relationships. 2A 2data 2dictionary 2may 2also
2include 2data 2that 2are 2external 2to 2the 2DBMS. 2Also 2known 2as 2an 2information
2resource 2dictionary. 2See 2also 2active 2data 2dictionary, 2metadata, 2and 2passive
2data 2dictionary.
data 2inconsistency 2CORRECT 2ANSWER.A 2condition 2in 2which 2different 2versions
2of 2the 2same 2data 2yield 2different 2(inconsistent) 2results.
data 2independance 2CORRECT 2ANSWER.A 2condition 2in 2which 2data 2access 2is
2unaffected 2by 2changes 2in 2the 2physical 2data 2storage 2characteristics.
data 2integrity 2CORRECT 2ANSWER.In 2a 2relational 2database, 2a 2condition 2in 2which
2the 2data 2in 2the 2database 2complies 2with 2all 2entity 2and 2referential 2integrity
2constraints.
data 2management 2CORRECT 2ANSWER.A 2process 2that 2focuses 2on 2data
2collection, 2storage, 2and 2retrieval. 2Common 2data 2management 2functions
2include 2addition, 2deletion, 2modification, 2and 2listing.
data 2processing 2(DP) 2specialist 2CORRECT 2ANSWER.The 2person 2responsible 2for
2developing 2and 2managing 2a 2computerized 2file 2processing 2system.
data 2redundancy 2CORRECT 2ANSWER.Exists 2when 2the 2same 2data 2is 2stored
2unnecessarily 2at 2different 2places.
database 2CORRECT 2ANSWER.A 2shared, 2integrated 2computer 2structure 2that
2houses 2a 2collection 2of 2related 2data. 2A 2database 2contains 2two 2types 2of 2data:
2end-user 2data 2(raw 2facts) 2and 2metadata.
database 2design 2CORRECT 2ANSWER.The 2process 2that 2yields 2the 2description 2of
2the 2database 2structure 2and 2determines 2the 2database 2components. 2The
2second 2phase 2of 2the 2Database 2Life 2Cycle.
database 2management 2system 2(DBMS) 2CORRECT 2ANSWER.The 2collection 2of
2programs 2that 2manages 2the 2database 2structure 2and 2controls 2access 2to 2the
2data 2stored 2in 2the 2database.
database 2system 2CORRECT 2ANSWER.An 2organization 2of 2components 2that
2defines 2and 2regulates 2the 2collection, 2storage, 2management, 2and 2use 2of
2data 2in 2a 2database 2environment.
desktop 2database 2CORRECT 2ANSWER.A 2single-user 2database 2that 2runs 2on 2a
2personal 2computer.
discipline-specific 2databases 2CORRECT 2ANSWER.A 2database 2that 2contains
2data 2focused 2on 2specific 2subject 2areas.
, Enterprise 2Database 2CORRECT 2ANSWER.The 2overall 2company 2data 2representation,
2which 2provides 2support 2for 2present 2and 2expected 2future 2needs.
field 2CORRECT 2ANSWER.An 2alphabetic 2or 2numeric 2character 2or 2group 2of
2characters 2that 2defines 2a 2characteristic 2of 2a 2person, 2place, 2or 2thing. 2For
2example, 2a 2person's 2Social 2Security 2number, 2address, 2phone 2number, 2and
2bank 2balance 2all 2constitute 2fields.
file 2CORRECT 2ANSWER.A 2named 2collection 2of 2related 2records.
general-purpose 2databases 2CORRECT 2ANSWER.A 2database 2that 2contains 2a
2wide 2variety 2of 2data 2used 2in 2multiple 2disciplines.
hub 2CORRECT 2ANSWER.A 2warehouse 2of 2data 2packets 2housed 2in 2a 2central
2location 2on 2a 2local 2area 2network. 2It 2contains 2multiple 2ports 2that 2copy 2the
2data 2in 2the 2data 2packets 2to 2make 2it 2accessible 2to 2selected 2or 2all
2segments 2of 2the 2network.
Information 2CORRECT 2ANSWER.The 2result 2of 2processing 2raw 2data 2to 2reveal 2its
2meaning. 2Information 2consists 2of 2transformed 2data 2and 2facilitates 2decision
2making.
islands 2of 2information 2CORRECT 2ANSWER.In 2the 2old 2file 2system 2environment,
2pools 2of 2independent, 2often 2duplicated, 2and 2inconsistent 2data 2created 2and
2managed 2by 2different 2departments.
knowledge 2CORRECT 2ANSWER.The 2body 2of 2information 2and 2facts 2about 2a
2specific 2subject. 2Knowledge 2implies 2familiarity, 2awareness, 2and
2understanding 2of 2information 2as 2it 2applies 2to 2an 2environment. 2A 2key
2characteristic 2is 2that 2new 2knowledge 2can 2be 2derived 2from 2old 2knowledge.
logical 2data 2format 2CORRECT 2ANSWER.The 2way 2a 2person 2views 2data 2within
2the 2context 2of 2a 2problem 2domain.
metadata 2CORRECT 2ANSWER.Data 2about 2data; 2that 2is, 2data 2about 2data
2characteristics 2and 2relationships. 2See 2also 2data 2dictionary.
multiuser 2database 2CORRECT 2ANSWER.A 2database 2that 2supports 2multiple
2concurrent 2users.
noSQL 2CORRECT 2ANSWER.A 2new 2generation 2of 2database 2management
2systems 2that 2is 2not 2based 2on 2the 2traditional 2relational 2database 2model.
online 2analytical 2processing 2(OLAP) 2CORRECT 2ANSWER.Decision 2support
2system 2(DSS) 2tools 2that 2use 2multidimensional 2data 2analysis 2techniques.
2OLAP 2creates 2an 2advanced 2data 2analysis 2environment 2that 2supports
2decision 2making, 2business 2modeling, 2and 2operations 2research.
questions and answers latest top score.
ad hoc query CORRECT ANSWER.A "spur-of-the-moment" question.
analytical database CORRECT ANSWER.A database focused primarily on storing
historical data and business metrics used for tactical or strategic decision
making.
availability CORRECT ANSWER.In the context of data security, it refers to the
accessibility of data whenever required by authorized users and for
authorized purposes.
Centralized CORRECT ANSWER.A database located at a single site.
cloud database CORRECT ANSWER.A database that is created and maintained
using cloud services, such as Microsoft Azure or Amazon AWS.
data CORRECT ANSWER.Raw facts, or facts that have not yet been processed to
reveal their meaning to the end user.
data anomaly CORRECT ANSWER.A data abnormality in which inconsistent
changes have been made to a database. For example, an employee moves,
but the address change is not corrected in all files in the database.
data dependence CORRECT ANSWER.A data condition in which data representation
and manipulation are dependent on the physical data storage characteristics.
,data 2dictionary 2CORRECT 2ANSWER.A 2DBMS 2component 2that 2stores 2metadata—
data 2about 2data. 2Thus, 2the 2data 2dictionary 2contains 2the 2data 2definition 2as
2well 2as 2their 2characteristics 2and 2relationships. 2A 2data 2dictionary 2may 2also
2include 2data 2that 2are 2external 2to 2the 2DBMS. 2Also 2known 2as 2an 2information
2resource 2dictionary. 2See 2also 2active 2data 2dictionary, 2metadata, 2and 2passive
2data 2dictionary.
data 2inconsistency 2CORRECT 2ANSWER.A 2condition 2in 2which 2different 2versions
2of 2the 2same 2data 2yield 2different 2(inconsistent) 2results.
data 2independance 2CORRECT 2ANSWER.A 2condition 2in 2which 2data 2access 2is
2unaffected 2by 2changes 2in 2the 2physical 2data 2storage 2characteristics.
data 2integrity 2CORRECT 2ANSWER.In 2a 2relational 2database, 2a 2condition 2in 2which
2the 2data 2in 2the 2database 2complies 2with 2all 2entity 2and 2referential 2integrity
2constraints.
data 2management 2CORRECT 2ANSWER.A 2process 2that 2focuses 2on 2data
2collection, 2storage, 2and 2retrieval. 2Common 2data 2management 2functions
2include 2addition, 2deletion, 2modification, 2and 2listing.
data 2processing 2(DP) 2specialist 2CORRECT 2ANSWER.The 2person 2responsible 2for
2developing 2and 2managing 2a 2computerized 2file 2processing 2system.
data 2redundancy 2CORRECT 2ANSWER.Exists 2when 2the 2same 2data 2is 2stored
2unnecessarily 2at 2different 2places.
database 2CORRECT 2ANSWER.A 2shared, 2integrated 2computer 2structure 2that
2houses 2a 2collection 2of 2related 2data. 2A 2database 2contains 2two 2types 2of 2data:
2end-user 2data 2(raw 2facts) 2and 2metadata.
database 2design 2CORRECT 2ANSWER.The 2process 2that 2yields 2the 2description 2of
2the 2database 2structure 2and 2determines 2the 2database 2components. 2The
2second 2phase 2of 2the 2Database 2Life 2Cycle.
database 2management 2system 2(DBMS) 2CORRECT 2ANSWER.The 2collection 2of
2programs 2that 2manages 2the 2database 2structure 2and 2controls 2access 2to 2the
2data 2stored 2in 2the 2database.
database 2system 2CORRECT 2ANSWER.An 2organization 2of 2components 2that
2defines 2and 2regulates 2the 2collection, 2storage, 2management, 2and 2use 2of
2data 2in 2a 2database 2environment.
desktop 2database 2CORRECT 2ANSWER.A 2single-user 2database 2that 2runs 2on 2a
2personal 2computer.
discipline-specific 2databases 2CORRECT 2ANSWER.A 2database 2that 2contains
2data 2focused 2on 2specific 2subject 2areas.
, Enterprise 2Database 2CORRECT 2ANSWER.The 2overall 2company 2data 2representation,
2which 2provides 2support 2for 2present 2and 2expected 2future 2needs.
field 2CORRECT 2ANSWER.An 2alphabetic 2or 2numeric 2character 2or 2group 2of
2characters 2that 2defines 2a 2characteristic 2of 2a 2person, 2place, 2or 2thing. 2For
2example, 2a 2person's 2Social 2Security 2number, 2address, 2phone 2number, 2and
2bank 2balance 2all 2constitute 2fields.
file 2CORRECT 2ANSWER.A 2named 2collection 2of 2related 2records.
general-purpose 2databases 2CORRECT 2ANSWER.A 2database 2that 2contains 2a
2wide 2variety 2of 2data 2used 2in 2multiple 2disciplines.
hub 2CORRECT 2ANSWER.A 2warehouse 2of 2data 2packets 2housed 2in 2a 2central
2location 2on 2a 2local 2area 2network. 2It 2contains 2multiple 2ports 2that 2copy 2the
2data 2in 2the 2data 2packets 2to 2make 2it 2accessible 2to 2selected 2or 2all
2segments 2of 2the 2network.
Information 2CORRECT 2ANSWER.The 2result 2of 2processing 2raw 2data 2to 2reveal 2its
2meaning. 2Information 2consists 2of 2transformed 2data 2and 2facilitates 2decision
2making.
islands 2of 2information 2CORRECT 2ANSWER.In 2the 2old 2file 2system 2environment,
2pools 2of 2independent, 2often 2duplicated, 2and 2inconsistent 2data 2created 2and
2managed 2by 2different 2departments.
knowledge 2CORRECT 2ANSWER.The 2body 2of 2information 2and 2facts 2about 2a
2specific 2subject. 2Knowledge 2implies 2familiarity, 2awareness, 2and
2understanding 2of 2information 2as 2it 2applies 2to 2an 2environment. 2A 2key
2characteristic 2is 2that 2new 2knowledge 2can 2be 2derived 2from 2old 2knowledge.
logical 2data 2format 2CORRECT 2ANSWER.The 2way 2a 2person 2views 2data 2within
2the 2context 2of 2a 2problem 2domain.
metadata 2CORRECT 2ANSWER.Data 2about 2data; 2that 2is, 2data 2about 2data
2characteristics 2and 2relationships. 2See 2also 2data 2dictionary.
multiuser 2database 2CORRECT 2ANSWER.A 2database 2that 2supports 2multiple
2concurrent 2users.
noSQL 2CORRECT 2ANSWER.A 2new 2generation 2of 2database 2management
2systems 2that 2is 2not 2based 2on 2the 2traditional 2relational 2database 2model.
online 2analytical 2processing 2(OLAP) 2CORRECT 2ANSWER.Decision 2support
2system 2(DSS) 2tools 2that 2use 2multidimensional 2data 2analysis 2techniques.
2OLAP 2creates 2an 2advanced 2data 2analysis 2environment 2that 2supports
2decision 2making, 2business 2modeling, 2and 2operations 2research.
