Unformatted text preview: ower of Knowing 1Z0-042
You want to enforce a company's business policy on several objects by using a single
Which two types of policies can be assigned to the policy_type argument in the
dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)
Answer: C, E
The policy function executes once, Once, then the predicate is cached in the SGA, and
it's Shared Across Multiple Objects, like Hosting environments, such as data warehouses
where the same predicate must be applied to multiple database objects
The policy function executes f irst time and the object is reference in a database session
Predicates are cached in the private session memory UGA so policy functions can be
shared among objects.
REF.: Oracle(r) Database Security Guide 10g Release 2 (10.2) - p 15-30
The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60
minutes on your database. Your database if facing a series of interrelated problems
over a period of two hours. You need to ensure that the ADDM analysis is run over
a time span of two hours in future.
What would you do?
A. Create two custom ADDM tasks.
B. Modify the AWR snapshot time interval to two hours.
C. Create a new scheduler window for a time period of two hours.
D. Modify the time interval by using the DBMS_JOB.INTERVAL procedure.
E. Modify the Automatic Workload Repository (AWR) snapshot retention period to two
The Automatic Database Diagnostic Monitor (ADDM) provides a holistic tuning
solution. ADDM analysis can be performed over any time period defined by a pair of
AWR snapshots taken on a particular instance. Analysis is performed top down, first
identifying symptoms and then refining them to reach the root causes of performance
The goal of the analysis is to reduce a single throughput metric...
View Full Document
- Fall '09
- administrator, Oracle Database, Certkiller