单选题
发布日期:2022-07-01
Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.
Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.
标签: "暂无标签"
题王网让考试变得更简单
扫码关注题王,更多免费功能准备上线!
此试题出现在