Oracle
1Z0-141 · Question #36
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…
The correct answer is A. Define a data block based on a Ref Cursor. See the full explanation below for the reasoning.
Question
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 at run time. How should you define the appropriate data source?
Options
- ADefine a data block based on a Ref Cursor.
- BDefine a data block based on a Table of Records.
- CDefine a data block based on a From Clause query.
- DDefine a data block based on a combination of a Ref Cursor and a Table of Records.
- EDefine a data block based on a From Clause query and define Transactional triggers for
How the community answered
(37 responses)- A76% (28)
- B5% (2)
- C3% (1)
- D3% (1)
- E14% (5)
Community Discussion
No community discussion yet for this question.