欢迎来到PP题库网 PP题库官网
logo
全部科目 > Oracle认证考试 > 1Z0-052

多项选择题

In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table()

    A.if a table is not in a cluster
    B.if a table has an active trigger
    C.if a table has an encrypted
    D.if a table has a column of data type LONG defined on it
    E.if a table has a referential integrity constraint defined on it

点击查看答案

相关考题

  • 多项选择题
    WhichtwostatementsaretrueregardingOracleDataPump()

    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.

  • 多项选择题
    WhichtwostatementsaretrueregardingtheusageoftheSQL*Loaderutility()

    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.

  • 单项选择题
    WhichstatementistrueaboutloadingdatausingtheconventionalpathofSQL*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.

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题