READ Free Dumps For Oracle- 1z0-062
| Question ID 21749 | Examine the following query output:
You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?
|
| Option A | All database operations performed by the impdp command are logged.
|
| Option B | Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
|
| Option C | Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
|
| Option D | None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
|
| Correct Answer | C |
Explanation Explanation: Oracle Data Pump disable redo logging when loading data into tables and when creating indexes. The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo generation for the objects during the course of import. The Master Table is used to track the detailed progress information of a Data Pump job. The Master Table is created in the schema of the current user running the Pump Dump export or import, and it keeps tracks of lots of detailed information.
| Question ID 21750 | You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?
|
| Option A | It detects any configuration change that caused a performance difference in both time periods.
|
| Option B | It identifies any workload change that caused a performance difference in both time periods.
|
| Option C | It detects the top wait events causing performance degradation.
|
| Option D | It shows the resource usage for CPU, memory, and I/O in both time periods.
|
| Option E | It shows the difference in the size of memory pools in both time periods.
|
| Option F | It gives information about statistics collection in both time periods.
|
| Correct Answer | A,B,D |
Explanation Explanation: Keyword: shows the difference. * Full ADDM analysis across two AWR snapshot periods Detects causes, measure effects, then correlates them Causes: workload changes, configuration changes Effects: regressed SQL, reach resource limits (CPU, I/O, memory, interconnect) Makes actionable recommendations along with quantified impact * Identify what changed / Configuration changes, workload changes * Performance degradation of the database occurs when your database was performing optimally in the past, such as 6 months ago, but has gradually degraded to a point where it becomes noticeable to the users. The Automatic Workload Repository (AWR) Compare Periods report enables you to compare database performance between two periods of time. While an AWR report shows AWR data between two snapshots (or two points in time), the AWR Compare Periods report shows the difference (ABE) between two periods (or two AWR reports with a total of four snapshots). Using the AWR Compare Periods report helps you to identify detailed performance attributes and configuration settings that differ between two time periods. Reference: Resolving Performance Degradation Over Time