Flearn Website Header

Database Frameworks Study Cards


Master Database Frameworks with our interactive study cards designed for effective learning. These flashcards use proven spaced repetition techniques to help you memorize key concepts, definitions, and facts. Perfect for students, professionals, and lifelong learners seeking to improve knowledge retention and ace exams through active recall practice.


Click any card to reveal the answer

What is MySQL?

click to flip

Answer:

An open-source relational database management system commonly used for web applications

What is PostgreSQL?

click to flip

Answer:

An advanced open-source relational database with strong ACID compliance and extensibility features

What is MongoDB?

click to flip

Answer:

A document-oriented NoSQL database that stores data in flexible JSON-like documents

What is SQLite?

click to flip

Answer:

A lightweight embedded SQL database engine that requires no separate server process

What is Microsoft SQL Server?

click to flip

Answer:

A relational database management system developed by Microsoft for enterprise applications

What is Oracle Database?

click to flip

Answer:

A commercial relational database management system known for enterprise-level features and performance

What is Redis?

click to flip

Answer:

An in-memory data structure store used as a database cache and message broker

What is Cassandra?

click to flip

Answer:

A distributed NoSQL database designed for handling large amounts of data across many servers

📢
Advertisement
See Your Advert Here!

What is MariaDB?

click to flip

Answer:

An open-source relational database that originated as a fork of MySQL

What is Firebase?

click to flip

Answer:

Google's mobile and web application development platform that includes a real-time NoSQL database

What is Amazon DynamoDB?

click to flip

Answer:

A fully managed NoSQL database service provided by Amazon Web Services

What is Elasticsearch?

click to flip

Answer:

A distributed search and analytics engine often used for log analysis and full-text search

What is CouchDB?

click to flip

Answer:

A document-oriented NoSQL database that uses JSON for documents and JavaScript for queries

What is Neo4j?

click to flip

Answer:

A graph database management system designed for storing and querying graph-structured data

What is InfluxDB?

click to flip

Answer:

A time-series database designed for handling high write and query loads of timestamped data

What is the difference between SQL and NoSQL?

click to flip

Answer:

SQL databases use structured tables and relationships while NoSQL databases use flexible schemas and various data models

📢
Advertisement
See Your Advert Here!

What is ACID in databases?

click to flip

Answer:

Atomicity Consistency Isolation Durability - properties that guarantee reliable transaction processing

What is a relational database?

click to flip

Answer:

A database that organizes data into tables with rows and columns linked by relationships

What is a document database?

click to flip

Answer:

A NoSQL database that stores data in document format typically JSON or XML

What is a key-value database?

click to flip

Answer:

A NoSQL database that stores data as key-value pairs for simple lookup operations

What is a graph database?

click to flip

Answer:

A database that uses graph structures with nodes edges and properties to represent data

What is a time-series database?

click to flip

Answer:

A database optimized for storing and querying time-stamped data points

What is database normalization?

click to flip

Answer:

The process of organizing data to reduce redundancy and improve data integrity

What is an index in databases?

click to flip

Answer:

A data structure that improves query performance by creating faster access paths to data

📢
Advertisement
See Your Advert Here!

What is a primary key?

click to flip

Answer:

A unique identifier for each record in a database table

What is a foreign key?

click to flip

Answer:

A field that links one table to the primary key of another table creating relationships

What is SQL?

click to flip

Answer:

Structured Query Language - the standard language for managing relational databases

What is an ORM?

click to flip

Answer:

Object-Relational Mapping - a technique for converting data between incompatible systems using object-oriented languages

What is database replication?

click to flip

Answer:

The process of copying data from one database to another for backup or performance purposes

What is database sharding?

click to flip

Answer:

A method of horizontally partitioning data across multiple database instances

Remember: Use all available resources to study. Flearn alone cannot guarantee success in any exams—make sure to supplement your learning!