单选题
发布日期:2020-04-10
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.
标签: dba asked create table substantial
题王网让考试变得更简单
扫码关注题王,更多免费功能准备上线!
此试题出现在
其他考试
如何对支持装置进行检查?
凡我国公民都平等地享有宪法和法律规定的各项权利,但可以不平等地履行宪法和法律规定的各项义务。
以下人力资源需求预测的定量方法中,最复杂的一种是()。
25岁初孕妇,妊娠39周,不规律宫缩有2日,阴道少许血性黏液,查血压136/96mmHg,子宫长度38cm,腹围106cm,胎心158次/分,宫缩持续32秒,间隔5分钟,肛查宫口1cm,缩宫素激惹试验出现早期减速。本例诊断正确的是()
三种路由协议RIP、OSPF、BGP各自得到了一条到达目标网络,在思科路由器默认情况下,网络最终选定()路由作为最优路由
妇女节前夕(打一中草药)。
对现行的工作结构、工作流程、工作方法、工作技术要求等方面进行重新调整、革新。这种工作称之为()。
中国的佛塔类型主要有( )。
江苏省“营改增”试点工作成功启动的标志是中国外运长江有限责任公司顺利开出第一张增值税专用发票。
防爆型F扳手采用优质()材料制作。
暂无相关推荐~
A DBA has been asked to create a table which will contain a substantial amount o...
A senior DBA asked you to execute the following command to improve performance: ...
You are the DBA for an academic database. You need to create a role that allows ...
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privi...
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What pri...
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What pri...
You are the DBA for an academic database. You need to create a role that allows ...
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What pri...
Certkiller .com has asked you to create a file management application to monitor...
A customer asked a consultant to create the infrastructure for an application. ...