2026/2027 UPDATED EXAM | ACTUAL EXAM 2 LATEST
VERSIONS 400 QUESTIONS AND CORRECT VERIFIED
ANSWERS WITH RATIONALES (100% CORRECT) A+
GRADED ASSURED
Leave the first rating
Save Groups
Terms in this set (104)
In what two ways does a - Enables Data Sharing
DBMS environment increase - Storage of vast volumes of data
effectiveness in working
with data?
A company posts an Improved query response time
internet-based newsletter
about their products. What
advantage will this company
,gain
from the relational database
management system that
will store customer
information?
What is the method of Data NORMALIZATION
organizing attributes into
tables?
, What should a company - Financial: Increased profitability
expect from - Productivity: Increased throughput,
implementing a business decreased workloads
intelligence system? - Trust: greater satisfaction
- Risk: improved visibility
What is a relational model? A database model based on
mathematical principles
What are the 3 - Domain
mathematical concepts of - Tuple
the relational model? - Relation
Define: Domain Set of values = 'Data Type'
Define: Tuple Finite sequence of values pulled from a
fixed domain = 'Row'
Define: Relation A named set of tuples, all from same
domain = 'Table'
A tuple position is called a: Attribute
How is cardinality depicted - Many = Crow's Foot
in a diagram for many, one, - One = a bar across the end of a
and zero? relationship (--||--)
- Zero = Circle
Difference between Unary - Unary: One entity involved in
and Binary: relationship (one box, one line)
- Binary: Two entities (two boxes combined
by one line)