Crowdly

Non-Relational Database

Not Only SQL

What are the four main types of NoSQL databases?

Key-value stores, column-oriented databases, and graph databases

Document databases, key-value stores, column-oriented databases, and graph databases

Document databases, key-value stores, graph databases, and relational databases

None of the above

Choose matching

Which NoSQL database model is best suited for handling large amounts of unstructured or semi-structured data?

Which NoSQL database model is best suited for handling highly interconnected data like social networks?

Which NoSQL database model stores data in tabular form with rows and columns?

In which NoSQL database model is data stored as key-value pairs?

When should you use a NoSQL database?

When you need a database that is scalable and fault-tolerant

All of the above

When you need to store a large amount of data

When you need to store data that is not well-suited for the relational model

Which NoSQL database is the most popular?

Cassandra

All of the above

MongoDB

DynamoDB

Which of the following is a document-oriented NoSQL database?

Cassandra

Neo4j

CouchDB

Redis

What is the main strategy for maintaining data quality in PostgreSQL?

Data encryption

Transaction isolation

Backup and recovery

Data validation constraints

What is the purpose of Write-Ahead Logging (WAL) in PostgreSQL transaction recovery?

To provide a consistent state of the database after a system crash or unexpected shutdown

To monitor and analyze database performance over time

To automatically rollback transactions that fail to commit

To log all user actions during a transaction

What happens to a transaction if there is a failure during the execution of one of its statements?

The failed statement is skipped and the remaining statements are executed

The failed statement is rolled back and the remaining statements are completed

The entire transaction is rolled back

The successful statements are committed and the failed statements are rolled back

Which of the following best describes the ACID properties in PostgreSQL?

A set of programming tools used to create custom data types in PostgreSQL

A set of properties that ensure database transactions are executed reliably and consistently

A set of features that allow PostgreSQL to connect to other types of databases

A set of security protocols that restrict access to PostgreSQL databases