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=employeesWhich two statements are true regarding the command?()A. It succeeds with defau

题目

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=employeesWhich 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
更多“On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table ”相关问题
  • 第1题:

    WhichstatementistrueaboutloadingdatausingtheconventionalpathofSQL*Loader()

    A.Redoisnotgeneratedwhileperformingconventionalpathloads.

    B.OnlyPRIMARYKEY,UNIQUEKEY,andNOTNULLconstraintsarechecked.

    C.Noexclusivelocksareacquiredwhentheconventionalpathloadsareperformed.

    D.Insteadofperformingtransactions,SQL*Loaderdirectlywritesdatablockstothedatafiles.

    E.INSERTtriggersaredisabledbeforetheconventionalpathloadandreenabledattheendoftheload


    参考答案:C

  • 第2题:

    IMPORT和SQL*LOADER 这2个工具的不同点


    正确答案:
     

  • 第3题:

    ( )is an intermediate repository of data.

    A.Universal Serial Bus
    B.Buffer
    C.DatA.record
    D.Database

    答案:B
    解析:

  • 第4题:

    Yourdatabaseisnotconfiguredforsessionfailover.Yourtnsnames.orafilecontainsthefollowingdetails:test.us.oracle.com=(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=off)(FAILOVER=ON)(ADDRESS=(PROTOCOL=tcp)(HOST=test1-server)(PORT=1521))(ADDRESS=(PROTOCOL=tcp)(HOST=test2-server)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=test.us.oracle.com)))Whichfeatureisenabledinthiscase?()

    A.Loadbalancing

    B.Instancefailover

    C.Databasefailover

    D.Connect-timefailover

    E.TransparentApplicationFailover(TAF)


    参考答案:D

  • 第5题:

    ( ) – Is Miss White __________ English teacher, Maria?

    – No, she teaches __________ geography.

    A.your;my

    B.you;mine

    C.you;us

    D.your;us


    正确答案:D

  • 第6题:

    Most operating systems have a standard set of ( ) to handle the processing of all input and output instructions.

    A.spreadsheet
    B.control instructions
    C. I/O operation
    D.datA.table

    答案:B
    解析:
    翻译:

    大多数操作系统都有一套标准的(71)处理所有的输入和输出指令。

    A. 电子表格 B. 控制指令

    C. I/O操作 D. 数据表