Explanation

A view is a virtual table created from the result of a SQL query.

It does not store data itself but displays data dynamically from underlying tables.

Explanation

A database schema defines the logical structure of a database, including tables, fields, relationships, and constraints.

It acts as a blueprint that organizes how data is stored and accessed.

Explanation

A trigger is a database object that is automatically executed when specific events (INSERT, UPDATE, DELETE) occur.

Triggers are used to enforce rules, maintain integrity, and audit changes.

Explanation

Partitioning divides a large table into smaller, manageable parts based on ranges, lists, or hashes.

It improves query performance and maintenance efficiency, especially for large datasets.

Explanation

MAX(), SUM(), and AVG() all ignore NULL values during calculation.

Only non-NULL values are considered when computing SQL aggregate results.

Explanation

Optimistic locking assumes conflicts are rare and avoids holding locks during transactions.

By reducing lock holding time, it minimizes the chances of deadlocks.

Explanation

Cassandra is a column-oriented (wide-column) NoSQL database, where data is stored in column families.

It is designed for high scalability, high availability, and fast writes across distributed systems.

Explanation

A clustered index determines the physical order of data rows in a table.

Because data is stored in this order, it can significantly improve range query performance.

Explanation

Third Normal Form (3NF) eliminates transitive dependencies, where a non-key attribute depends on another non-key attribute.

It ensures that all non-key attributes depend only on the primary key, improving data integrity.

Explanation

Vector data can result in large file sizes when representing highly detailed or complex geometries.

This can make storage and processing slower compared to simpler datasets.

Despite this, vector data is excellent for precise location and network analysis.