SQL Interview Questions #93: The Storage Engine

SQL code copied to buffer

Task 93:

In MariaDB's architecture, what is the primary purpose and behavior of the "Pluggable Storage Engine" API?

It is a plugin that allows MariaDB to connect directly to NoSQL databases like MongoDB and Cassandra using the standard MySQL protocol without needing a local storage engine.

It allows the server to support multiple storage engines (like InnoDB, MyRocks, or Spider) simultaneously, enabling different tables in the same database to use different storage technologies optimized for specific workloads.

It is a deprecated system replaced by the "Unified Buffer Pool," which now requires all tables to share a single, fixed storage format to ensure ACID compliance across the entire instance.

Mark all correct answers and click the "Check!" button

Support SQLtest.online

This project has only one funding source: your donations. The monthly maintenance cost is $100.

Last month I added a new MariaDB database with a preloaded University DB, 9 new questions, and refactored many questions and lessons.

With your support, I plan to continue this work: write new lessons and tasks, and improve existing lessons.

To keep the project running next month, we need to collect at least this amount by the end of this month. Anything above it goes to new lessons, exercises, and features.

Received: $29.58 Goal: $100.00

Progress: 30%

SQL in 10 Minutes a Day by Ben Forta

Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job.

Login

Register