Q1. Which of the following is NOT a database type?
- A.Relational
- B.NoSQL
- C.Spreadsheet✓ Correct
- D.Hierarchical
Explanation: Spreadsheets are not databases, though they can store data. Learn more.
CompTIA Tech+ Practice Questions: Databases
16 free, exam-style CompTIA Tech+ (FC0-U71) practice questions covering Databases. Each question shows the correct answer and a clear explanation. Ready for the real thing? Take the full timed quiz below.
Q2. Which of these is a database management system?
- A.Excel
- B.MySQL✓ Correct
- C.Word
- D.Photoshop
Explanation: MySQL is a relational database management system. Learn more.
Q3. What is the primary purpose of a primary key in a database?
- A.Store large binary files
- B.Uniquely identify each record✓ Correct
- C.Format text display
- D.Calculate mathematical formulas
Explanation: Primary keys ensure each record can be uniquely identified. Learn more.
Q4. Which of these is a NoSQL database type?
- A.MySQL
- B.PostgreSQL
- C.MongoDB✓ Correct
- D.Oracle
Explanation: MongoDB is a document-based NoSQL database. Learn more.
Q5. What is the purpose of data normalization?
- A.Increase storage space usage
- B.Reduce data redundancy✓ Correct
- C.Make data unreadable
- D.Slow down queries
Explanation: Normalization organizes data to minimize duplication. Learn more.
Q6. Which of these is a benefit of using a DBMS?
- A.Increased data inconsistency
- B.Centralized data management✓ Correct
- C.Manual data organization
- D.No backup capabilities
Explanation: DBMS provides controlled access and management of data. Learn more.
Q7. What is the purpose of an ER diagram?
- A.Design network layouts
- B.Model database relationships✓ Correct
- C.Configure firewalls
- D.Write software code
Explanation: Entity-Relationship diagrams visualize database structures. Learn more.
Q8. Which of these is a database management system?
- A.Excel
- B.MySQL✓ Correct
- C.Word
- D.Photoshop
Explanation: MySQL is a relational database management system. Learn more.
Q9. What is the primary purpose of a primary key in a database?
- A.Store large binary files
- B.Uniquely identify each record✓ Correct
- C.Format text display
- D.Calculate mathematical formulas
Explanation: Primary keys ensure each record can be uniquely identified. Learn more.
Q10. Which of these is a NoSQL database type?
- A.MySQL
- B.PostgreSQL
- C.MongoDB✓ Correct
- D.Oracle
Explanation: MongoDB is a document-based NoSQL database. Learn more.
Q11. What is the purpose of data normalization?
- A.Increase storage space usage
- B.Reduce data redundancy✓ Correct
- C.Make data unreadable
- D.Slow down queries
Explanation: Normalization organizes data to minimize duplication. Learn more.
Q12. Which of these is a benefit of using a DBMS?
- A.Increased data inconsistency
- B.Centralized data management✓ Correct
- C.Manual data organization
- D.No backup capabilities
Explanation: DBMS provides controlled access and management of data. Learn more.
Q13. What is the purpose of an ER diagram?
- A.Design network layouts
- B.Model database relationships✓ Correct
- C.Configure firewalls
- D.Write software code
Explanation: Entity-Relationship diagrams visualize database structures. Learn more.
Q14. Which database object stores data in rows and columns?
- A.Table✓ Correct
- B.Slide transition
- C.Device driver
- D.Shortcut
Explanation: Relational databases organize records in tables made of rows and columns. Learn more.
Q15. Which database language is commonly used to query relational databases?
- A.SQL✓ Correct
- B.HTML
- C.CSS
- D.JPEG
Explanation: Structured Query Language is used to query and manage relational database data. Learn more.
Q16. Which term describes a collection of related fields for one item in a database table?
- A.Record✓ Correct
- B.Pixel
- C.Protocol
- D.Driver
Explanation: A record is a row in a table and contains fields describing one entity or item. Learn more.