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 thi

题目

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
相似考题

1.You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.What should you do?A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.

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

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

4.Which two are attributes of ／SQL*Plus? ()A. /SQL*Plus commands cannot be abbreviated.B. /SQL*Plus commands are accesses from a browser.C. /SQL*Plus commands are used to manipulate data in tables.D. /SQL*Plus commands manipulate table definitions in the database.E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.

参考答案和解析
正确答案:A
更多“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 thi”相关问题

  • 第1题：

    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,D

  • 第2题：

    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.

    正确答案:A,C

  • 第3题：

    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

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

    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）

    • A、It fails to delete the records because the records are locked in SHARE mode.
    • B、It deletes the rows successfully because the table is locked in SHARE mode
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第6题：

    Which two are attributes of iSQL*Plus? （）

    • A、/SQL*Plus commands cannot be abbreviated.
    • B、/SQL*Plus commands are accessed from a browser.
    • C、/SQL*Plus commands are used to manipulate data in tables.
    • D、/SQL*Plus commands manipulate table definitions in the database.
    • E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

    正确答案:C,E

  • 第7题：

    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

  • 第8题：

    多选题
    Which two are attributes of /SQL*Plus? （）
    A

    /SQL*Plus commands cannot be abbreviated.

    B

    /SQL*Plus commands are accesses from a browser.

    C

    /SQL*Plus commands are used to manipulate data in tables.

    D

    /SQL*Plus commands manipulate table definitions in the database.

    E

    /SQL*Plus is the Oracle proprietary interface for executing SQL statements.


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

  • 第9题：

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

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

    单选题
    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）
    A

    It fails to delete the records because the records are locked in SHARE mode.

    B

    It deletes the rows successfully because the table is locked in SHARE mode

    C

    It fails to delete the records because the table is locked in EXCLUSIVE mode.

    D

    It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.


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

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

    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

  • 第14题：

    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

  • 第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 SQL*Loader instructions are used to assemble logical records？（）

    • A、WHEN
    • B、INFILE
    • C、CONTINUEIF
    • D、CONCATENATE
    • E、TRAILING NULLCOLS

    正确答案:C,D

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

    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

  • 第19题：

    Which two are attributes of /SQL*Plus? （）

    • A、/SQL*Plus commands cannot be abbreviated.
    • B、/SQL*Plus commands are accesses from a browser.
    • C、/SQL*Plus commands are used to manipulate data in tables.
    • D、/SQL*Plus commands manipulate table definitions in the database.
    • E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.

    正确答案:C,D

  • 第20题：

    多选题
    Which two are attributes of iSQL*Plus? （）
    A

    /SQL*Plus commands cannot be abbreviated.

    B

    /SQL*Plus commands are accessed from a browser.

    C

    /SQL*Plus commands are used to manipulate data in tables.

    D

    /SQL*Plus commands manipulate table definitions in the database.

    E

    /SQL*Plus is the Oracle proprietary interface for executing SQL statements.


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

  • 第21题：

    多选题
    Which two SQL*Loader instructions are used to assemble logical records？（）
    A

    WHEN

    B

    INFILE

    C

    CONTINUEIF

    D

    CONCATENATE

    E

    TRAILING NULLCOLS


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

  • 第22题：

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


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

  • 第23题：

    多选题
    Which two are attributes of iSQL*Plus? （）
    A

    iSQL*Plus commands cannot be abbreviated.

    B

    iSQL*Plus commands are accessed from a browser.

    C

    iSQL*Plus commands are used to manipulate data in tables.

    D

    iSQL*Plus commands manipulate table definitions in the database.

    E

    iSQL*Plus is the Oracle proprietary interface for executing SQL statements.


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

相关内容