221. What is a database mesh architecture?
- a) Decentralized data ownership with unified access
- b) Network of interconnected database nodes
- c) Blockchain-based database
- d) Cloud database replication
Answer: A - Domain-oriented data products with global governance (e.g., Data Mesh).
222. Which tool enables automated schema migrations?
- a) Flyway
- b) Liquibase
- c) Alembic
- d) All of the above
Answer: D - Version-controlled database schema changes.
223. What is the purpose of in-database ML pipelines?
- a) Train/deploy models without data movement
- b) Optimize query performance
- c) Generate synthetic data
- d) Encrypt sensitive columns
Answer: A - SQL Server ML Services, Oracle ML, and Snowpark ML implement this.
224. Which database explores quantum query optimization?
- a) IBM Quantum SQL
- b) Google Quantum Database
- c) Azure Quantum DB
- d) Research prototypes only
Answer: D - Academic projects currently investigate quantum join algorithms.
225. What is confidential computing in databases?
- a) Encrypted data processing in secure enclaves
- b) Private blockchain
- c) Obfuscated code
- d) Hidden columns
Answer: A - SQL Server Always Encrypted with Secure Enclaves enables this.
226. Which statement creates a data product in a mesh?
- a) CREATE DATA PRODUCT
- b) PUBLISH DATASET
- c) Implementation-specific
- d) No standard syntax
Answer: D - Organizational process rather than SQL command.
227. What is the purpose of the SQL TRAIN_MODEL() function?
- a) Creates ML models on database data
- b) Optimizes query plans
- c) Tests performance
- d) Validates schemas
Answer: A - BigQuery ML and Snowflake ML syntax.
228. Which database provides TEE (Trusted Execution Environment) integration?
- a) SQL Server with SGX
- b) Oracle with TDX
- c) Azure SQL with Intel SGX
- d) All of the above
Answer: D - Secure enclaves for encrypted data processing.
229. What is the purpose of the SQL GENERATE_TEXT() function?
- a) AI-generated text completion
- b) String concatenation
- c) Data masking
- d) Document generation
Answer: A - Snowflake Cortex and SQL Server Azure OpenAI integration.
230. Which feature enables zero-trust database access?
- a) Always Encrypted
- b) Dynamic data masking
- c) Row-level security
- d) All of the above
Answer: D - Defense-in-depth security approach.
231. What is the purpose of the SQL PREDICT() function?
- a) Applies trained ML models
- b) Forecasts trends
- c) Estimates query cost
- d) Validates statistics
Answer: A - In-database model inference (Oracle ML, SQL Server ML).
232. Which statement creates a secure enclave?
- a) CREATE ENCLAVE
- b) ENABLE SECURE COMPUTING
- c) Hardware/cloud configuration
- d) No SQL syntax
Answer: C - Requires infrastructure setup (Intel SGX, AMD SEV).
233. What is the purpose of the SQL EXPLAIN_ML() function?
- a) Interprets model predictions
- b) Describes ML pipelines
- c) Validates algorithms
- d) Tests accuracy
Answer: A - Model explainability features (SHAP/LIME in-database).
234. Which database provides automated anomaly detection?
- a) Azure SQL Anomaly Detection
- b) Oracle Database Insights
- c) Amazon Aurora ML
- d) All of the above
Answer: D - Built-in outlier detection for queries/data.
235. What is the purpose of the SQL CREATE MASKING POLICY statement?
- a) Defines dynamic data masking rules
- b) Configures network security
- c) Creates encryption keys
- d) Hides database objects
Answer: A - Snowflake's column-level data masking syntax.
236. Which feature enables database CI/CD pipelines?
- a) Schema migration tools
- b) Git integration
- c) Automated testing
- d) All of the above
Answer: D - DevOps practices for database changes.
237. What is the purpose of the SQL SEMANTIC_SIMILARITY() function?
- a) Measures text meaning similarity
- b) Compares schemas
- c) Validates data
- d) Tests performance
Answer: A - Vector-based text comparison (Snowflake Cortex).
238. Which database provides quantum-resistant encryption?
- a) SQL Server 2025+
- b) PostgreSQL with pqcrypto
- c) Oracle with Quantum Safe
- d) All of the above
Answer: D - CRYSTALS-Kyber and other NIST-approved algorithms.
239. What is the purpose of the SQL CREATE DATA STREAM statement?
- a) Defines continuous ingestion pipelines
- b) Configures replication
- c) Creates message queues
- d) Enables CDC
Answer: A - Snowflake/SQL Server streaming data syntax.
240. Which feature enables automated database tuning?
- a) Automatic Indexing
- b) Query Store Hints
- c) Performance Advisor
- d) All of the above
Answer: D - Self-tuning database capabilities.