1Z0-054 試験問題を無料オンラインアクセス

You plan to use adaptive thresholds as part of the performance tuning activity. You decide to increase the window size of the default moving window baseline for all metric observations and comparisons in your database. The following error occurs when you try to increase the window size through Enterprise Manager: Failed to commit: ORA-13541: system moving window baseline size (1296000) greater than retention (1036800) ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 601 ORA06512: at line 2 Which action would allow you to perform the preceding task successfully?

• A.increasing the Automatic Workload Repository (AWR) retention period
• B.increasing the undo retention period for the database instance
• C.increasing the flashback retention period
• D.increasing the retention period for SQL Management Base

View the Exhibit exhibit1 to examine the series of SQL commands and parameter settings.

View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline.

The first plan (in red) is created when OPTIMIZER_MODE is set to ALL_ROWS and the second plan (in blue) is created when OPTIMIZER_MODE is set to FIRST_ROWS.Which SQL plan
baseline would be used if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

• A.the second plan, because it is the latest generated plan in FIRST_ROW mode
• B.the second plan, because it is a fixed plan
• C.A new plan, because the second plan in FIRST_ROW mode is not an accepted plan
• D.the first plan, because it is an accepted plan

You work as a DBA in ABC Corp. You are working on an online transaction processing (OLTP)
database. The database size has grown to 100 GB. The database will support new applications
and more users will be added. Presently, the database uses normal file system storage. Before
the new applications are added, you want to move the storage to RAID. You are in consultation
with the OS Administrator for finalizing the RAID option for the storage.
You have the following requirements for the database:
1) Less mean time to recover (MTTR)
2) Striped for performance
3) Mirrored for safety
Which RAID option would you recommend?

• A.RAID level 1 over 0(0+1)
• B.RAID level 1
• C.RAID level 0
• D.RAID level 0 over 1(1+0)

You observed very low cache-hit ratio in your database as shown below:
SQL> SELECT (1-((phy.value-phyd.value) / (cur.value + con.value))) * 100
2 "Cache Hit ratio"
3 FROM v$sysstat cur, v$sysstat con, v$sysstat phy, v$sysstat phyd
4 WHERE cur.name = 'db block gets'
5 AND con.name = 'consistent gets'
6 AND phy.name = 'physical reads'
7 AND phyd.name = 'physical reads direct';
Cache Hit Ratio
After further investigation, you decided to increase the database buffer cache size. You are using
the
Buffer Cache Advisor to check the appropriate size for the buffer cache.
View the Exhibit and examine the graph shown by the advisory.
What can you infer from the graph?

• A.The buffer cache size can be set to more than 16 MB to get more benefit.
• B.The buffer cache size cannot be set to more than 16 MB because the SGA_MAX_SIZE value does not allow that.
• C.The buffer cache size can be set to more than 16 MB but there would be no benefit from it.
• D.The buffer cache size can be set to 12 MB for optimal performance.

View the Exhibit and analyze the output of the query.What does the high value for the table fetch continued rows statistics indicate?

• A.both chained and migrated rows fetched
• B.migrated rows fetched only
• C.rows fetched from external tables
• D.chained rows fetched only
• E.rows fetched from Index Organized Tables (IOT)