An HR application must store employee records in predefined columns, enforce referential integrity between tables, and allow complex joins written in SQL. Which type of datastore concept best fits these requirements?
NoSQL document database
Object storage system
Non-relational key-value store
Relational database
Relational databases are designed for highly structured data that follows a fixed schema. They use Structured Query Language (SQL) to define and manipulate data, support relationships between multiple tables, and can enforce constraints such as primary and foreign keys for referential integrity. Non-relational key-value stores and NoSQL document databases do not require fixed schemas and generally lack robust join capabilities, while object storage is optimized for unstructured binary objects and does not support table structures or SQL queries. Therefore, a relational database is the most appropriate choice for the described HR application.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All IT & Cybersecurity Package plans include the following perks and exams .
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All IT & Cybersecurity Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.