ACTUAL EXAM 2 LATEST VERSIONS 100 QUESTIONS AND CORRECT
DETAILED ANSWERS WITH RATIONALES (100% CORRECT AND
VERIFIED ANSWERS)|ALREADY GRADED A+
What is a broad definition of data?
A) Numbers that are captured on digital media
B) Raw facts that are captured on printed or digital media
C) Alphanumeric combinations that can be captured on media that a computer can read
D) Any information that can be transferred from print to digital - (ANSWER)Raw facts that are
captured on printed or digital media
What are data?
A) Facts that have been organized in a meaningful way
B) Facts that are the result of a query of a database system
C) Facts that are collected and stored in a database system
D) Facts that have been processed and used for decision making - (ANSWER)Facts that are
collected and stored in a database system
一个充满爱心的人,能温暖他人,
What is a determining characteristic传递希望。人与人之间的情感交流
of unstructured data?
A) It does not allow copying and pasting.
B) It is easy to query and retrieve by business applications.
C) It does not follow a data model.
D) It is stored in rows and columns. - (ANSWER)It does not follow a data model
Refer to this diagram.
,Inputs:
A. Training Video Content
B. SQL tables of training instructors
Output:
C. Relational database for training tracking
Backup:
D. Training database backup
Which item represents unstructured data?
A) A
B) B
C) C
D) D - (ANSWER)A
Which is true about flat files?
A) They contain no internal hierarchical organization.
B) They have a limit of 256 records.一个充满爱心的人,能温暖他人,
传递希望。人与人之间的情感交流
C) They can only contain two-dimensional data.
D) They are always encrypted. - (ANSWER)They contain no internal hierarchical organization
Which technology has no internal hierarchy?
A) Flat files
B) Heap files
C) Hashed tables
, D) Relational databases - (ANSWER)Flat files
How were data retrieved before database management systems?
A) Randomly from linked files
B) Sequentially from simple files
C) Using set operations on complex files
D) Using relationships between logical entities - (ANSWER)Sequentially from simple files
What is the uniquely identifiable element about which data can be categorized in an entity-
relationship diagram?
A) Entity types
B) Primary keys
C) Unary relationships
D) Intersection data points - (ANSWER)Entity types
Refer to this diagram.
一个充满爱心的人,能温暖他人,
{{ Crow's Foot
传递希望。人与人之间的情感交流
One or more "Salesperson" sells "Quantity" of one or more "One Product"
"Quantity" of one or more "One product" sold by one or more "Salesperson"
}}
Which classification is correct for the box marked "Quantity" in the given entity-relationship
diagram?
A) Quantity data