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

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

WHEN

B

INFILE

C

CONTINUEIF

D

CONCATENATE

E

TRAILING NULLCOLS

相似考题

1.Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA．ⅠonlyB．Ⅱ onlyC．Ⅰ and ⅡD．none of the above

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.

参考答案和解析
正确答案： D,A
解析： 暂无解析
更多“多选题Which two SQL*Loader instructions are used to assemble logical records？（）AWHENBINFILECCONTINUEIFDCONCATENATEETRAILING NULLCOLS”相关问题

  • 第1题：

    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

  • 第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.

    正确答案:A,B,E

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    多选题
    Which two statements are true about hierarchical architecture? （）(Choose two.)
    A

    You can assign a logical interface to multiple zones.

    B

    You cannot assign a logical interface to multiple zones.

    C

    You can assign a logical interface to multiple routing instances.

    D

    You cannot assign a logical interface to multiple routing instances.


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

  • 第7题：

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

  • 第8题：

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

  • 第9题：

    单选题
    Which of the following explains the relationship between a physical and logical partition?（）
    A

    A physical partition is hosted on one or more logical partitions. A logical partition is used when describing storage.

    B

    A logical partition is hosted on one or more physical partitions. A physical partition is used when describing storage.

    C

    A physical partition is used when describing only a SCSI or SAS disk. A logical partition is used when describing a SAN LUN.

    D

    A logical partition is used when describing only a SATA or SAS disk. A physical partition is used when describing RAID or mirrored arrays.


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

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

    多选题
    Which two statements about subqueries are true? （）
    A

    A subquery should retrieve only one row.

    B

    A subquery can retrieve zero or more rows.

    C

    A subquery can be used only in SQL query statements.

    D

    Subqueries CANNOT be nested by more than two levels.

    E

    A subquery CANNOT be used in an SQL query statement that uses group functions.

    F

    When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.


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

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

    Which of the following explains the relationship between a physical and logical partition?（）

    • A、A physical partition is hosted on one or more logical partitions. A logical partition is used when describing storage.
    • B、A logical partition is hosted on one or more physical partitions. A physical partition is used when describing storage.
    • C、A physical partition is used when describing only a SCSI or SAS disk. A logical partition is used when describing a SAN LUN.
    • D、A logical partition is used when describing only a SATA or SAS disk. A physical partition is used when describing RAID or mirrored arrays.

    正确答案:B

  • 第14题：

    Which two statements about subqueries are true? （）

    • A、A subquery should retrieve only one row.
    • B、A subquery can retrieve zero or more rows.
    • C、A subquery can be used only in SQL query statements.
    • D、Subqueries CANNOT be nested by more than two levels.
    • E、A subquery CANNOT be used in an SQL query statement that uses group functions.
    • F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

    正确答案:B,F

  • 第15题：

    Which two SQL*Loader instructions are used to assemble logical records？（）

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

    正确答案:C,D

  • 第16题：

    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

  • 第17题：

    多选题
    Which two statements are true regarding subqueries? （）
    A

    A subquery can retrieve zero or more rows

    B

    Only two subqueries can be placed atone level

    C

    A subquery can be used only in SQL query statements

    D

    A subquery can appear on either side of a comparison operator

    E

    There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement


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

  • 第18题：

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

  • 第19题：

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

  • 第20题：

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


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

  • 第21题：

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

  • 第22题：

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

  • 第23题：

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

相关内容