CMS专题
单选题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题：
You notice that during peak hours, some firewall enforcers contain a high number of auth table entries. As you investigate the issue, you discover that all users are getting auth table mappings to all firewalls, which is not acceptable.What should you do on the Junos Pulse Access Control Service to resolve this problem?（）
A. Delete the default auth table mapping policy
B. Create auth table mapping policies that route users to specific resources
C. Create Resource Access policies that permit access to specific resources
D. Create Source Interface policies that route users to specific resources
第2题：
B.interfered
C.disturbed
D.affected
第3题：
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
第4题：
A system administrator has been asked to install an APAR but wants to be able to easily remove it. Which install option should be used？（）
- A、apply
- B、cleanup
- C、commit
- D、reject
正确答案:A
第5题：
You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order. Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）
- A、create a hash cluster to store the data
- B、create an index cluster to store the data
- C、create a partitioned table to store the data
- D、create a sorted hash cluster to store the data
- E、create a heap table with rowid to store the data
正确答案:D
第6题：
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）
A.REFERENCES
B.SELECT
C.UPDATE
D.ALTER
第7题：
While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
- A、A primary key must have been created.
- B、A mapping table must have been created.
- C、An overflow tablespace must have been specified.
- D、The PCTTHRESHOLD option must have been specified.
正确答案:B
第8题：
The STUDENT_GRADES table has these columns:The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?（）
A.
B.
C.
D.
E.
F.
第9题：
While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
- A、A primary key must have been created.
- B、A mapping table must have been created.
- C、An overflow tablespace must have been specified.
- D、The PCTTHRESHOLD option must have been specified.
正确答案: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