1z1-084無料問題集「Oracle Database 19c Performance and Tuning Management」

質問 1

A database instance is suffering poor I/O performance on two frequently accessed large tables.
No Big Table caching occurs in the database.
Examine these parameter settings:

Which are two actions either one of which will allow Big Table caching to occur?

（A）Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 25

（B）Setting PARALLEL_DEGREE_POLICYADAPTIVE

（C）Setting DB_KEEP_CACHE_SIZE to at least 50M

（D）Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50

（E）Setting PARALLEL_DEGREE_POLICYAUTO

（F）Increasing DB_CACHESIZE to 1 G

正解：A、F 解答を投票する

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

質問 2

Which three statements are true about server-generated alerts?

（A）They are notifications from the Oracle Database Server of an existing or impending problem.

（B）Their threshold settings can be modified by using DBMS_SERVER_ALERT.

（C）They are logged in the alert log.

（D）They may contain suggestions for correcting the identified problems.

（E）They provide notifications but never any suggestions for correcting the identified problems.

（F）They can be viewed only from the Cloud Control Database home page.

正解：A、C、D 解答を投票する

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

質問 3

For which two actions can SQL Performance Analyzer be used to assess the impact of changes to SQL performance?

（A）changes to database initialization parameters

（B）operating system and hardware migrations

（C）operating system upgrades

（D）database consolidation for pluggable databases (PDBs)

（E）storage, network, and interconnect changes

正解：A、D 解答を投票する

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

質問 4

Which two statements are true about space usage in temporary tablespaces?

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

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

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

（D）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.

（E）Lack of temporary tablespace space for sort operations can be prevented by using temporary tablespace groups.

正解：B、E 解答を投票する

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

質問 5

Examine this AWR report excerpt:

You must reduce the impact of database I/O, without increasing buffer cache size and without modifying the SQL statements.
Which compression option satisfies this requirement?

（A）ROW STORE COMPRESS ADVANCED

（B）COLUMN STORE COMPRESS FOR QUERY HIGH

（C）MN STORE COMPRESS FOR QUERY LOW

（D）STORE COMPRESS

正解：B 解答を投票する

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

質問 6

A database supporting a mixed workload is hosted on a server with 64 CPUs.
A large number of free buffer waits and buffer busy waits occur affecting performance.
The buffer cache size was then increased but after a few hours, the same wait events occur more often than before the change.
Examine these parameter settings:

Which two actions can help reduce the number of these waits7

（A）Increasing the size of MEMORYTARGET

（B）setting dbwr_io_slaves to 64

（C）increasing the value of DBWRITERPROCESSES to 64,

（D）reducing the values of DB_FILE_MULTILOCK_READ_COUNT to 64

（E）increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT to 128

正解：B、C 解答を投票する

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

1z1-084 無料問題集「Oracle Database 19c Performance and Tuning Management」

弊社を連絡する

関連リンク

トップ試験