You have been asked to define a data block based on a query that is dependent on SQL only. The data will not be updated by the user. Selection of the tables to be queried will be decided by the user’s at run time.
How should you define the appropriate data source?
A.
Define a data block based on Ref Cursor.
B.
Define a data block based on a Table of Records.
C.
Define a data block based on a From Clause query.
D.
Define a data block based on a combination of a Ref Cursor and a Table of Records.
E.
Define a data block based on a From Clause query and define Transactional triggers for controlling DML statements.