ChatGPT says also C and D:
True Statements:
C. When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.
This statement is correct because external tables can be created based on data in other external tables, as well as regular database tables. This flexibility allows for various data processing scenarios where data can be accessed from multiple sources.
D. Creating an external table creates a dump file that can be used by an external table in the same or a different database.
This statement is also true. The ORACLE_DATAPUMP access driver allows the creation of dump files that can be utilized across different databases. This enables data movement and integration between Oracle databases effectively.
ChatGPT answer about B:
B. Creating an external table creates a directory object.
While external tables do require a directory object for file storage references, creating the external table itself does not inherently create a directory object; the directory must exist beforehand.
uhh, no.
'You must create the directory object before you create the external table; otherwise, an error is generated'
source: https://docs.oracle.com/en/database/oracle/oracle-database/23/sutil/oracle-external-tables-concepts.html#GUID-ACF1D3AA-1D61-4682-AEC5-42C944756E12
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Psili
3 months, 2 weeks agoMIGHTYSTUNNERS
8 months, 2 weeks agoPsili
3 months, 2 weeks agoyanoolthecool
7 months agoTheOracleWasTaken
1 year, 5 months ago