NEW QUESTION 1
You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%.
Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)

• A. the alert log
• B. Oracle Enterprise Manager Cloud Control
• C. DBA_ALERT_HISTORY
• D. DBA_OUTSTANDING_ALERTS
• E. DBA_ACTIVE_SESSION_HISTORY
• F. DBA_THRESHOLDS

Answer: AF

NEW QUESTION 2
Examine the parameters set for your database instance:

You are asked by a developer to create a table for an application with these requirements:
✑ The table will be used for a DSS application.
✑ High volume bulk loads will be performed.
✑ The table will be used to store archival data on which large full-table scans (FTS) will be performed.
Which attributes are the best for the tablespace in which this table should be created? (Choose the best answer.)

• A. Create it in a locally managed tablespace with ASSM enabled and assign a high value for the PCTFREE attribute.
• B. Create it in a locally managed tablespace with manual segment space management.
• C. Create it in a locally managed tablespace with a bigger nonstandard block size and ASSM enabled.
• D. Create it in locally managed tablespace with ASSM enabled and an additional freelist.

Answer: C

NEW QUESTION 3
Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)

• A. A high value indicates that the buffer cache is adequately sized for the current workload.
• B. Poor hit ratios indicate that a large number of indexed lookups or small table scans are being performed.
• C. A low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve performance.
• D. A high hit ratio may indicate that repeated scanning of the same large table or index is being performed.
• E. A low hit ratio indicates that a KEEP buffer pool should be configured based on the size of the largest object accessed in the buffer cache.

Answer: CD

NEW QUESTION 4
You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain about poor performance of these queries.
You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar.
Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)

• A. Set the RESULT_CAHCE_MODE parameter to FORCE for the instance.
• B. Use the result cache hint in the queries.
• C. Use bind variables for similar queries instead of literals.
• D. Set the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value.
• E. Configure the KEEP pool and cache the queried tables used in the KEEP pool.

Answer: AB

NEW QUESTION 5
Which three statements are true about using Real-Time Database Operations? (Choose three.)

• A. The STATISTICS_LEVEL initialization parameter must be set to ALL to enable automatic SQL monitoring for all long-running queries.
• B. The CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter must be set to DIAGNOSTIC+TUNUNG to use Real-Time Database Operations.
• C. The STATISTICS_LEVEL initialization parameter can be set to TYPICAL or ALL to enable Real-Time Database Operations.
• D. Real-Time Database Operations can be enabled only at the system level.
• E. Real-Time Database Operations can be created by using the DBMS_MONITOR or DBMS_SESSION packages.
• F. Database operation monitoring starts automatically when a database operation consumes at least five seconds of the CPU or I/O time in a single execution.

Answer: BCF

NEW QUESTION 6
Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:

What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)

• A. the V$ACTIVE_SESSION_HISTORY view
• B. the Time Model Statistics section of the AWR report
• C. the SQL statements based on elapsed time from the AWR report
• D. the Latch Activity section
• E. the Segment Statistics section of the AWR report

Answer: B

NEW QUESTION 7
Examine the parameters set for your database instance:

You upgrade your database to Oracle Database 12c. The database supports a mixed workload and works with different workloads at different times. You notice in an ADDM report that the shared pool is inadequately sized. You resize the shared pool by decreasing the sizes of other pools, which results in inadequate sizes for other pools. You want to automate the sizing of SGA components.
Which two actions should you perform? (Choose two.)

• A. Set the SGA_TARGET parameter equal to SGA_MAX_SIZE.
• B. Set the SGA_TARGET parameter to the sum of DB_CACHE_SIZE,SHARED_POOL, and LARGE_POOL_SIZE.
• C. Set the MEMORY_MAX_TARGET parameter to the sum of DB_CACHE_SIZE,SHARED_POOL, and LARGE_POOL_SIZE.
• D. Set DB_CACHE_SIZE,SHARED_POOL, and LARGE_POOL_SIZE to their minimum required values.
• E. Set the PGA_AGGREGATE_TARGET parameter to 0 and the SGA_TARGET parameter to 1.5G.

Answer: AE

NEW QUESTION 8
Which three statements are true about the interpretation of an execution plan? (Choose three.)

• A. The cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU resources.
• B. The ROWS column indicates the cardinality of each operation and is always calculated by dividing the total number of rows in the table by the number of distinct values in the column used in the WHERE clause predicate.
• C. A TABLE ACCESS FULL in the Operation column for a query with a WHERE clause occurs only if no index exists for the filter column.
• D. An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be returned.
• E. A HASH JOIN in the Operation column always implies that two tables are joined by using an equijoin.

Answer: BDE

NEW QUESTION 9
Examine the Time Model Statistics section of an AWR report:

Which two inferences can be definitely derived from this section? (Choose two.)

• A. The available CPU resources were not utilized to their maximum capacity.
• B. All sequence numbers used during this AWR time interval were cached.
• C. A large number of connected user sessions were idle.
• D. New child cursors were created because of new bind values or usage of literal values as well as different bind types or sizes.
• E. The DB CPU time was not spent exclusively for processing SQL statements.

Answer: DE

NEW QUESTION 10
Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)

• A. DB time cannot exceed the total elapsed time (walk clock time) since the database instance started.
• B. DB time cannot exceed the maximum number of concurrent sessions multiplied by the actual elapsed time for each session.
• C. DB time includes the time spent on client processes and background processes.
• D. Reducing DB time allows a database instance to support more user requests by using the same resources.
• E. DB time is always greater than or equal to the DB CPU time.

Answer: DE

NEW QUESTION 11
In which three situations does DB time always increase? (Choose three.)

• A. when the host is CPU bound for foreground processes
• B. when I/O wait time increases for foreground processes
• C. when more connections are made to a database instance
• D. when CPU consumption by background processes increases
• E. when wait time for data to be sent over a network increases

Answer: ABC

Explanation: Reference: http://www.oracle.com/technetwork/oem/db-mgmt/s317294-db-perf-tuning-with- db-time-181631.pdf (page 21)

NEW QUESTION 12
You are administering a database that supports an OLTP workload. The CURSOR_SHARING parameter is set to EXACT for the instance. The performance of queries issued by one of the modules has degraded. The queries executed by the module are almost identical in syntax. To investigate, you analyze the latest AWR report and find a large number of latch:shared pool wait events and also a high percentage of the hard parse elapsed time.
Which two can be reasons for this? (Choose two.)

• A. The I/O performance is slow.
• B. Bind variables are not used for similar queries, causing hard parses.
• C. Repeated access to a small number of blocks.
• D. Excessive time is spent on finding cached cursors in the library cache.
• E. The CURSOR_SHARING parameter is set to EXACT, which does not allow similar queries to share a cursor.

Answer: BC

NEW QUESTION 13
You are administering a database that supports an OLTP workload. An application performs a large number of small transactions. Users complain about increased response times for transactions. On investigation, you find that the cache hit ratio is 69%. Examine a partial output from V$SYSTEM_EVENT:

Which four can be possible reasons for the increased response time? (Choose four.)

• A. The database buffer cache is inadequately sized.
• B. DBWR is not writing the dirty buffers fast enough.
• C. A large number of blocks are fetched from disks frequently.
• D. Several full table scans are performed by transactions.
• E. Blocks are aging out of the buffer cache frequently.
• F. Many sessions are waiting for buffers that are currently being read into the buffer cache by other sessions.

Answer: ABEF

NEW QUESTION 14
You are administering a database that supports an OLTP workload. An application regularly creates global temporary tables and a large number of transactions are performed on them. You notice that performance is degraded because of excessive generation of undo due to a large number of transactions on the global temporary tables.
What is the recommended action to improve performance? (Choose the best answer.)

• A. Increase the size of the undo tablespace and enable undo retention guarantee.
• B. Increase the size of the database buffer cache.
• C. Enable temporary undo.
• D. Increase the size of the temporary tablespace or make it autoextensible.
• E. Enable Automatic Segment Space Management (ASSM) for the undo tablespace.

Answer: C

Explanation: Reference: https://docs.oracle.com/cd/B13789_01/server.101/b10739/undo.htm

NEW QUESTION 15
Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are competing for resources? (Choose four.)

• A. distributing available CPU by allocating percentages of CPU time to different users and applications
• B. limiting the degree of parallelism of any operation performed by members of a group of users
• C. limiting queries based on resource consumption of runaway sessions or calls that consume more than a specified amount of CPU, physical I/O, logical I/O, or elapsed time
• D. limiting the number of concurrent sessions for a user
• E. limiting the number of user sessions allowed to be concurrently active within a group of users
• F. limiting the number of parallel executions that can be executed by a user

Answer: ABCE

NEW QUESTION 16
Examine the structure of the EMPLOYEES table.

EMPLOYEE_ID is the primary key. No other indexes exist on this table. View the Exhibit to examine the commands and their output.

Which two actions should you perform to make the cursor bind aware? (Choose two.)

• A. Create a histogram on the DEPARTMENT_ID column.
• B. Change the default CURSOR_SHARING value to FORCE.
• C. Execute the query with the same DEPARTMENT_ID value multiple times.
• D. Create an index on the DEPARTMENT_ID column.
• E. Gather statistics for the index.
• F. Regather statistics on the table.

Answer: CD