CompTIA DataSys+QUESTIONS AND ANSWERS |
VERIFIED AND WELL DETAILED ANSWERS | PLUS
RATIONALES | GUARANTEED PASS | LATEST EXAM
UPDATE | EXAM PREP | STUDY GUIDE | PRACTICE
TEST
,Domain 1: Database Fundamentals (Questions 1–25)
1. Which of the following best describes a relational database?
A) Data stored as key-value pairs
B) Data organized into tables with rows and columns
C) Data stored as JSON documents
D) Data stored in a hierarchical tree structure
Answer: B
Rationale: A relational database organizes data into relations (tables) consisting of tuples (rows) and attributes
(columns), based on E.F. Codd's relational model.
,2. What does ACID stand for in database transactions?
A) Atomicity, Consistency, Isolation, Durability
B) Accuracy, Consistency, Integrity, Durability
C) Atomicity, Concurrency, Isolation, Dependency
D) Availability, Consistency, Integrity, Distribution
Answer: A
Rationale: ACID is the standard set of properties guaranteeing reliable transaction processing: Atomicity,
Consistency, Isolation, and Durability.
3. Which normal form eliminates partial dependencies on a composite primary key?
A) 1NF
B) 2NF
C) 3NF
D) BCNF
, Answer: B
Rationale: Second Normal Form (2NF) requires that a table be in 1NF and that all non-key attributes be fully
functionally dependent on the entire primary key, eliminating partial dependencies.
4. In a relational database, a foreign key is used to:
A) Uniquely identify each row in a table
B) Enforce a link between data in two tables
C) Encrypt sensitive data
D) Index the table for faster queries
Answer: B
Rationale: A foreign key is a column (or set of columns) that references the primary key of another table,
enforcing referential integrity between the two tables.
VERIFIED AND WELL DETAILED ANSWERS | PLUS
RATIONALES | GUARANTEED PASS | LATEST EXAM
UPDATE | EXAM PREP | STUDY GUIDE | PRACTICE
TEST
,Domain 1: Database Fundamentals (Questions 1–25)
1. Which of the following best describes a relational database?
A) Data stored as key-value pairs
B) Data organized into tables with rows and columns
C) Data stored as JSON documents
D) Data stored in a hierarchical tree structure
Answer: B
Rationale: A relational database organizes data into relations (tables) consisting of tuples (rows) and attributes
(columns), based on E.F. Codd's relational model.
,2. What does ACID stand for in database transactions?
A) Atomicity, Consistency, Isolation, Durability
B) Accuracy, Consistency, Integrity, Durability
C) Atomicity, Concurrency, Isolation, Dependency
D) Availability, Consistency, Integrity, Distribution
Answer: A
Rationale: ACID is the standard set of properties guaranteeing reliable transaction processing: Atomicity,
Consistency, Isolation, and Durability.
3. Which normal form eliminates partial dependencies on a composite primary key?
A) 1NF
B) 2NF
C) 3NF
D) BCNF
, Answer: B
Rationale: Second Normal Form (2NF) requires that a table be in 1NF and that all non-key attributes be fully
functionally dependent on the entire primary key, eliminating partial dependencies.
4. In a relational database, a foreign key is used to:
A) Uniquely identify each row in a table
B) Enforce a link between data in two tables
C) Encrypt sensitive data
D) Index the table for faster queries
Answer: B
Rationale: A foreign key is a column (or set of columns) that references the primary key of another table,
enforcing referential integrity between the two tables.
