1Z0-084問題集、Oracle実際の試験問題

質問 1

You are informed that the RMAN session that is performing the database duplication is much slower than usual. You want to know the approximate time when the rman operation will be completed.
Which view has this information?

A. V$RMAN_BACKUP_JOB_DETAILS

B. V$SESSION_LONGOPS

C. V$SESSION

D. V$SESSTAT

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 2

You want to reduce the amount of db file scattered read that is generated in the database. You execute the SQL Tuning Advisor against the relevant workload. Which two can be part of the expected result?

A. recommendations regarding rewriting the SQL statements

B. recommendations regarding the creation of additional indexes

C. recommendations regarding the creation of materialized views

D. recommendations regarding the creation of SQL Patches

E. recommendations regarding partitioning the tables

正解: A,B

解説: (PassTest メンバーにのみ表示されます)

質問 3

This error occurred more than four hours ago in the database:
ORA-04036 PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
You want to know which process and query were at fault.
Which two views should you use for this purpose?

A. DBA_HIST_SQLSTAT

B. DBA_HIST_ACTIVE_SESS_HISTORY

C. DBA_HIST_SQLTEXT

D. DBA_HIST_PROCESS_MEM_SUMMARY

E. DBA_HIST_PGASTAT

正解: B,D

解説: (PassTest メンバーにのみ表示されます)

質問 4

What are the least elevated values of statistics_level and C0NTR0LJ4ANAGEMENT_PACK_ACCESS that allow the usage of Monitoring of Database Operations?

A. STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC

B. STATISTICS_LEVEL=BASIC and CONTROL_MANAGEMENT_PACK ACCESS=DIAGOSTIC

C. STATISTICS_LEVEL=ALL and
CONTROL_MANAGEMENT_PACK_ACCESS=DIAGOSTIC+TUNING

D. STATISTICS_LEVEL=TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS-
DIAGOSTIC*TUNING

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 5

Which two statements are true about Data Pump import for objects that used the in Memory (IM) column store in their source database?

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

B. It must always transports existing INMEMORY attributes.

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

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

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

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

正解: A,D

解説: (PassTest メンバーにのみ表示されます)

質問 6

Database performance has degraded recently.
index range scan operations on index ix_sales_time_id are slower due to an increase in buffer gets on sales table blocks.
Examine these attributes displayed by querying DBA_TABLES:

Now, examine these attributes displayed by querying DBA_INDEXES:

Which action will reduce the excessive buffer gets?

A. Re-create index IX_SALES_TIME_ID using ADVANCED COMPRESSION.

B. Re-create the SALES table using the columns in IX_SALES_TIME_ID as the hash partitioning key.

C. Re-create the SALES table sorted in order of index IX_SALES_TIME_ID.

D. Partition index IX_SALES_TIME_ID using hash partitioning.

正解: A

解説: (PassTest メンバーにのみ表示されます)

Oracle Database 19c Performance and Tuning Management - 1Z0-084 模擬練習