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

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

相似考题

1.Which two statements about the SQL Management Base (SMB) are true?()A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It is part of the data dictionary and stored in the SYSTEM tablespace.E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

2.Which statement is true about a routing table?（）A、It contains routers learned dynamically onlyB、It finds the best path to each destination by using a modified shortest-path-first calculationC、It contains only active BGP routesD、It contains all accepted routes to all destinations

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.SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）A、direct-path loadB、conventional path load

更多“单选题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 acquire”相关问题

  • 第1题：

    Which statement is true about a routing table?（）

    • A、It contains routes learned dynamically only.
    • B、It finds the best path to each destination by using a modified shortest-path-first calculation.
    • C、It contains only active BGP routes.
    • D、It contains all accepted routes to all destinations.

    正确答案:D

  • 第2题：

    Which two statements are true about constraints? （）

    • A、The UNIQUE constraint does not permit a null value for the column.
    • B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
    • C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
    • D、The NOT NULL constraint ensures that null values are not permitted for the column.

    正确答案:B,D

  • 第3题：

    Which two statements are true about a bitmap index？ （）

    • A、It is recommended for the columns that have unique values.
    • B、It can be converted to a B-tree index by using the ALTER INDEX command.
    • C、It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.
    • D、Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

    正确答案:C,D

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）

    • A、One runs faster than the other
    • B、A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
    • C、A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
    • D、The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE

    正确答案:C

  • 第7题：

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


    正确答案： 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 about constraints? （）
    A

    The UNIQUE constraint does not permit a null value for the column.

    B

    A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

    C

    The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

    D

    The NOT NULL constraint ensures that null values are not permitted for the column.


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

  • 第11题：

    多选题
    Which two statements are true about the primary key constraint in a table？ （）
    A

    It is not possible to disable the primary key constraint.

    B

    It is possible to have more than one primary key constraint in a single table.

    C

    The primary key constraint can be referred by only one foreign key constraint.

    D

    The primary key constraint can be imposed by combining more than one column.

    E

    The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.


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

  • 第12题：

    单选题
    Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）
    A

    One runs faster than the other

    B

    A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT

    C

    A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT

    D

    The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE


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

  • 第13题：

    Which two statements are true about the primary key constraint in a table？ （）

    • A、It is not possible to disable the primary key constraint.
    • B、It is possible to have more than one primary key constraint in a single table.
    • C、The primary key constraint can be referred by only one foreign key constraint.
    • D、The primary key constraint can be imposed by combining more than one column.
    • E、The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.

    正确答案:D,E

  • 第14题：

    Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)

    • A、It contains only SQL profiles generated by SQL Tuning Advisor.
    • B、It stores plans generated by the optimizer using a stored outline.
    • C、It is part of the data dictionary and stored in the SYSAUX tablespace.
    • D、It is part of the data dictionary and stored in the SYSTEM tablespace.
    • E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

    正确答案:C,E

  • 第15题：

    In which two scenarios do you use SQL* Loader to load data?（）

    • A、Transform the data while it is being loaded into the database.
    • B、Use transparent parallel processing without having to split the external data first.
    • C、Load data into multiple tables during the same load statement.
    • D、Generate unique sequential key values in specified columns.

    正确答案:A,D

  • 第16题：

    You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

    • A、CHECK
    • B、UNIQUE
    • C、NOT NULL
    • D、PRIMARY KEY
    • E、FOREIGN KEY

    正确答案:B,C,D

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

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

  • 第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题：

    单选题
    View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY （emp_id）   USING INDEX emp_id_idx；   Which statement is true regarding the effect of the command？（）
    A

     The PRIMARY KEY is created along with a new index.

    B

     The PRIMARY KEY is created and it would use an existing unique index.

    C

     The PRIMARY KEY would be created in a disabled state because it is using an existing index.

    D

     The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.


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

  • 第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 statement is true about a routing table?（）
    A

    It contains routers learned dynamically only

    B

    It finds the best path to each destination by using a modified shortest-path-first calculation

    C

    It contains only active BGP routes

    D

    It contains all accepted routes to all destinations


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

  • 第24题：

    单选题
    Which statement is true about a routing table?（）
    A

    It contains routes learned dynamically only.

    B

    It finds the best path to each destination by using a modified shortest-path-first calculation.

    C

    It contains only active BGP routes.

    D

    It contains all accepted routes to all destinations.


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

相关内容