1Z0-116 practice question 5 of 15
A policy predicate function Is associated with an enabled Virtual Private Database (VPD) policy for a table. Which two arguments are passed to the function?
Full set: 90 questionsA Virtual Private Database (VPD) policy predicate function is invoked by the Oracle server whenever a user accesses the associated table. The server automatically passes two arguments to this function: the schema name of the object being accessed and the name of the object itself (e.g., the table or view name). The function uses these arguments, along with session context information (like SYSCONTEXT), to dynamically generate a WHERE clause predicate. This predicate is then appended to the user's SQL statement to enforce row-level security.
C. The policy type (e.g., DYNAMIC, STATIC) is part of the policy definition, not an argument passed to the predicate function at runtime.
D. The policy name is used to identify the policy but is not passed as an argument to its associated function during execution.
E. The policy group is an organizational container for policies and is not passed as a runtime argument to the predicate function.
- Oracle Database Security Guide 21c, Chapter 8, "Using Oracle Virtual Private Database to Control Data Access". The section "Step 2: Create the Policy Function" explicitly shows the required signature: FUNCTION policyfunctionname (schemaname IN VARCHAR2, objectname IN VARCHAR2) RETURN VARCHAR2;.
- Oracle Database PL/SQL Packages and Types Reference 21c, "DBMSRLS". The documentation for ADDPOLICY shows the functionschema and policyfunction parameters, and the standard signature for the policy function confirms the two arguments.
Keep practicing
Take the free 1Z0-116 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-116 practice questions
- Question 2To avoid hard coding passwords in scripts, you have elected to create an external passwor…
- Question 3What is true about the client identifier?
- Question 4For which two reasons would you define Network ACLs?
- Question 7Which two statements are true about Valid Node Checking for Registration (VNCR)?
- Question 8Which two does the master key encrypt with Transparent Data Encryption?
- Question 10When creating labels using Oracle Label Security, which is required?
