Flearn Website Header

Database Frameworks Study Cards


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!