网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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（）
A
Use the database link.
B
Use the SQL*Loader utility.
C
Use the Oracle Data Pump utility.
D
Create 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（）A Use the database link.B Use the SQL*Loader utility.C Use the Oracle Data Pump utility.D Create an external table and leave the data in the flat file” 相关考题
考题
—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
考题
You are the administrator of a Windows 2000 Server computer. A folder named HR-Data on the system partition of the server is shared on the network as HR-Data. The owner of the HR-Data folder is Administrators.The shared permissions and NTFS permissions are shown in the following table.Share permissions:Everyone: FULL ControlNTFS permissionsDomain Admins: ReadKatrin: Full ControlKatrin creates a file in the HR-Data folder. She sets the NTFS permissions for the file to list only herself on the access control list, with Full Control permission. Katrin then leaves on vacation and cannot be contacted.Later, you discover that the file contains sensitive information and must be removed from the server as soon as possible. You want to delete the file without modifying any of the permissions for other files in the HR-Data folder. You want your actions to have least possible impact on users who may be using other files in the HR-Data folder. You want to use the minimum amount of authority necessary to delete the file.What should you do?A．Grant yourself Full Control permission for only the HR-data folder and not its subobjects. Delete the file. Then remove Full Control permission for HR-Data folder.B．Take ownership of the HR-Data folder. When prompted, take ownership of the existing files. Grant yourself Full Control permission for the file. Delete the file.C．Take ownership of the file. Grant yourself Modify permission for the file. Delete the file.D．Grant yourself Modify permission for the HR-Data folder and its subobjects. Delete the file. Then remove Modify permission for the HR-Data folder.
考题
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
考题
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database（）A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data
考题
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 work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（） A、You should run the bulk copy program utility along with an output file and no format fileB、You should run the SQLCmd utility and save the output to a fileC、You should run the SQL Import and Export Data Wizard and save the output to a file.D、You should run the bulk copy program utility along with a format file and an output file.
考题
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.
考题
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
考题
单选题Eggs, though rich in nourishments, have（）of fatA
a large numberB
the large numberC
a large amountD
the 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.
考题
单选题You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）A
Decrease the amount of time between transaction log backups.B
Configure the database to use the simple recovery model.C
Configure the RECOVERY INTERVAL option to be a smaller value.D
Run DBCC SHRINKFILE on the transaction log file.
考题
单选题You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）A
Use the external table population.B
Use the Oracle Data Pump export and import utility.C
Use the conventional path data load of the SQL*Loader utility.D
Use the INSERT INTO...SELECT command to load the data.
考题
单选题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（）A
Use the database link.B
Use the SQL*Loader utility.C
Use the Oracle Data Pump utility.D
Create 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（）A
Use the database link.B
Use the SQL*Loader utility.C
Use the Oracle Data Pump utility.D
Create an external table and leave the data in the flat file
考题
单选题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.
考题
单选题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 are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）A
use the external table populationB
use the Oracle Data Pump export and import utilityC
use the conventional path data load of SQL*Loader utilityD
use the direct path data load of Oracle export and import utility
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this， you save the package definition to a file. Now you have to reexecute the package from the command line. In the options below， which utility should you choose to use？（）A
bcp.exe B
dta.exe C
dtexec.exe D
sqlmaint.exe
考题
单选题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?（）A
The command produces an error because the retention period cannot be reducedB
All historical data older than 3 years is purged from the flashback archive FLA1C
All historical data is retained but the subsequent flashback data archives are maintained for only 3 yearsD
All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time
热门标签
最新试卷
