Valid 1z0-071 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-071 Exam! ExamDiscuss.com now offer the newest 1z0-071 exam dumps, the ExamDiscuss.com 1z0-071 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-071 dumps with Test Engine here:
Examine this partial command: CREATE TABLE cust( cust_id NUMBER(2), credit_limit NUMBER(10) ORGANIZATION EXTERNAL Which two clauses are required for this command to execute successfully?
Correct Answer: A,D
When creating an external table, which allows you to access data in a flat file as though it is a table inside the database, certain clauses are required: * A. the ACCESS PARAMETERS clause: This clause specifies the parameters required by the access driver to read the data files. * D. the LOCATION clause: This clause specifies the location of the data files that make up the external table. References: * Oracle Database SQL Language Reference 12c, particularly the sections detailing the creation and management of external tables.