AWS, JavaScript, React - Deploy Web Apps on the Cloud - Characteristics of SQL Versus NoSQL DBMSes

The lecture provides an overview of SQL and NoSQL databases, highlighting their key characteristics, data structures, and scalability. It discusses the ACID principle and CAP theorem, SQL optimization, and complex joins. The video also explores database popularity trends, focusing on MySQL and MariaDB, and compares various NoSQL databases like MongoDB, Redis, and Cassandra, detailing their use cases and compliance with ACID transactions.

What principle do relational databases follow?

• BASE

• CAP

• ACID

• REST

Which of the following is a key characteristic of NoSQL databases?

• They scale out

• They scale up

• They require complex joins

• They use fixed schemas

Which database is the only non-relational one among the top five in popularity?

• MongoDB

• Oracle

• MySQL

• PostgreSQL

What was a major concern when Oracle acquired MySQL?

• MySQL would become open source

• MySQL would be discontinued

• MySQL would be free

• MySQL would be faster

What is a significant feature of MariaDB over MySQL?

• It is proprietary

• It has limited scalability

• It offers thread pooling

• It lacks virtual columns

Which NoSQL database is known for its document-based structure?

• Cassandra

• Couchbase

• Redis

• MongoDB

What type of queries does Redis primarily support?

• Document-based queries

• Key-based queries

• Complex joins

• Graph queries

Which NoSQL database is partially ACID compliant and used for rich media streams?

• MongoDB

• Redis

• Cassandra

• Couchbase

What is the primary query language used by MongoDB?

• SQL

• CQL

• JavaScript

• DQL

Which NoSQL database is known for its wide column store structure?

• Couchbase

• MongoDB

• Redis

• Cassandra