Ch 24: Lossless Decomposition & Dependency Preservation

Horizontal partitioning is a high-volume database storage optimization technique. Which of the following correctly matches the standard horizontal partitioning types with their operational rules? 1. Range Partitioning - A. Assigns rows to partitions based on column values falling within a specified contiguous interval. 2. Hash Partitioning - B. Applies an algorithm to a partitioning key to evenly distribute rows across physical disks. 3. List Partitioning - C. Assigns rows to partitions based on key values matching a predefined set of discrete values.

-- Range Partitioning Example on Date column:
-- Partition 1: values < '2024-01-01'
-- Partition 2: values < '2025-01-01'

Under distributed database and physical design concepts, which of the following statements is TRUE regarding database replication?

Source Database (Lahore) ---> Synchronized Copy (Islamabad)