Question: To improve query performance, the Country table is partitioned as follows: CREATE TABLE Country ( Code INT, Name VARCHAR ( 1 5 ) , IndependenceDate

To improve query performance, the Country table is partitioned as follows:
CREATE TABLE Country (
Code INT,
Name VARCHAR(15),
IndependenceDate DATE,
Capital VARCHAR(15)
)
PARTITION BY RANGE (___(A)___(IndependenceDate))(
PARTITION p1 VALUES LESS THAN (___(B)___),
PARTITION p2 VALUES LESS THAN (1834),
PARTITION p3 VALUES LESS THAN (1867),
PARTITION p4 VALUES LESS THAN (1900),
PARTITION p5 VALUES LESS THAN ___(C)___
);Complete the values of A, B and C:
(A)
(B)
(C)# Less than 1800
# 1800 through 1833
# 1834 through 1866
# 1867 through 1899
# Greater than 1900

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!