Free 1Z0-062 Exam Dumps

Question 41

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

A. Compare Period ADDM report
B. AWR Compare Period report
C. Active Session History (ASH) report
D. Taking a new snapshot and comparing it with a preserved snapshot

Correct Answer:A

Question 42

Which two statements are true about Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

A. It calls SQL advisors automatically if required.
B. It provides recommendations only for poorly performing SQL statements.
C. Its results are stored in AWR.
D. It runs automatically after each AWR snapshot is created and requires at least two snapshots for analysis.
E. It requires at least one Automatic Workload Repository (AWR) snapshot for analysi

Correct Answer:CE

Question 43

Examine the parameters for a database instance:
1Z0-062 dumps exhibit
Which two statements are true? (Choose two.)

A. Undo records for temporary tables are stored in a temporary tablespace.
B. Undo records for temporary tables are stored in the undo tablespace and logged in the redo.
C. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled.
D. No redo is generated for the undo records belonging to temporary tables.
E. No redo and undo records are generated for temporary table

Correct Answer:AD

Question 44

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

A. You cannot specify how partitioned tables should be handled during an import operation.
B. Only data can be compressed during an export operation.
C. Existing dump files can be overwritten during an export operation.
D. Tables cannot be renamed during an import operation.
E. Metadata that is exported and imported can be filtered based on objects and object types.

Correct Answer:AE
References https://docs.oracle.com/cd/B28359_01/server.111/b28300/expimp.htm#UPGRD12560

Question 45

Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?

A. User Global Area
B. Program Global Area
C. SQL Query Result Cache
D. PL/SQL Function Result Cache

Correct Answer:A