Oracle
1Z0-141 · Question #85
You have been asked to define a data block based on a JOIN of multiple tables. The read- only data will be used for calculations and lookups. The DBA is on holiday and is unable to define a view on…
The correct answer is C. Define a data block based on a From Clause query. See the full explanation below for the reasoning.
Question
You have been asked to define a data block based on a JOIN of multiple tables. The read- only data will be used for calculations and lookups. The DBA is on holiday and is unable to define a view on the database server. What is the simplest way for you to continue to build the form?
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 Ref Cursor and define Transactional triggers for controlling
How the community answered
(48 responses)- A8% (4)
- B15% (7)
- C71% (34)
- D2% (1)
- E4% (2)
Community Discussion
No community discussion yet for this question.