CMS专题
单选题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 wa
题目
Use the external table population.
Use the Oracle Data Pump export and import utility.
Use the conventional path data load of the SQL*Loader utility.
Use the INSERT INTO...SELECT command to load the data
参考答案和解析
相似问题和答案
第1题：
In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file.Which option must you consider for this task?（）
A. using only the RMAN SWITCH command to set the new location for the data file
B. placing the database in the MOUNT state for the restore and recovery operations.
C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
D. configuring two channels: one for the restore operation and the other for the recovery operation
第2题：
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）
- A、A backup of the target database when it is mounted
- B、A backup of online redo log files when the database is open
- C、A backup of only used data blocks in the file beingbeingbackup up
- D、A backup of online， read/write data files when the database is open
- E、A backup of only those data blocks that have changed since a previous backup
- F、A backup of online， read/write data files when the database is in the NOMOUNT state.
正确答案:A,C,D,E
第3题：
You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change.
You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package.
Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two)
A．Enable the Always read properties from UDL file option in the Connection Properties dialog box.
B．Disable the Always read properties from UDL file option in the Connection Properties dialog box.
C．Delete the .udl files and store connection details in the registry by using system data source names.
D．Delete the .udl files, and store connection details in the registry by using user data source names.
E．Make the .udl files available on a network share.
解析：Explanation:
A: To make the connection information available for the developers we must enable the Always read properties from UDL file option.
E: We provide the developers with access to the .udl file by placing the .udl files in a network share and setting appropriate share and NTFS permissions.
Note: In SQL Server 2000, DTS packages can use Microsoft Data Link (.udl) files to create OLE DB connections and resolve the connections in run time. With this feature we can encapsulate the connection properties from a DTS package into a separate file and can edit the connection string in a .udl file instead of the connection properties in a DTS package in situations where connection information such as the server name, login, or even the OLE DB provider may change.
When specifying a data link connection, we must first specify whether to load an existing .udl file or create a data link to save with DTS Designer. If we want to use a .udl file rather than saving the data link with DTS Designer, we can create one either from Windows Explorer or during the data link configuration process in DTS Designer. We must then click Microsoft Data Link in the Data Source list of the Connection Properties dialog box and check the Always read properties from UDL file check box. In this scenario, the .udl file is already specified.
Incorrect Answers:
B: If we clear the Always read properties from UDL file option in the Connection Properties dialog box, we would have to edit the connection properties through the Data Transformation Services (DTS) package. This would increase administrative effort.
C: We cannot delete the .udl files and instead store the connection details in the registry by using system data source names as the connection details change regularly.
D: We cannot delete the .udl files, and instead store connection details in the registry by using user data source names as the connection details change regularly.
第4题：
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.
正确答案:B
第5题：
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2； Which components are included in the backup？（）
- A、Only the data files.
- B、Only the data files and the online logs.
- C、The data files， control files， and the online logs.
- D、The data files and control files， but not the online logs.
正确答案:D
第6题：
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
正确答案:C
第7题：
Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）
- A、 redo logs
- B、 control file
- C、 temporary files of temporary tablespace
- D、 the latest backup of only the damaged data file
- E、 the latest backup of all the data files In the USERS tablespace
正确答案:A,B,D
第8题：
Exhibit: You are developing a Web application. The Web application uses a GridView control to display data. You build your Web Forms for the Web application by dragging and dropping tables from the Data Connections tree in Server Explorer. You need to add a connection to your data by using the Add Connection dialog box as shown in the exhibit. During the process, you need to configure the .NET Data Provider that you use to create the data source objects. What should you do?（）
A. Right-click the connection, and click Properties. Modify the Provider property of the data connection.
B. Click the Change button, and change the data provider for the selected data source.
C. Click the Advanced button, and change the Data Source property to the target provider.
D. Click the Advanced button, and change the Application Name property to the target provider.
第9题：
If you create your database using Oracle Managed Files （OMF）， what is true？（）
- A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures.
- B、You must define directories for two online redo log groups and three copies of the control file.
- C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.
- D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.
正确答案:D
第10题：
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.
正确答案:C