单选题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

题目
单选题
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 population

B

use the Oracle Data Pump export and import utility

C

use the conventional path data load of SQL*Loader utility

D

use the direct path data load of Oracle export and import utility

相似考题

1.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.

2.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 fileB. 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

3. 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

4.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.

更多“You are using flat files as the data source for one of your ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    多选题
    For which two tasks would it be best NOT to use the utility SQL*Loader？（）
    A

    When loading selected rows into each table.

    B

    When loading data from an export dump file.

    C

    When loading data from disk， tape， or named pipes.

    D

    When your data is NOT being inserted from a flat file.

    E

    When using a record management system to access data files.


    正确答案： E,C
    解析： 暂无解析

  • 第5题：

    单选题
    You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）
    A

    Use the DROP DATAFILE command.

    B

    Use the DROP TABLESPACE command.

    C

    Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.

    D

    Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.


    正确答案： D
    解析： 暂无解析

  • 第6题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第7题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    多选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）
    A

    Only the data files.

    B

    All of the data files and the control files.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    Only the data files belonging to the SYSTEM tablespace and the control files.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    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 data 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


    正确答案： A
    解析： 暂无解析

  • 第12题：

    多选题
    You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）
    A

    Restore the lost data file from the backup， and then flash back the database.

    B

    Restore the data file pertaining to index tablespace， and then recover the tablespace.

    C

    Restore all the data files， and then perform an incomplete recovery to get the tablespace back.

    D

    Restore all the data files， and then perform an incomplete recovery using the backup control file.

    E

    Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.


    正确答案： D,A
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    单选题
    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 data file in a different location while resto ing 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


    正确答案： B
    解析： 暂无解析

  • 第17题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第18题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第20题：

    多选题
    You work as a database administrator for Certkiller .com. 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
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    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 population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution by using SQL Server 2008. Several reports on the server use a shared data source named DSProduction. You modify an existing report that uses the DSProduction data source. After deployment， the modified report must use an alternate data source. You need to prevent the modified report from affecting other reports. What should you do？（）
    A

     Update the connection string of the DSProduction shared data source to point to the alternate data source.

    B

     Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.

    C

     Create a new shared data source named DSProduction in the same folder as that of the modified report. Update the connection string of the new shared data source to point to the alternate data source.

    D

     Disable the DSProduction data source. Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    Your network consists of a single Active Directory domain. All servers run Windows Server 2008 R2.   All client computers run Windows 7. Some users have laptop computers and work remotely from home.   You need to plan a data provisioning infrastructure to secure sensitive files. Your plan must meet the following requirements:   èFiles must be stored in an encrypted format.   èFiles must be accessible by remote users over the Internet.   èFiles must be encrypted while they are transmitted over the Internet. What should you include in your plan?（）
    A

    Deploy one Microsoft SharePoint Foundation 2010 site. Require users to access the SharePoint site by using a Secure Socket Transmission Protocol （SSTP） connection.

    B

    Deploy two Microsoft SharePoint Foundation 2010 sites.Configure one site for internal users. Configure the other site for remote users. Publish the SharePoint sites by using HTTPS.

    C

    Configure a Network Policy and Access Services （NPAS） server to act as a VPN server. Require remote users to access the files by using an IPsec connection to the VPN server.

    D

    Store all sensitive files in folders that are encrypted by using Encrypting File System （EFS）. Require  remote users to access the files by using Secure Socket Transmission Protocol （SSTP）.


    正确答案： A
    解析： 暂无解析

相关内容