NEW
Font size
WorksheetsIntroduction to Databases and DBMS
Total questions: 14
Worksheet time: 9mins
Which difference between spreadsheets and databases is emphasized for typical use?
They differ in data storage, access, and capacity
They allow unlimited simultaneous users
They require the same query language
They store only numeric values
A team must build a high‑traffic web application with fast queries and cross‑platform deployment. Which DBMS choice aligns with these needs?
A local-only flat file system
MySQL, an open-source relational DBMS optimized for web apps
A single-user spreadsheet with shared comments
A hierarchical database designed for mainframes only
Which feature in MySQL primarily enhances performance of joins by optimizing how they execute?
Hot-Standby read-only join mode
Nested loop optimization for joins
Inherited tables improving join speed
MVCC concurrency control for joins
Which feature in MySQL primarily enhances performance of joins by optimizing how they execute?
Hot-Standby read-only join mode
Nested loop optimization for joins
Inherited tables improving join speed
MVCC concurrency control for joins
PostgreSQL’s compliance with the ACID model ensures which set of properties for stored data?
Atomicity, consistency, isolation, durability
Atomicity, cohesion, indexing, deduplication
Consistency, redundancy, sharding, durability
Availability, concurrency, integrity, distribution
A team needs master–slave replication, multi-node clustering, and varied backup strategies. Which database is highlighted for these capabilities?
MySQL with redundancy and high availability
PostgreSQL with Hot-Standby only
MongoDB with document replication
SQLite with simple file backups
In the book database example, how is a record typically stored in a NoSQL document model?
As a CSV row with only ISBN and title
As a binary blob managed by stored procedures
As a single JSON document containing book and author fields
Split across normalized tables with foreign keys
Which API characteristic is typical of relational databases?
Object-based APIs for key-value and document searches
Queries conforming to Structured Query Language for data operations
Partition keys enabling column set filtering and attribute search
Serialized application objects stored and retrieved directly
For small or medium projects needing a simple database engine, which manager is suggested?
DynamoDB with serverless capacity
MySQL with easy setup and usage
PostgreSQL with advanced extensions
MongoDB with flexible document modeling
Which reading is recommended to compare SQL and NoSQL key differences?
PostgreSQL official Documentation
Pandora FMS: NOSQL vs SQL guide
MySQL 8.0 Reference Manual
GeeksforGeeks: Introduction to NoSQL
Which stacks are available as alternatives to XAMPP for this class?
MEAN, MERN, JAMstack
Bottle, Flask, Django, FastAPI
WAMP, MAMP, LAMP, Laragon
LEMP, ELK, Hadoop, Spark
Which description matches NoSQL scaling?
Use distributed architecture to partition for consistent performance
Typically scale up hardware for OLTP workloads
Rely on read replicas to handle reporting workloads
Scale out only by adding column stores to schemas
Which API capability is associated with NoSQL systems?
Queries strictly validated against SQL standards
Object-based APIs with partition keys for searching structures
Stored procedures executing transactional operations
Triggers enforcing referential integrity across tables
Which column should be the primary key in the universes table to uniquely identify each universe record?
company string unique per universe
composite of company and age
universe code like U1 or U2
age era descriptor like golden
