Which three are true about multitable INSERT statements? (Choose three.)
Which three are true about multitable INSERT statements? (Choose three.)
Multitable INSERT statements can insert each computed row into more than one table, making each computed row applicable to multiple targets. Views can be the target of multitable INSERTs, which allows for complex data insertion operations on derived datasets. Multitable INSERTs can also be performed on relational tables, which are the standard table structures within a relational database.
AEF correct
A. Multitable INSERT statements can insert each computed row into more than one table. This is achieved by specifying multiple INTO clauses in the INSERT statement, each corresponding to a different table. Here's an example: INSERT ALL INTO table1 (column1, column2) VALUES (value1, value2) INTO table2 (column3, column4) VALUES (value3, value4) SELECT * FROM source_table; In this example, the computed rows from the source_table are inserted into both table1 and table2. C. Multitable INSERT statements can be performed on external tables using SQL*Loader. External tables allow you to access data in external files as if it were in a regular database table. Here's an example: INSERT ALL INTO table1 (column1, column2) VALUES (value1, value2) INTO table2 (column3, column4) VALUES (value3, value4) SELECT * FROM external_table; In this example, the data from the external_table is inserted into both table1 and table2. F. Multitable INSERT statements can be performed on relational tables. Relational tables
ACG is TRUE.
ACD (Correction)
https://www.examtopics.com/discussions/oracle/view/9427-exam-1z0-071-topic-1-question-236-discussion/