It is impossible to pass Oracle 1Z0-064 exam without any help in the short term. Come to Exambible soon and find the most advanced, correct and guaranteed Oracle 1Z0-064 practice questions. You will get a surprising result by our Latest Oracle Database 12c: Performance Management and Tuning practice guides.
2021 Oct 1Z0-064 exam fees
Q51. Your database supports multiple applications. The applications run on the middle tier and use connection pooling for connecting to the database.
You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities.
What action must you perform to achieve this? (Choose the best answer.)
A. Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE procedure to trace the services.
B. Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SESSION_TRACE_ENABLE procedure to trace the services.
C. Create services for the applications and set the relative priority of services within an instance by mapping the services directly to consumer groups.
D. Create services for the applications and set a relative priority by assigning them to application users.
Q52. 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.
Q53. Examine an extract from a PGA Memory Advisory for your database:
Which two inferences are correct? (Choose two.)
A. Automatic management of PGA memory is disabled.
B. The current PGA size requires the use of a temporary tablespace for sorting operations.
C. The current PGA size is sufficient and does not require the memory manager to allocate more memory.
D. PGA size should be increased at least four times its current size for significant improvement in performance and disk space management.
Q54. 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);
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.)
A. creating a bitmap index on the COUNTRY_ID column
B. regathering statistics on the CUSTOMERS table
C. creating a histogram on the COUNTRY_ID column
D. increasing the size of the PGA
E. creating an SQL profile
F. creating a KEEP cache
Updated 1Z0-064 free exam:
Q55. 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.
Q56. 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.
Q57. 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.
Q58. Which two are prerequisites for running the I/O calibration tool? (Choose two.)
A. The database must be in MOUNT state.
B. The database should be opened in restricted mode.
C. For determining latency time, the STATISTICS_LEVEL parameter must be set to TYPICAL or ALL.
D. The disks to be tested must be configured to use asynchronous I/O for data files.
E. The database instance must be started using an SPFILE.