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
10 free, exam-style CompTIA Tech+ (FC0-U71) practice questions covering Databases, each with the correct answer and an explanation. Start a timed exam below, or scroll on to read through the questions.
Databases practice questions
Answers and explanations are shown. Take the timed exam above to test yourself first.
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 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.
Q9. 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.
Q10. 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.
More CompTIA Tech+ practice topics
Keep studying CompTIA Tech+
Full CompTIA Tech+ practice exam · CompTIA Tech+ study guide · All CompTIA practice questions
Last updated