IBM(000-730)
单选题A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal o
题目
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.
相似问题和答案
第1题：
43 Which of the following networking methods allows us to show that the last 10% of one element cannot be completed until 62% of a previous element has been completed?
A. PERT
B. ADM
C. PDM
D. All of the above.
E. A and C only.
第2题：
A. Syslog
B. Audit log
C. History log
D. Ping sweep reports
第3题：
Which of the following networking methods allows us to show that the last % of one element cannot be completed until % of a previous element has been completed?
A.PERT
B.ADM
C.PDM
D.All of the above.
E.A and C only.
C
第4题：
Which of the following archiving methods only backs up data that has changed since the previous backup？（）
- A、Differential
- B、Copy
- C、Incremental
- D、Snapshot
正确答案:C
第5题：
Which of the following would contain information regarding network device alerts using SNMP?（）
- A、Syslog
- B、Audit log
- C、History log
- D、Ping sweep reports
正确答案:A
第6题：
A.It can support transactions
B.Table contents are not saved if the server is restarted
C.It cannot contain text or BLOB columns
D.It can support foreign keys
E.Each table is represented on disk as an.frm file
F.Each table has a corresponding.MYI and .MYD file
第7题：
B.interfered
C.disturbed
D.affected
第8题：
161 Which of the following networking methods allows us to show that the last 10% of one element cannot be completed until 62% of a previous element has been completed?
A. PERT
B. ADM
C. PDM
D. All of the above.
E. A and C only
第9题：
Which statement is true about the forwarding table?（）
- A、The forwarding table is stored in the control plane only.
- B、The forwarding table is stored in the control plane and in the forwarding plane.
- C、The forwarding table contains both active and inactive routes.
- D、The forwarding table can contain only a single next hop per destination.
正确答案:B
第10题：
A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）
- A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
- B、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.
- C、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.
- D、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.
正确答案:C