Exam 1z0-071 All QuestionsBrowse all questions from this exam
Go to Exam
Question 20

Examine this partial command:

Which two clauses are required for this command to execute successfully? (Choose two.)

    Correct Answer: A, D

    For a command to create an external table to execute successfully, the access driver TYPE clause is required to specify the type of driver to be used (e.g., ORACLE_LOADER or ORACLE_DATAPUMP). Also, the LOCATION clause is crucial as it indicates the location of the data files for the external table. Although other clauses like DEFAULT DIRECTORY and ACCESS PARAMETERS can be specified, they are not strictly required for the command to run successfully.

Discussion
TofOraOptions: DE

D and E. B is WRONG, there is no need to define the DEFAULT DIRECTORY, you can specify each of the files with a DIRECTORY, like: create directory testsdir as 'c:\tests'; LOGFILE testsdir:'loggile.log' BADFILE testsdir:'badfile.log' LOCATION (testsdir:'invoice_data.txt') Tried to upload the full example but the site does not accept it, gives a Cloudflare error.

yanoolthecool

nah, in: https://docs.oracle.com/en/database/oracle/oracle-database/23/sutil/oracle-external-tables-concepts.html#GUID-ACF1D3AA-1D61-4682-AEC5-42C944756E12 it says: Access parameters are optional. See Access Parameters.

J4viOptions: BD

TYPE: "Oracle Database provides two access drivers: ORACLE_LOADER and ORACLE_DATAPUMP. If you omit the TYPE specification, ORACLE_LOADER is the default access driver." https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm#ADMIN11705 ACCESS PARAMETERS: "To modify the default behavior of the access driver for external tables, specify access parameters." https://docs.oracle.com/en/database/oracle/oracle-database/23/sutil/oracle-external-tables-concepts.html#GUID-ACF1D3AA-1D61-4682-AEC5-42C944756E12 REJECT LIMIT : there are several examples that don't use this clause LOCATION: "For ORACLE_HIVE, the LOCATION clause is not used." https://docs.oracle.com/en/database/oracle/oracle-database/23/sutil/oracle-external-tables-concepts.html#GUID-ACF1D3AA-1D61-4682-AEC5-42C944756E12 That about LOCATION confuse me, but I tend to believe it's a very particular case, so the answer should be (BD) DEFAULT DIRECTORY and LOCATION

SbabloOption: E

E is also correct since it species the data source of the external tables.

Orxan_H

why not E?