READ Free Dumps For Oracle- 1z0-146
| Question ID 2815 | Identify the two types of PL/SQL programs for which you consider setting the compilation method to native mode. (Choose two.) |
| Option A | A. PL/SQL programs that are still in the debugging phase of development |
| Option B | B. PL/SQL programs that have computation-intensive procedural operations |
| Option C | C. A PL/SQL program, which is called with the same parameters by multiple sessions |
| Option D | D. PL/SQL programs that spend most of their execution time in executing SQL statements |
| Correct Answer | B,C |
| Question ID 2816 | Identify the method that is used by fine-grained access (FGA). |
| Option A | A. using policy functions to generate predicates dynamically |
| Option B | B. creating triggers on corresponding tables to generate dynamic predicates |
| Option C | C. modifying the existing application code to include a predicate for all SQL statements |
| Option D | D. creating views with necessary predicates, and then creating synonyms with the same name as the tables |
| Correct Answer | A |