多选题For which two tasks would it be best NOT to use the utility SQL*Loader？（）AWhen loading selected rows into each table.BWhen loading data from an export dump file.CWhen loading data from disk， tape， or named pipes.DWhen your data is NOT being inserted fr

题目
多选题
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.

相似考题

1.You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

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

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

4.SQ L*Loader is a utility that can perform which two tasks？（）A、Load data from a disk， tape， or named pipes.B、Load data into an Oracle database using DML statements.C、Extract， reorganize， and insert data within an Oracle database.D、Load data from external files into tables in an Oracle database.E、Load data into an Oracle database using operating system commands.F、Load data directly from a non-Oracle database to an Oracle database.

参考答案和解析
正确答案： C,D
解析： 暂无解析
更多“多选题For which two tasks would it be best NOT to use the utility SQL*Loader？（）AWhen loading selected rows into each table.BWhen loading data from an export dump file.CWhen loading data from disk， tape， or named pipes.DWhen your data is NOT being inserted fr”相关问题

  • 第1题：

    You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

    • A、MERGE
    • B、SELECT …CROSS JOIN
    • C、INSERT ALL …SELECT
    • D、CREATE VIEW …CONSTRAINT

    正确答案:A

  • 第2题：

    Which two statements are true regarding Oracle Data Pump（）

    • A、EXPDP and IMPDP are the client components of Oracle Data Pump.
    • B、DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
    • C、Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
    • D、Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
    • E、EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

    正确答案:A,B

  • 第3题：

    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

    正确答案:C

  • 第4题：

    Which two statements are true regarding the usage of the SQL*Loader utility（）

    • A、You can load data into multiple tables during the same load session.
    • B、You can load data from multiple files to a table during the same load session.
    • C、You cannot perform selective data loading based on the values available in the records.
    • D、You can use an export file generated by the EXPDP utility as an input data file to load the data.
    • E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

    正确答案:A,B

  • 第5题：

    In which situation would you use the Oracle Shared Server configuration？（）

    • A、when performing export and import using Oracle Data Pump
    • B、when performing backup and recovery operations using Oracle Recovery Manager
    • C、when performing batch processing and bulk loading operation in a data warehouse environment 
    • D、in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time

    正确答案:D

  • 第6题：

    Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL *Loader.
    • D、New data conforms to the constraint， but existing data is not checked.
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第7题：

    单选题
    In which situation would you use the Oracle Shared Server configuration？（）
    A

    when performing export and import using Oracle Data Pump

    B

    when performing backup and recovery operations using Oracle Recovery Manager

    C

    when performing batch processing and bulk loading operation in a data warehouse environment 

    D

    in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time


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

  • 第8题：

    多选题
    Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL *Loader.

    D

    New data conforms to the constraint， but existing data is not checked.

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第9题：

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


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

  • 第10题：

    多选题
    Which two statements are true regarding the usage of the SQL*Loader utility（）
    A

    You can load data into multiple tables during the same load session.

    B

    You can load data from multiple files to a table during the same load session.

    C

    You cannot perform selective data loading based on the values available in the records.

    D

    You can use an export file generated by the EXPDP utility as an input data file to load the data.

    E

    You can load data only if the input file is available on the disk and tape but not in a named pipes.


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

  • 第11题：

    多选题
    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
    A

    The constraint remains valid.

    B

    The index on the constraint is dropped.

    C

    It allows the loading of data into the table using SQL*Loader.

    D

    New data conforms to the constraint， but existing data is not checked

    E

    It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.


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

  • 第12题：

    多选题
    SQ L*Loader is a utility that can perform which two tasks？（）
    A

    Load data from a disk， tape， or named pipes.

    B

    Load data into an Oracle database using DML statements.

    C

    Extract， reorganize， and insert data within an Oracle database.

    D

    Load data from external files into tables in an Oracle database.

    E

    Load data into an Oracle database using operating system commands.

    F

    Load data directly from a non-Oracle database to an Oracle database.


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

  • 第13题：

    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.

    正确答案:B,D

  • 第14题：

    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

  • 第15题：

    Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem.  Which point describes the Oracle Data Pump utility（）

    • A、1
    • B、2
    • C、3
    • D、4
    • E、1 and 3
    • F、1， 2， 3， and 4

    正确答案:A

  • 第16题：

    Which statement is true about loading data using the conventional path of SQL*Loader（）

    • A、Redo is not generated while performing conventional path loads.
    • B、Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.
    • C、No exclusive locks are acquired when the conventional path loads are performed.
    • D、Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.
    • E、INSERT triggers are disabled before the conventional path load and reenabled at the end of the load

    正确答案:C

  • 第17题：

    Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）

    • A、The constraint remains valid.
    • B、The index on the constraint is dropped.
    • C、It allows the loading of data into the table using SQL*Loader.
    • D、New data conforms to the constraint， but existing data is not checked
    • E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

    正确答案:A,B,C

  • 第18题：

    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

    正确答案:D

  • 第19题：

    多选题
    Which two statements are true regarding the Oracle Data Pump export and import operations（）
    A

    You cannot export data from a remote database.

    B

    You can rename tables during an import operation.

    C

    You can overwrite existing dump files during an export operation.

    D

    You can compress the data during export but not the metadata because it is not supported.


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

  • 第20题：

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

  • 第21题：

    单选题
    Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem.  Which point describes the Oracle Data Pump utility（）
    A

    1

    B

    2

    C

    3

    D

    4

    E

    1 and 3

    F

    1， 2， 3， and 4


    正确答案： 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题：

    多选题
    Which two statements are true regarding Oracle Data Pump（）
    A

    EXPDP and IMPDP are the client components of Oracle Data Pump.

    B

    DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

    C

    Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

    D

    Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.

    E

    EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.


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

相关内容