单选题Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）A INDEXESB SKIP_INDEXES_MAINTENANCEC SKIP_UNUSABLE_INDEXESD RESUMABLEE INDEXES_UNUSABLE

题目
单选题
Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）
A

INDEXES

B

SKIP_INDEXES_MAINTENANCE

C

SKIP_UNUSABLE_INDEXES

D

RESUMABLE

E

INDEXES_UNUSABLE

相似考题

1.Examine the contents of SQL loader control file:Which three statements are true regarding the SQL* Loader operation performed using the control file?()A. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.C. The SQL* Loader operation fails because no record terminators are specified.D. Field names should be the first line in the both the SQL* Loader data files.E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

2.Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）A、ROWSB、SKIPC、LOADD、BINDSIZE

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

4.WhichparameterallowsSQL*Loadertoloaddataintoatablewiththeindexesintheunusablestate,priortotheloadoperation?()A.INDEXESB.SKIP_INDEXES_MAINTENANCEC.SKIP_UNUSABLE_INDEXESD.RESUMABLEE.INDEXES_UNUSABLE

更多“单选题Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）A INDEXESB SKIP_INDEXES_MAINTENANCEC SKIP_UNUSABLE_INDEXESD RESUMABLEE INDEXES_UNUSABLE”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity 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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    Which one of the following files contains records that do not meet the specified load criteria in the SQL*Loader control file？（）

    • A、Log file
    • B、Discard file
    • C、Parameter file
    • D、Bad file

    正确答案:B

  • 第8题：

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

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

    多选题
    On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）
    A

    It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

    B

    It fails because no SQL *Loader data file location is specified.

    C

    It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

    D

    It fails because no SQL *Loader control file location is specified.


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

  • 第11题：

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

  • 第12题：

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

    B

    conventional path load


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

  • 第13题：

    Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）

    • A、An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
    • B、The SQL* Loader data file myfile1.dat has the column names for the EMP table.
    • C、The SQL* Loader operation fails because no record terminators are specified.
    • D、Field names should be the first line in the both the SQL* Loader data files.
    • E、The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

    正确答案:A,B,E

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

    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

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）

    • A、INDEXES
    • B、SKIP_INDEXES_MAINTENANCE
    • C、SKIP_UNUSABLE_INDEXES
    • D、RESUMABLE
    • E、INDEXES_UNUSABLE

    正确答案: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.


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

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

    单选题
    Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）
    A

    ROWS

    B

    SKIP

    C

    LOAD

    D

    BINDSIZE


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

  • 第22题：

    单选题
    You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）
    A

    Create both jobs by using events raised by the scheduler

    B

    Create both jobs by using events raised by the application

    C

    Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler

    D

    Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application


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

  • 第23题：

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

相关内容