单选题You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）AUpgrade the hardware/memory to accommodate the data.BLoad the data into your database by using the PARALLEL clause.CGive analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.DUse an external table so you can have the metadata available in your database， but leave the data in the operating system files.
单选题
You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）
A
Upgrade the hardware/memory to accommodate the data.
B
Load the data into your database by using the PARALLEL clause.
C
Give analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.
D
Use an external table so you can have the metadata available in your database， but leave the data in the operating system files.
参考解析
解析：
暂无解析
相关考题：
—Do you like this coat , madam ?—Well, it’s a bit too large. Do you have this coat of () size? A、the smallerB、a smallerC、a smallestD、a small
Eggs, though rich in nourishments, have ________ of fat. A.the large numberB.the large amountC.a large numberD.a large amount
What about the commission? ().A、 Of course, I’d give you our lowest quotationB、 I’m afraid you have to tell me how large your order is going to beC、 It’s a general practice everywhere else
The people in this city have planted（）trees along both sides of the streets.Aa great deal ofBmuchCa large amount ofDa lot of
Eggs, though rich in nourishments, have（）of fat.Aa large numberBthe large numberCa large amountDthe large amount
Eggs, though rich in nourishments, have（）of fatAa large numberBthe large numberCa large amountDthe large amount
Eggs, though rich in nourishments, have（）of fat.A、a large numberB、the large numberC、a large amountD、the large amount
A customer has a large amount of data stored on three database servers and is concerned that at present there is no disaster recovery plan in place. They have an existing tape backup solution that meets their backup window. In order to analyze potential disaster recovery plans， which of the following questions is the most important？（）A、What is the minimum critical backup window？B、Which server is handling the most critical data？C、How much data is stored on each server？D、What is the throughput of the hard drives？
You want to track and store all transactional changes to a table over its lifetime. To accomplish this task， you enabled Flashback Data Archive with the retention of 5 years. After some time， the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this， you issued the following command： ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR； What is the implication of this command？（）A、 The command produces an error because the retention time cannot be reduced.B、 All historical data is retained but the subsequent flashback data archives are maintained for only three years.C、 All historical data is purged and the new flashback data archives are maintained for three years.D、 All historical data older than three years is purged from the flashback archive FLA1.
You are designing a Windows Azure application that will store data. You have the following requirements： - The data storage system must support the storage of more than 500 GB of data. - Data retrieval must be possible from a large number of parallel threads without threads blocking each other. You need to recommend an approach for storing data. What should you recommend？（）A、 Use Windows Azure Queues.B、 Use Windows Live Mesh 2011.C、 Use a single SQL Azure database.D、 Use Windows Azure Table storage
You have a Web application that is configured for personalization. You need to access personalization data from one of the pages of the Web application by using the minimum amount of administrative effort. What should you do? （）A、Access the personalization data from the Session property of the HttpContext object.B、Access the personalization data from the Application property of the HttpContext object.C、Access the personalization data from the Cache property of the HttpContext object.D、Access the personalization data from the Profile property of the HttpContext object.
Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? （）A、Modify the NTFS permissions on the Data folder.B、Modify the share permissions on the Data share.C、Add the domain administrator to the local Administrator’s group on Server1.D、Move the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.
You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） A、Create the database by using a single data file and a single log file.B、Create the database by using a single data file and multiple log files.C、Create the database by using a single log file and multiple filegroups.D、Create the database by using a single log file and a filegroup that has multiple data files.
You are implementing an ASP.NET page that will retrieve large sets of data from a data source. You add a ListView control and a DataPager control to the page. You need to ensure that the data can be viewed one page at a time. What should you do？（）A、Set the DataPager control’s PageSize property to the number of rows to view at one time.B、Set the DataPager control’s PagedControlID property to the ID of the ListView control.C、In the code-behind file， set the DataPager control’s Parent property to the ListView control.D、In the code-behind file， set the ListView control’s Parent property to the DataPager control.
单选题You are designing a Windows Azure application that will store data. You have the following requirements： - The data storage system must support the storage of more than 500 GB of data. - Data retrieval must be possible from a large number of parallel threads without threads blocking each other. You need to recommend an approach for storing data. What should you recommend？（）A Use Windows Azure Queues.B Use Windows Live Mesh 2011.C Use a single SQL Azure database.D Use Windows Azure Table storage
单选题When the fuel oil is burning in the combustion chamber, it （）.Agives up large amount of heatBgives off large amount of heatCgives up large amount of steamDgives off large amount of steam
单选题Eggs, though rich in nourishments, have（）of fatAa large numberBthe large numberCa large amountDthe large amount
单选题You want to track and store all transactional changes to a table over its lifetime. To accomplish this task， you enabled Flashback Data Archive with the retention of 5 years. After some time， the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this， you issued the following command： ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR； What is the implication of this command？（）A The command produces an error because the retention time cannot be reduced.B All historical data is retained but the subsequent flashback data archives are maintained for only three years.C All historical data is purged and the new flashback data archives are maintained for three years.D All historical data older than three years is purged from the flashback archive FLA1.
单选题- What about the commission？（）AOf course， I’d give you our lowest quotationBI’m afraid you have to tell me how large your order is going to beCIt’s a general practice everywhere else
单选题ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database. Which is the most effectivemethod to access this data in your database（）AUse the database link.BUse the SQL*Loader utility.CUse the Oracle Data Pump utility.DCreate an external table and leave the data in the flat file
单选题You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database（）AUse the database link.BUse the SQL*Loader utility.CUse the Oracle Data Pump utility.DCreate an external table and leave the data in the flat file
多选题You run a 16-bit scientific data analysis package on your Windows 2000 Professional computer. The package consists of three components. The first component is a data acquisition application that monitors continuous data output from scientific instruments. The second component is a data analysis application that receives data from the data acquisition application by using shared memory. The third component is a data graphing application that displays the processed data in real time. The data analysis application communicates with the data graphing application by using OLE. When you attempt to analyze large data sets, your computer is not able to display data in real time. You install a second processor in your computer; only one processor is used while the package is running, even though task manager shows both processors. You want your data analysis package to use both processors. What should you do?（）AConfigure the data acquisition application to run in its own virtual DOS machine (VDM).BConfigure the data analysis application to run in its own virtual DOS machine (VDM).CConfigure the data graphing application to run in its own virtual DOS machine (VDM).DConfigure the virtual DOS machine for the data acquisition and data analysis applications to.have a hard affinity for processor 0. Configure the VDM for the data graphing application to.have a hard affinity for processor1.EConfigure the virtual DOS machine for the data acquisition to have a hard affinity for processor 0. Configure the VDM for the data graphing application to have a hard affinity for processor1.
单选题You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）AUpgrade the hardware/memory to accommodate the data.BLoad the data into your database by using the PARALLEL clause.CGive analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.DUse an external table so you can have the metadata available in your database， but leave the data in the operating system files.
单选题Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? （）AModify the NTFS permissions on the Data folder.BModify the share permissions on the Data share.CAdd the domain administrator to the local Administrator’s group on Server1.DMove the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.
单选题You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）AClick the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. CSelect the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. DSelect the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. ELaunch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
单选题You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）AThe command produces an error because the retention period cannot be reducedBAll historical data older than 3 years is purged from the flashback archive FLA1CAll historical data is retained but the subsequent flashback data archives are maintained for only 3 yearsDAll historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time
单选题You are implementing an ASP.NET page that will retrieve large sets of data from a data source. You add a ListView control and a DataPager control to the page. You need to ensure that the data can be viewed one page at a time. What should you do？（）ASet the DataPager control’s PageSize property to the number of rows to view at one time.BSet the DataPager control’s PagedControlID property to the ID of the ListView control.CIn the code-behind file， set the DataPager control’s Parent property to the ListView control.DIn the code-behind file， set the ListView control’s Parent property to the DataPager control.