READ Free Dumps For Oracle- 1z0-146
| Question ID 2749 | Which two statements are true about the working of fine-grained access? (Choose two.) |
| Option A | A. Security policies can be associated only with tables, but not with views. |
| Option B | B. Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements. |
| Option C | C. User statements are dynamically modified by the Oracle server through a security policy function. |
| Option D | D. Fine-grained access control policies always remain in effect until they are dropped from a table or view. |
| Correct Answer | B,C |
| Question ID 2750 | View the Exhibit. |
| Option A | A. Execute the SQL statement in V_STMT as dynamic SQL. |
| Option B | B. Remove the default value for the arguments in the procedure. |
| Option C | C. Convert the condition in the WHERE clause to be accepted from the user and concatenated. |
| Option D | D. Convert the SELECT statement to static SQL, placing the value of P_EMAIL into a local variable. |
| Correct Answer | D |
