READ Free Dumps For Oracle- 1z0-117
| Question ID 2586 | 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: |
| Option A | A. The statistics are gathered for all the modules and actions within the service. |
| Option B | B. The statistics are collected at the session level for all sessions connected using the service. |
| Option C | C. The statistics are aggregated and stored in the V$SERV_MOD_ACT_STATS view. |
| Option D | D. The statistics are gathered for all the modules using the service only when DBMS_APPLICATION_INFO.SET_ MODULE is executed to register with the service. |
| Option E | E. Statistics gathering is enabled only for the subsequent sessions using the service. |
| Option F | F. The statistics are gathered for all the applications using the service only when DBMS_APPLICATION_INFO.SET_ACTION is executed to register with the service. |
| Correct Answer | A,C |
| Question ID 2587 | In which three situations must you collect optimizer statistics manually for database objects in addition to automatic statistics collection? |
| Option A | A. When substantial DML activity occurs between the nightly automatic stats gathering maintenance job |
| Option B | B. When substantial activity occurs on a partition of the partitioned table. |
| Option C | C. When a table is used for bulk loads that add 10% or more to the total size of the table |
| Option D | D. When an index is created or dropped for a column |
| Option E | E. When the degree of parallelism is explicitly defined for a table |
| Correct Answer | A,B,C |