READ Free Dumps For Oracle- 1z0-050
| Question ID 6063 | You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals: SQL> EXECUTE DBMS_STATS .GATHER_TABLE_STATS('SHI ,'SALES1 ,GRANUU\RITY=>'GLOBALl); You need statistics to be collected more quickly. What can you do to achieve this? |
| Option A | Set DYNAMIC_SAMPLING to level 4. |
| Option B | Set the STATISTICS_LEVEL parameter to BASIC. |
| Option C | Set the INCREMENTAL value to TRUE for the partition table. |
| Option D | Increase the value of STALE_PERCENT for the partition table. |
| Correct Answer | C |
| Question ID 6064 | Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.) |
| Option A | A single ADR can support multiple ADR homes for different database instances. |
| Option B | The alert files are stored in XML file format in the TRACE directory of each ADR home. |
| Option C | If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE. |
| Option D | The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file. |
| Correct Answer | A,C |