1Z0-055 무료 덤프문제 온라인 액세스

Which two statements regarding a SQL profile are true? (Choose two.)

• A.It can be created manually by using the CREATE PROFILE command.
• B.It can be used by the query optimizer automatically.
• C.It is built by Automatic Tuning Optimizer.
• D.It cannot be stored persistently in the data dictionary.

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)

• A.It is globally available to all Oracle 11g databases on the machine.
• B.Its entries are specific to a single database.
• C.It contains file systems that have been mounted by the kernel NFS system.
• D.It contains file systems that have been mounted by Direct NFS.

The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)

• A.The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
• B.The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
• C.The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
• D.The optimizer adds the new plan to the plan history.
• E.The optimizer selects the new plan for the execution of the SQL statement.

Which three statements are true regarding persistent lightweight jobs? (Choose three.)

• A.Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
• B.The use of a template is mandatory to create persistent lightweight jobs.
• C.Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
• D.Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
• E.The user cannot set privileges on persistent lightweight jobs.

Which setting enables the baselines by default in Oracle Database 11g?

• A.adding filters to the Automatic Database Diagnostic Monitor (ADDM)
• B.setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
• C.enabling Automated Maintenance Task using Oracle Enterprise Manager
• D.setting the STATISTICS_LEVEL parameter to TYPICAL