281. What is the purpose of SQL's DATABASE SNAPSHOT feature?
- a) Point-in-time recovery
- b) Zero-storage cloning
- c) Read-consistent reporting
- d) All of the above
Answer: D - Provides static views of databases without storage duplication (SQL Server/Oracle).
282. Which SQL feature enables quantum-safe encryption?
- a) CRYPT_QALY
- b) ENCRYPT_USING_LATTICE
- c) ALGORITHM KYBER
- d) Implementation-specific
Answer: D - Emerging in PostgreSQL 17+ and Oracle 23c with NIST-approved algorithms.
283. What is the purpose of SQL's DATABASE FIREWALL?
- a) Block SQL injection
- b) Limit connection rates
- c) Mask sensitive data
- d) All of the above
Answer: A - Analyzes query patterns in real-time (Oracle Database Firewall, Azure SQL Threat Detection).
284. Which database provides native column-level lineage tracking?
- a) Snowflake
- b) Databricks
- c) Google BigQuery
- d) All of the above
Answer: D - Tracks data origins and transformations for governance.
285. What is the purpose of SQL's PREDICTIVE SCALING clause?
- a) Auto-adjust resources
- b) Forecast query loads
- c) Optimize cache
- d) All of the above
Answer: B - Uses ML to anticipate workload patterns (AWS Aurora, Azure SQL Hyperscale).
286. Which SQL feature enables cross-database transaction consistency?
- a) Distributed COMMIT
- b) Two-phase commit
- c) Saga pattern
- d) All of the above
Answer: B - XA transactions across heterogeneous systems.
287. What is the purpose of SQL's DATABASE MIRRORING?
- a) High availability
- b) Disaster recovery
- c) Load balancing
- d) All of the above
Answer: D - Maintains synchronized copies across servers (SQL Server Always On, Oracle Data Guard).
288. Which database provides native blockchain analytics?
- a) Oracle Blockchain Tables
- b) SQL Server Ledger
- c) PostgreSQL pg_chain
- d) All of the above
Answer: D - Detect anomalies in immutable ledgers using SQL.
289. What is the purpose of SQL's AUTOMATIC TUNING feature?
- a) Index optimization
- b) Query plan correction
- c) Statistics updates
- d) All of the above
Answer: D - Self-learning database adjustments (SQL Server Intelligent Query Processing).
290. Which SQL feature enables data masking for privacy?
- a) DYNAMIC DATA MASKING
- b) COLUMN REDACTION
- c) CELL-LEVEL SECURITY
- d) All of the above
Answer: D - Implementation varies (SQL Server, Oracle Data Redaction).
291. What is the purpose of SQL's DATABASE SHARDING?
- a) Horizontal partitioning
- b) Distributed storage
- c) Parallel processing
- d) All of the above
Answer: D - Splits data across servers by key ranges (MongoDB, Citus).
292. Which database provides native time-series compression?
- a) TimescaleDB
- b) InfluxDB
- c) Oracle Time Series
- d) All of the above
Answer: D - Reduces storage for IoT/historical data by 90%+.
293. What is the purpose of SQL's DATABASE CONTAINERIZATION?
- a) Isolated environments
- b) Rapid deployment
- c) Resource efficiency
- d) All of the above
Answer: D - Docker/Kubernetes integration (Azure SQL Edge, PostgreSQL in containers).
294. Which SQL feature enables natural language queries?
- a) NLP_TO_SQL()
- b) QUERY_FROM_TEXT()
- c) ASK_DATABASE()
- d) Implementation-specific
Answer: D - Oracle AI Vector Search, SQL Server Semantic Search.
295. What is the purpose of SQL's DATABASE VERSIONING?
- a) Track schema changes
- b) Rollback modifications
- c) Compare environments
- d) All of the above
Answer: D - Flyway, Liquibase, and native tools like PostgreSQL pg_dump.
296. Which database provides native data anomaly detection?
- a) Oracle Anomaly Detection
- b) SQL Server Machine Learning
- c) Snowflake ML-powered alerts
- d) All of the above
Answer: D - Statistical models identify outliers automatically.
297. What is the purpose of SQL's DATABASE REPLAY?
- a) Benchmark workloads
- b) Test upgrades
- c) Diagnose performance
- d) All of the above
Answer: D - Oracle Database Replay, SQL Server Distributed Replay.
298. Which SQL feature enables multi-model document queries?
- a) JSON_TABLE
- b) XMLQUERY
- c) GRAPH_TRAVERSAL
- d) All of the above
Answer: D - Process JSON, XML, and graph data in single queries.
299. What is the purpose of SQL's DATABASE IN-MEMORY option?
- a) Faster analytics
- b) Real-time processing
- c) Hybrid workloads
- d) All of the above
Answer: D - Oracle In-Memory, SQL Server Columnstore.
300. Which database provides native chaos engineering tools?
- a) CockroachDB
- b) YugabyteDB
- c) Azure Cosmos DB
- d) All of the above
Answer: D - Simulate failures to test resilience.