Oracle 1z1-064 Actual Free Exam Questions & Community Discussion

For which two requirements can you always use the V$ACTIVE_SESSION_HISTORY view? (Choose two.)

Which three actions should you perform to reduce shared pool fragmentation and avoid the "ORA-04031: unable to allocate .... bytes of shared memory" error for the shared pool? (Choose three.)

Which two result in the least internal fragmentation within segments and the least external fragmentation within tablespaces? (Choose two.)

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.)

Your database supports a DSS system.
Examine the parameter values configured in your database:
sga_max_size = 480M
sga_target = 480M
pga_aggregate_target = 160M
The CUSTOMERS table contains 8,000 rows. The CUST_ID column is the primary key and the COUNTRY_ID column contains only three possible values: 1111, 2222, and 3333.
You execute the commands:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','CUSTOMERS');
PL/SQL procedure successfully completed.
SQL> CREATE INDEX COUNTRY_IDX ON CUSTOMERS (COUNTRY_ID);
Index created.
You then perform several INSERT, UPDATE, and DELETE operations, significantly altering the data in the table.
View the Exhibit to examine the query and its execution plan.

Which three options would improve the performance of the query? (Choose three.)

Examine the parameters set for a database instance supporting a mixed workload:

The database instance supports shared server and dedicated server connections simultaneously. Users complain about increased response times of a few DSS queries. During investigation, you execute the queries:

Based on the output, which two courses of action would you recommend to improve query performance? (Choose two.)

Your database supports an OLTP workload.
An application frequently performs update operations on an indexed column of a table; some bulk delete and insert operations are also performed.
The table is created in a locally managed tablespace with manual segment space management.
A user complains about poor response time when querying the table.
The queries mostly perform index range scans.
You notice a high number of buffer busy waits and contention on segment headers.
Which three would you investigate further to diagnose the poor response time?

Examine the query and its output:

Which two statements are true? (Choose two.)

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

You are administrating a database that supports an OLTP workload. A few users complain about the poor performance of some SQL statements. You notice that these SQL statements belong to different applications and conclude that there is no correlation between them. You create a SQL Tuning Set (STS) containing these SQL statements.
What must you do to analyze and generate recommendations for the SQL statements in the STS?