单选题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?（）ACreate an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.BCreate 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.CCreate a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.DCreate 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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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.PERTB.ADMC.PDMD.All of the above.E.A and C only.
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. PERTB. ADMC. PDMD. All of the above.E. A and C only
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. PERTB. ADMC. PDMD. All of the above.E. A and C only.
Which three statements are characteristic of the MEMORY storage engine?() A.It can support transactionsB.Table contents are not saved if the server is restartedC.It cannot contain text or BLOB columnsD.It can support foreign keysE.Each table is represented on disk as an.frm fileF.Each table has a corresponding.MYI and .MYD file
Which of the following would contain information regarding network device alerts using SNMP?() A. SyslogB. Audit logC. History logD. Ping sweep reports
Consequently,there has been a growing interest in natural foods:foods which do not contain additives and which have not been（ ）by chemical fertilizers widely used in farming today.A.effectedB.interferedC.disturbedD.affected
Which of the following would contain information regarding network device alerts using SNMP?（）A、SyslogB、Audit logC、History logD、Ping sweep reports
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.
Which of the following archiving methods only backs up data that has changed since the previous backup？（）A、DifferentialB、CopyC、IncrementalD、Snapshot
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.
Which of the following are TRUE about a store archive？（）A、It is an XML file containing store data assetsB、It uses the same file format as a ZIP fileC、It contains file assets to create a store or siteD、It can easily be copied from one machine to anotherE、It can contain WebSphere Commerce instance configuration information
Which statement is true about the forwarding table?（）A、The forwarding table is stored in the control plane onlyB、The forwarding table is stored in the control plane and in the forewarding planeC、The forwarding table contains both active and inactive routesD、The forwarding table can contain only sigle next hop per destination
As A DBA， which of the following methods can you use to make a backup of your table？（）A、Recover Manager （RMAN） utilityB、Import utilityC、Export utilityD、O/S backup command
In which scenario， will you issue the following command？（） RMAN REPORT NEED BACKUP DAYS 7；A、 to configure RMAN to maintain backup information in the RMAN repository for seven daysB、 to configure RMAN to maintain backup information in the control file for at least seven daysC、 to display the list of files that have not been backed up for the last seven daysD、 to display the list of files that must be backed up within seven days
Which three statements are characteristic of the MEMORY storage engine?（）A、It can support transactionsB、Table contents are not saved if the server is restartedC、It cannot contain text or BLOB columnsD、It can support foreign keysE、Each table is represented on disk as an.frm fileF、Each table has a corresponding.MYI and .MYD file
You are designing an application for Certkiller .com 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 dataB、 create an index cluster to store the dataC、 create a partitioned table to store the dataD、 create a sorted hash cluster to store the dataE、 create a heap table with rowid to store the data
单选题As A DBA， which of the following methods can you use to make a backup of your table？（）ARecover Manager （RMAN） utilityBImport utilityCExport utilityDO/S backup command
单选题Which of the following archiving methods only backs up data that has changed since the previous full backup?（）ASnapshotBIncrementalCCopyDDifferential
单选题Which statement is true about the forwarding table?（）AThe forwarding table is stored in the control plane only.BThe forwarding table is stored in the control plane and in the forwarding plane.CThe forwarding table contains both active and inactive routes.DThe forwarding table can contain only a single next hop per destination.
单选题In which scenario， will you issue the following command？（） RMAN REPORT NEED BACKUP DAYS 7；A to configure RMAN to maintain backup information in the RMAN repository for seven daysB to configure RMAN to maintain backup information in the control file for at least seven daysC to display the list of files that have not been backed up for the last seven daysD to display the list of files that must be backed up within seven days
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a user in the Windows SalesManagers group， and he is called Simon. A Reporting Services report is required by Simon to have annual sales information displayed by territory. There is another user in the Windows Sales group， and he is called Jack. He is responsible to report to Simon. A report is required by Jack， and the report is limited to his sales territory， but the same detailed sales data is still displayed， and the detailed sales data is on Simon’s report. A secure solution should be designed to meet the requirements of the users listed above， and the least amount of server resources should be utilized. Which action should be performed？（）AFirst， all territory information should be contained by a parameterized report which is designed for Simon. Second， a linked report that links to Simons report should be designed for Jack.BFirst， two data regions should be contained by a report which is designed for Simon. Second， one data region should be utilized for summary sales data. Third， the other data region should be utilized for the detailed sales data for each sales representative. Four， a report that displays the detailed sales data should be designed for Jack.CFirst， two reports should be designed for Simon. Second， the territory information should be contained by one， and the detailed sales data should be contained by another. At last， a report that displays the detailed sales data for Jack’s territories should be designed for Jack.DFirst， the territory information should be contained by a report which is designed for Simon. Second， a report which detailed sales data for Jack’s territories is contained should be designed for Jack. Third， Simon’s report should be set to have the data in Jacks report contained.
单选题Which statement is true about the forwarding table?（）AThe forwarding table is stored in the control plane onlyBThe forwarding table is stored in the control plane and in the forewarding planeCThe forwarding table contains both active and inactive routesDThe forwarding table can contain only sigle next hop per destination
单选题Which of the following would contain information regarding network device alerts using SNMP?（）ASyslogBAudit logCHistory logDPing sweep reports
单选题The company auditors require a System p administrator to archive detailed information from each of their systems. Which of the following commands will accomplish this task（）Asnap -aBsnap -iCprtconfDlsconf
单选题Which of the following archiving methods only backs up data that has changed since the previous backup？（）ADifferentialBCopyCIncrementalDSnapshot
单选题You are designing an application for Certkiller .com 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 dataB create an index cluster to store the dataC create a partitioned table to store the dataD create a sorted hash cluster to store the dataE create a heap table with rowid to store the data
单选题A system administrator has been asked to lock a specific login account. Which of the following commands is used to accomplish this？（）ApwdckBusrckCchuserDrmuser