Oracle
1Z0-117 · Question #53
1Z0-117 Question #53: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #53. The question stem and answer options stay visible for context.
Question
A database instance is configured in the shared server mode and it supports multiple applications running on a middle tier. These applications connect to the database using different services. You enabled the statistics gathering for the service by using the following command: SQL > EXECUTE DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE (`APPS1', NULL, NULL); Which two statements are true regarding statistics gathered for APPS1 service?
Options
- AThe statistics are gathered for all the modules and actions within the service.
- BThe statistics are collected at the session level for all sessions connected using the service.
- CThe statistics are aggregated and stored in the V$SERV_MOD_ACT_STATS view.
- DThe statistics are gathered for all the modules using the service only when DBMS_APPLICATION_INFO.
- EStatistics gathering is enabled only for the subsequent sessions using the service.
- FThe statistics are gathered for all the applications using the service only when DBMS_APPLICATION_INFO.
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.