Exam 1z0-071 topic 1 question 20 discussion

A. the access driver TYPE clause ✅ Required This tells Oracle which access driver to use (typically ORACLE_LOADER or ORACLE_DATAPUMP). Example: sql Copy Edit TYPE ORACLE_LOADER B. the DEFAULT DIRECTORY clause ✅ Required This defines the Oracle directory object where the external file is located. Example: sql Copy Edit DEFAULT DIRECTORY ext_dir

LOCATION is the only MUST clause. You can specify the ENTIRE physical path in LOCATION without having to have a DEFAULT_DIRECTORY clause

The Right answers are : B and D as i tried the following create table statement but an error occured to specify the default ditrectory . The query is : create table CUST( cust_id number (2), Credit_limit Number (10)) Organization External Type Oracle_Loader Location ('c:\test.txt')) ;

Option A is required because Oracle needs to know how to handle the external data file (driver type). Option D is required because Oracle needs to know the location of the external data file to access the data.

A D TRUE BECAUSE IF WE USE LOCATION THEN WE CAN USE DEFAULT DIRECTORY

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.

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

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

why not E?