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.
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.
相关考题：
A new internal auditor, Daisy Rosepetal, has recently joined Bluebell Co. She has been asked by management toestablish and to monitor a variety of social and environmental Key Performance Indicators (KPIs). Daisy has noexperience in this area, and has asked you for some advice. It has been agreed with Bluebell Co’s audit committeethat you are to provide guidance to Daisy to help her in this part of her role, and that this does not impair theobjectivity of the audit.(c) Recommend EIGHT KPIs which could be used to monitor Bluebell Co’s social and environmentalperformance, and outline the nature of evidence that should be available to provide assurance on theaccuracy of the KPIs recommended. Your answer should be in the form. of briefing notes to be used at ameeting with Daisy Rosepetal. (10 marks)Note: requirement (c) includes 2 professional marks.
You have been asked to create a static route with a next hop that is not directly connected to the router. Which configuration parameter enables the static route to accomplish this scenario?() A. resolveB. indirectC. next-hopD. recursive
You have been asked to establish reachability between Router 1‘s and Router 2‘s loopback addresses as shown in the exhibit. Which two steps will accomplish this task?() A. Create a static route on Router 1 to 172.17.28.1 with a next hop of 10.10.10.2.B. Create a static route on Router 1 to 172.17.28.1 with a next hop of 10.10.10.1.C. Create a static route on Router 2 to 172.17.25.1 with a next hop of 10.10.10.1.D. Create a static route on Router 1 to 172.17.25.1 with a next hop of 10.10.10.2.
Certkiller .com has asked you to create a file management application to monitor the hosts file.Certkiller .com has instructed you to change the hosts file if it has been changed.You, therefore, need to display the size and whether the hosts file is set to read-only.What should you do?（）A.B.C.D.
Refer to the exhibit. Switch port FastEthernet 0/24 on AlSwitch1 will be used to create an IEEE 802.1Q- complaint trunk to another switch. Based on the output shown, What is the reason the trunk does not form, even thought the proper cabling has been attached?（）A.VLANs have not been created yetB.An IP address must be configured for the portC.The port is currently configured for access modeD.The correct encapsulation type has not been configuredE.The no shutdown command has not been entered for the port
It has always been our company's ( ) to encourage employeesto use their talents and create more wealth.A. policyB. procedureC. campaignD. Plan
A large sum of money has been allocated ated for buying new books for the library.A:assigned B:persuadedC:asked D:ordered
Management has asked the server technician to deploy fourteen new servers with newly-released operating systems in the virtual environment for testing purposes. Which of the following is the FASTEST way to do this？（）A、Create a template of an existing server and deploy the fourteen images from that server.B、Create a server template， and deploy all fourteen servers from this template.C、Create one server， create a backup image， and restore thirteen servers from the image.D、Create each server individually.
You have been asked to use a 28 bit subnet mask to segment the following network block: 108.12.5.0. How many usable hosts per sub-net could you create?（）A、10 hostsB、14 hostsC、12 hostsD、16 hosts
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 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 technician has been given a task to create a separate location for disaster recovery. Thecompany has very high uptime requirements and will lose money if there is any downtime. Whichof the following deployments should the technician consider？（）A、Hot siteB、Warm siteC、Fault tolerant siteD、Cold site
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、applyB、cleanupC、commitD、reject
A system administrator has been asked to lock a specific login account. Which of the following commands is used to accomplish this？（）A、pwdckB、usrckC、chuserD、rmuser
A system administrator has been asked to document the hardware configuration of a system. Which command can be used to assist in this task？（）A、lscfgB、mkdevC、lslppD、cfgmgr
Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）A、The table created by SKD is not accessible and SKD cannot create new tables.B、The tables created by SKD and HR remain， but both cannot create new tables.C、The table created by HR remains and HR still has the CREATE TABLE system privilege.D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）A、the alert.log fileB、the DBA_ALERTS viewC、the Database Control Home pageD、the Database Control performance pageE、the Database Control Maintenance page
TestKing.com has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user. What are two possible ways to achieve this goal？（）A、Create a function that returns a list of values that represent the login times for the given user.B、Create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.C、Create a function that returns a numeric value that represents the number of hours that a user has logged for the current day.D、Create a function that returns a numeric value that represents the number of hours that a user has logged for the current month.
单选题You work as an application developer at Certkiller .com. You have been asked by you superiors at Certkiller .com to create a child application domain. The new child application domain has to specify a different assembly path than that of the parent application domain.You need to ensure that your solution meets Certkiller .com’s requirements.What should you do？（）A AB BC CD D
单选题The company’s ______ regarding casual dress has been revised in order to create a friendly working environment.ApolicyBpreparationCsymbolDcustoms
单选题Examine the following steps performed on a database instance： 1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2：The SKD usercreates a table. 3：The SKD user grants theCREATETABLE system privilege to the HR user. 4：The HR user creates a table. 5：The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 is performed（）AThe table created by SKD isnot accessibleand SKD cannot create new tables.BThe tables created by SKD and HR remain， but both cannot create new tables.CThe table created by HR remains and HR still has the CREATE TABLE system privilege.DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
填空题What has been done by the heating system supplier?____ has been asked to find out the cause of the accident.
单选题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.
多选题As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL select group_number， name， state from v$ASM_DISKGROUP； GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTEDAThe DGROUP1 disk group was unmounted by another DBA.BA datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED stateCOne of the redundant disks （DGROUP1） has been lost in a disk group.DThis query has no meaning in an ASM instance.EA disk associated with a disk group was discovered after the ASM instance initially opened.
单选题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
单选题Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）AThe table created by SKD is not accessible and SKD cannot create new tables.BThe tables created by SKD and HR remain， but both cannot create new tables.CThe table created by HR remains and HR still has the CREATE TABLE system privilege.DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
单选题You have been asked to create a static route with a next hop that is not directly connected to the router. Which configuration parameter enables the static route to accomplish this scenario？（）AresolveBindirectCnext-hopDrecursive