手に入れよう！は2025年最新の有効な実践問題であなたの1Z0-084試験を合格させる（本日更新された57問) [Q15-Q37]

質問15、 Which three types of statistics are captured by statspack with snap level 6?

質問16、 Which two statements are true about cursor sharing?

質問17、 Examine this statement and its corresponding execution plan:

Which phase introduces the CONCATENATION step?

質問18、 Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true’

質問19、 Examine these statements and output:

What parameter change activates the generation and use of SQL Plan Directives7

質問20、 Which three statements are true about using the in Memory (IM) column store?

質問21、 You need to transport performance data from a Standard Edition to an Enterprise Edition database. What is the recommended method to do this?

質問22、 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?

質問23、 Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

質問24、 You must configure and enable Database Smart Flash Cache for a database.
You configure these flash devices:

Examine these parameter settings:

What must be configured so that the database uses these devices for the Database Smart Flash Cache?

質問25、 Examine this AWRreport 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?

質問26、 Examine this statement and output:

Which two situations can trigger this error?

質問27、 Examine this statement and its corresponding execution plan:

Which phase introduces the CONCATENATION step?

質問28、 Examine these commands, which execute successfully:

Which statement is true?

質問29、 Multiple sessions are inserting data concurrently into a table that has an LOB column.
At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.
Which wait event will be raised in the other sessions that need space in the LOB column?

質問30、 You manage a 19c database with default optimizer settings.
This statement is used extensively as subquery in the application queries:
SELECT city_id FROM sh2.sales WHERE city_id=:Bl
You notice the performance of these queries is often poor and, therefore, execute:
SELECT city_id,COUNT(*) FROM sh2.sales GROUP BY city_id;
Examine the results:

There is no index on the CITY_ID column.
Which two options improve the performance?

質問31、 SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_target is then set to a nonzero value but memory_MAX_TARGET is not set.
Which two statements are true?

質問32、 Examine this command:

What is the maximum number of baselines generated by this command that you can have at any given time?

質問33、 Users complain about slowness and session interruptions. Additional checks reveal the following error in the application log:

Which file has additional information about this error?

質問34、 Examine this code block, which executes successfully:
DBMS_SERVER_ALERT. SET_THRESHOLD (
DBMS_SERVER_ALERT.CPU_TIME_PER_CALL, DBMS_SERVER_ALERT. OPERATOR_GE, ‘8000’, DBMS_SERVER_ALERT.OPERATOR_GE, ‘10000’, 1, 2, ‘inst1’, DBMS_SERVER_ALERT.OBJECT_TYPE_SERVICE, ‘main.regress.rdbms.dev.us.example.com’) ;

What will happen?

質問35、 You must configure and enable Database Smart Flash Cache for a database.
You configure these flash devices:

Examine these parameter settings:

What must be configured so that the database uses these devices for the Database Smart Flash Cache?

質問36、 Examine this statement and output:

Which two situations can trigger this error?

質問37、 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?