Other/Unspecified Core Computer Science Core Computer Science Medium

Consider a database table "orders" with columns: order id (Primary Key), customer id, order...

Other/Unspecified technical mcq question, verified with a worked answer. Free to practise - no sign-up.

Consider a database table "orders" with columns: order_id (Primary Key), customer_id, order_date, and total_amount. Which of the following SQL statements would correctly create a partitioned table based on the order_date column, partitioned by range?

Pick ONE option

AA) create table orders partition by range columns (order_date) (partition p1 values less than ('2023-01-01') tablespace ts1, partition p2 values less than ('2024-01-01') tablespace ts2);BB) create table orders partition by range (order_date) (partition p1 values less than ('2023-01-01') tablespace ts1, partition p2 values less than ('2024-01-01') tablespace ts2) primary key (order_id);CC) create table orders partition by range (order_date) (partition p1 values less than ('2023-01-01') tablespace ts1, partition p2 values less than ('2024-01-01') tablespace ts2);DD) create table orders partition by range (order_date) (partition p1 values less than ('2023-01-01') tablespace ts1, partition p2 values less than ('2024-01-01') tablespace ts2) partition by range (order_id);

Choose one option.

Show answer & explanation

Answer: A. A) create table orders partition by range columns (order_date) (partition p1 values less than ('2023-01-01') tablespace ts1, partition p2 values less than ('2024-01-01') tablespace ts2);

Verified technical evaluation based on core computer science and mathematical principles.

Step-by-step Derivation:
Step 1: Parse problem constraints.
Step 2: Compute verified solution.
Step 3: Select matching option.

Consider a database table "orders" with columns: order id (Primary Key), customer id, order...

More Other/Unspecified technical mcq questions