What is durability in ACID?

Committed transactions will remain even if there is a failure.

Name one example of a relational database management system (RDBMS).

Examples include Oracle, Microsoft SQL Server, MySQL, and PostgreSQL.

What is one disadvantage of RDBMS?

RDBMS can be hard to scale horizontally.

What is one characteristic of NoSQL databases?

NoSQL databases are often schema-less.

Name one type of NoSQL database.

Examples include MongoDB, Cassandra, and Redis.

What is the CAP theorem?

The CAP theorem states that a distributed system can only guarantee two of the following: Consistency, Availability, and Partition Tolerance.

What does BASE stand for?

BASE stands for Basically Available, Soft State, and Eventually Consistent.

What is a key-value store?

A key-value store is a type of NoSQL database that uses keys to access values.

What is a document store?

A document store is a NoSQL database that stores data in documents like JSON.

What is a graph database?

A graph database uses nodes and edges to represent data and relationships.

What is a vertex in a graph database?

A vertex is a point that represents an entity.

What is an edge in a graph database?

An edge is a connection between two vertices.

What is the purpose of data normalization?

Normalization reduces data redundancy and improves data integrity.

What is denormalization?

Denormalization combines data to improve read performance.

What is a collection in document databases?

A collection is a group of documents.

What is a schema in databases?

A schema is the structure that defines how data is organized.

Sharding is the process of splitting a database into smaller, more manageable pieces.

What is a primary key?

A primary key is a unique identifier for a record in a database.

What is a soft state in BASE?

Soft state means that data can change even if it is not consistent across all nodes.

What does eventually consistent mean?

Eventually consistent means that data will become consistent over time.

What is a column family in a column store?

A column family is a group of related columns.

What is a document in a document database?

A document is a set of key-value pairs that form a single record.

What is the purpose of data governance?

Data governance ensures data quality and compliance with regulations.

What is data integration?

Data integration combines data from different sources into a unified view.

ETL stands for Extract, Transform, Load, a process for moving data.

What is a data warehouse?

A data warehouse is a system used for reporting and data analysis.

What is data quality?

Data quality refers to the accuracy and reliability of data.

DBA stands for Database Administrator, responsible for managing databases.

What is a vulnerability in data security?

A vulnerability is a weakness in a system that can be exploited.

What is a threat in data security?

A threat is a potential danger that could harm the system.

What is access control?

Access control is the process of granting or denying access to resources.

What is data retention?

Data retention is the practice of keeping data for a certain period.

What is data purging?

Data purging is the process of permanently deleting data.

What is replication in databases?

Replication is the process of copying data from one database to another.

What is a data lifecycle?

A data lifecycle is the stages data goes through from creation to deletion.

What is a network partition?

A network partition is a failure that separates nodes in a distributed system.

What is a soft delete?

A soft delete marks data as deleted without removing it from the database.

A backup is a copy of data stored separately for recovery purposes.

What is a data model?

A data model defines how data is structured and organized.

What is a data steward?

A data steward is responsible for managing data assets.

What is a data breach?

A data breach is an incident where unauthorized access to data occurs.

A data lake is a storage repository that holds vast amounts of raw data.

A data mart is a subset of a data warehouse focused on a specific area.

Introduction to NoSQL Databases Flashcards

Student preview

157 questions

Show all answers

1.

FLASHCARD QUESTION

Front

What is a relational database?

Back

A relational database stores data in tables with rows and columns.

2.

FLASHCARD QUESTION

Front

What does SQL stand for?

Back

SQL stands for Structured Query Language.

3.

FLASHCARD QUESTION

Front

What does ACID stand for in databases?

Back

ACID stands for Atomic, Consistency, Isolation, and Durable.

4.

FLASHCARD QUESTION

Front

What is a foreign key?

Back

A foreign key is a column that creates a link between two tables.

5.

FLASHCARD QUESTION

Front

Name one property of ACID.

Back

Atomic: All queries in a transaction must complete or none at all.

6.

FLASHCARD QUESTION

Front

What is the meaning of consistency in ACID?

Back

Data must be in a valid state according to set conditions.

7.

FLASHCARD QUESTION

Front

What does isolation mean in ACID?

Back

Changes made in a transaction cannot be seen until the transaction is complete.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

104 questions

Flashcards về Dữ liệu Tổ chức

Flashcard

•

KG - University

103 questions

Understanding the Housekeeping Department

Flashcard

•

12th Grade

102 questions

Untitled Quiz

Flashcard

•

12th Grade

215 questions

Ôn Tập Kiểm Tra Giữa Kì 1

Flashcard

•

12th Grade

77 questions

Le Seconde invasioni e la nascita dell’Europa

Flashcard

•

6th Grade

74 questions

英语词汇卡片

Flashcard

•

8th Grade

60 questions

vocabulary unit 5 grade 8

Flashcard

•

8th Grade

32 questions

Resolución de Conflictos Laborales

Flashcard

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

10 questions

Introduction to Coding

Interactive video

•

3rd - 6th Grade