A developer is building an application that requires a rigid structure where data must be organized into tables with predefined columns and data types. Which database model is characterized by this requirement for a predefined schema?
Document database
Relational database
Key-value database
Non-relational database
The correct answer is a relational database. Relational databases use a "schema-on-write" model, which means the structure (schema), including tables, columns, data types, and relationships, must be defined before data is inserted. This approach ensures data integrity and consistency. Non-relational databases, such as document or key-value databases, are known for their flexible or dynamic schemas ("schema-on-read"), allowing data to be stored without a strictly enforced, predefined structure.
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.