Mock Quiz Hub

Time: 00:00

Quiz

Navigate through questions using the controls below

Question 1 of 60 Quiz ID: q1

What does NoSQL actually stand for according to the lecture?

No to SQL

Not Only SQL

New Object SQL

Non-Operational SQL

Question 2 of 60 Quiz ID: q2

According to the lecture, what would be a more accurate term than 'NoSQL' for these databases?

Modern SQL Databases

Non-Relational Databases

Distributed SQL Databases

Alternative Query Databases

Question 3 of 60 Quiz ID: q3

Which trend mentioned in the lecture explains why salary lists in the 2000s need multiple job columns compared to the 1970s?

Data Size

Connectedness

Semi-structure

Architecture

Question 4 of 60 Quiz ID: q4

What is the primary reason ACID doesn't scale well according to the lecture?

It requires too much memory

It's incompatible with web applications

Web apps have different needs than apps RDBMS were designed for

It only works on single machines

Question 5 of 60 Quiz ID: q5

Which of the following is NOT listed as something web apps can usually do without?

Transactions

Strong consistency

Complex queries

Low latency

Question 6 of 60 Quiz ID: q6

According to the lecture, what scale of servers do companies like Google, Amazon, Yahoo, and Facebook operate?

100-1K servers

1K-10K servers

10K-100K servers

100K+ servers

Question 7 of 60 Quiz ID: q7

Which disadvantage of NoSQL makes client applications more complicated?

Limited query capabilities

Eventual consistency

No standardization

Insufficient access control

Question 8 of 60 Quiz ID: q8

In SQL databases, what does the physical layer abstraction allow applications to specify?

How data is stored

What data is needed

Where data is located

When data is accessed

Question 9 of 60 Quiz ID: q9

Which ACID property ensures that transaction results survive system failures?

Atomic

Consistent

Isolated

Durable

Question 10 of 60 Quiz ID: q10

According to Brewer's CAP Theorem, how many of the three characteristics can a distributed system support?

All three

Only two

Only one

It depends on the system

Question 11 of 60 Quiz ID: q11

In the CAP theorem context, what does 'Consistency' most closely resemble from ACID properties?

Atomic

Consistent

Isolated

Durable

Question 12 of 60 Quiz ID: q12

What does 'Partition Tolerance' mean in the CAP theorem?

The system can be divided into multiple databases

The system continues to operate despite arbitrary message loss

The system can handle network partitions gracefully

The system tolerates data inconsistencies

Question 13 of 60 Quiz ID: q13

What does the 'S' in BASE transactions stand for?

Strong state

Soft state

Simple state

Stable state

Question 14 of 60 Quiz ID: q14

Which characteristic is emphasized first in the BASE model?

Consistency

Availability

Partition tolerance

Durability

Question 15 of 60 Quiz ID: q15

In a Column Store database, what does each storage block contain?

Data from multiple columns of the same row

Data from only one column

Complete rows of data

Index information for faster queries

Question 16 of 60 Quiz ID: q16

When is a Column Store more efficient than a row store?

When doing complex joins

When retrievals access only some columns and multiple rows are inserted simultaneously

When enforcing ACID properties

When handling single-row transactions

Question 17 of 60 Quiz ID: q17

In Google BigTable, what are the three dimensions of the data model?

Table, column, value

Row, column, timestamp

Key, value, version

Master, tablet, server

Question 18 of 60 Quiz ID: q18

In Google BigTable, what is a 'Tablet'?

A single row of data

A column family grouping

A row range that is dynamically partitioned

A timestamp version

Question 19 of 60 Quiz ID: q19

According to the lecture, what makes range scans very efficient in Google BigTable?

Data is stored in memory

Data is sorted by row key

Columns are compressed

Timestamps are indexed

Question 20 of 60 Quiz ID: q20

In Google BigTable architecture, what does client data NOT do?

Move through the Master Server

Go directly through Tablet Servers

Get stored on GFS

Use Chubby for coordination

Question 21 of 60 Quiz ID: q21

What is the primary structure of a Key-Value Store?

B-trees

Hash tables

Linked lists

Binary trees

Question 22 of 60 Quiz ID: q22

What type of queries are typically supported in Key-Value stores?

Complex SQL queries

Only exact matches against keys

Range queries on values

Join operations between tables

Question 23 of 60 Quiz ID: q23

What is a primary use case for Key-Value stores mentioned in the lecture?

Complex analytical queries

Managing user profile or session data

Financial transaction processing

Real-time data streaming

Question 24 of 60 Quiz ID: q24

Which company developed Dynamo according to the lecture?

Google

Facebook

Amazon

Yahoo

Question 25 of 60 Quiz ID: q25

What does Dynamo use for membership and failure detection?

Paxos protocol

Gossip protocol

RAFT consensus

Byzantine fault tolerance

Question 26 of 60 Quiz ID: q26

What format do Document Stores commonly use for storing data?

XML only

Binary format

JSON (JavaScript Object Notation)

CSV format

Question 27 of 60 Quiz ID: q27

Which company uses CouchDB according to the lecture?

Google

Facebook

BBC

Amazon

Question 28 of 60 Quiz ID: q28

What programming language was CouchDB implemented in for better scalability?

C++

Java

Python

Erlang

Question 29 of 60 Quiz ID: q29

In the CouchDB JSON example, what does '_rev' represent?

Revision number

Reverse index

Review status

Revision date

Question 30 of 60 Quiz ID: q30

What does '_id' contain in a CouchDB document?

Auto-incremented integer

GUID – Global Unique Identifier

Hash of the document content

User-defined primary key

Question 31 of 60 Quiz ID: q31

How many phases does MapReduce have?

One

Two

Three

Four

Question 32 of 60 Quiz ID: q32

What does the Map phase do in MapReduce?

Merge and sort key-value pairs

Extract sets of Key-Value pairs from underlying data

Reduce data volume

Create database indexes

Question 33 of 60 Quiz ID: q33

Who implements MapReduce techniques according to the lecture?

Database administrators

System administrators

Application developers

The underlying software automatically

Question 34 of 60 Quiz ID: q34

When was Google granted the MapReduce patent?

2007

2009

2010

2011

Question 35 of 60 Quiz ID: q35

According to www.nosql-database.org definition, what type of databases are being addressed?

Relational databases

Object-oriented databases

Next Generation Databases mostly addressing non-relational, distributed points

Legacy database systems

Question 36 of 60 Quiz ID: q36

When did the NoSQL movement begin according to the lecture?

Early 2007

Early 2008

Early 2009

Early 2010

Question 37 of 60 Quiz ID: q37

Which of these is NOT listed as a NoSQL distinguishing characteristic?

Large data volumes

Strong ACID compliance

Schema-less design

Mostly Open Source development

Question 38 of 60 Quiz ID: q38

What type of workload pattern do NoSQL databases typically handle?

Equal read and write operations

Mostly updates, few queries

Mostly query, few updates

Heavy transaction processing

Question 39 of 60 Quiz ID: q39

How are inserts and updates typically handled in NoSQL databases?

Synchronously with immediate confirmation

Asynchronously without waiting for confirmation

Through two-phase commit protocols

With strict consistency checks

Question 40 of 60 Quiz ID: q40

What approach to concurrency do NoSQL databases typically use?

Pessimistic locking

Two-phase locking

Optimistic Concurrency

Strict serialization

Question 41 of 60 Quiz ID: q41

What type of query language do NoSQL databases typically NOT provide?

Procedural programming interfaces

Set-based query language

JavaScript-based queries

Key-based lookups

Question 42 of 60 Quiz ID: q42

Who is responsible for navigating the access path in NoSQL databases?

Query optimizer

Database engine

Programmer

System administrator

Question 43 of 60 Quiz ID: q43

What do NoSQL databases reject in terms of query expression?

Procedural queries

Declarative query expression

Key-value queries

Document-based queries

Question 44 of 60 Quiz ID: q44

Which aspect of traditional databases do NoSQL systems consider a burden?

Data backup procedures

Up-front schema design

User authentication

Network configuration

Question 45 of 60 Quiz ID: q45

In the CAP theorem triangle diagram, which databases are shown in the Consistency + Partition tolerance region?

MongoDB, Redis

HBase, BigTable, MongoDB

CouchDB, Dynamo

Voldemort, Cassandra

Question 46 of 60 Quiz ID: q46

According to the database ranking shown in the lecture, what trend is noted about major Relational DB Vendors?

They are abandoning SQL completely

They have included NoSQL components to stay competitive

They are focusing only on ACID compliance

They are reducing their market presence

Question 47 of 60 Quiz ID: q47

Which of the following best describes the original intention behind NoSQL according to the lecture?

Replace all SQL databases

Modern web-scale databases

Reduce database complexity

Improve transaction processing

Question 48 of 60 Quiz ID: q48

What characteristic is mentioned as being accelerated by 'web 2.0'?

Data size growth

Network connectivity

Semi-structure trend

Architectural complexity

Question 49 of 60 Quiz ID: q49

In Google BigTable, what are Column Families used for?

Storing metadata only

Grouping columns for storage and compression together

Defining primary keys

Managing user permissions

Question 50 of 60 Quiz ID: q50

What does CouchDB use for storage engine?

Hash tables

B-tree storage engine

LSM trees

Skip lists

Question 51 of 60 Quiz ID: q51

According to the lecture, which company uses MongoDB?

BBC and Shutterfly

Foursquare and Shutterfly

Google and Yahoo

Amazon and Facebook

Question 52 of 60 Quiz ID: q52

What versioning approach does CouchDB use according to the lecture?

Automatic deletion of old versions

MVCC model with old versions retained

Single version with overwrites

Manual version management

Question 53 of 60 Quiz ID: q53

What is a key assumption about the query model in Amazon Dynamo?

Complex joins are required

Multi-table access is common

Simple query model with unique keys and blobs

SQL compatibility is essential

Question 54 of 60 Quiz ID: q54

Which of the following is NOT mentioned as a web application requirement that differs from traditional RDBMS applications?

Low and predictable response time

Strong transaction consistency

Geographic distribution

Flexible schemas

Question 55 of 60 Quiz ID: q55

What makes Google BigTable a 'hybrid' according to the lecture?

It combines SQL and NoSQL

It's a hybrid row/column store

It uses both memory and disk

It supports both reads and writes

Question 56 of 60 Quiz ID: q56

In the Couchbase survey mentioned in the lecture, when was it conducted?

2010

2011

2012

2013

Question 57 of 60 Quiz ID: q57

According to the BASE model description, what type of answers are considered acceptable?

Only exact answers

Approximate answers

Delayed answers

Cached answers

Question 58 of 60 Quiz ID: q58

What does the lecture say about NoSQL database portability?

It's excellent across platforms

It's guaranteed by standards

Portability might be an issue

It's not a concern for most applications

Question 59 of 60 Quiz ID: q59

Which storage system does Google BigTable rely on for data storage?

HDFS

GFS

Local file systems

Question 60 of 60 Quiz ID: q60

What is the primary difference between how SQL and NoSQL databases handle query optimization?

NoSQL uses better algorithms

SQL doesn't have query optimization

NoSQL has no query optimizer, application specifies retrieval path

Both use the same optimization techniques

Quiz Summary

Review your answers before submitting

Total Questions

Answered

Remaining

00:00

Time Spent

Quiz

Quiz Summary

Confirm Submission