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.
第1题:
A.Redoisnotgeneratedwhileperformingconventionalpathloads.
B.OnlyPRIMARYKEY,UNIQUEKEY,andNOTNULLconstraintsarechecked.
C.Noexclusivelocksareacquiredwhentheconventionalpathloadsareperformed.
D.Insteadofperformingtransactions,SQL*Loaderdirectlywritesdatablockstothedatafiles.
E.INSERTtriggersaredisabledbeforetheconventionalpathloadandreenabledattheendoftheload
第2题:
IMPORT和SQL*LOADER 这2个工具的不同点
第3题:
第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)
第5题:
( ) – Is Miss White __________ English teacher, Maria?
– No, she teaches __________ geography.
A.your;my
B.you;mine
C.you;us
D.your;us
第6题: