Oracle Database 19c Performance and Tuning Management - 1z1-084 Exam Practice Test

A. DBA_HIST_SQLSTAT

B. DBA_HIST_ACTIVE_SESS_HISTORY

C. DBA_HIST_PROCESS_MEM_SUMMARY

D. DBA_HIST_SQLTEXT

E. DBA_HIST_PGASTAT

A. DB time can be many times greater than the elapsed time since the database instance started.

B. DB tine excludes the time spent waiting for a CPU in the operating system run queue.

C. DB time includes the time spent executing the RMAN backup and restore command.

D. DB time is organized as a simple list of statistics and any time period is attributable to only one statistic.

A. Parse Time Elapsed accounts for successful soft and hard parse operations only.

B. Statspack cannot account for high CPU time when CPU TIME is a Top 10 event in DB time. When CPU time is high, SQL tuning may improve performance.

C. The proportion of WAIT TIME to CPU TIME always increases with increased system load.

D. Systems in which CPU time is dominant need more tuning that those in which WAIT TIME is dominant.

E. When WAIT TIME is high, instance tuning may improve performance.

F. DB Time accounts for all time used by background processes and user sessions.

A. Its INMEM0RY_CLAUSE of the Data Pump Export allows modifications to IM column store clause of a table with existing INMEMORY setting.

B. It ignores the IM column store clause of the exporting objects.

C. It can generates the INMEMORY clause that matches the table settings at export time.

D. It always gives preference to the IM column store clause defined at the tablespace level over table-level definitions.

E. Its TRANSFORM clause can be used to add the INMEMORV clause to exported tables that lack them.

F. It must always transports existing INMEMORY attributes.

A. A sort will fail if a sort to disk requires more disk space and no additional extent can be found/allocated in/for the sort segment.

B. When a session consumes all temporary tablespace storage, then the session would hang until the temporary space used by that session is cleared.

C. Temporary tablespaces setting Includes quotas to limit temporary space used by a session for that Temporary tablespace.

D. Lack of temporary tablespace space for sort operations can be prevented by using temporary tablespace groups.

E. When a global temporary table instantiation is too large to fit in memory, space is allocated in a temporary tablespace.

A. A critical alert will be issued when CPU time exceeds 2 minutes for each user call.

B. A critical alert will be issued when CPU time exceeds 10000 microseconds for each user call.

C. A warning alert will be issued when CPU time exceeds 1 minute for each user call.

D. A warning alert will be issued only when CPU time exceeds 10000 microseconds for each user call.