Zwischen Beruf und Alltag bleibt oft wenig Zeit für eine gründliche Prüfungsvorbereitung. Mit den 120 Übungsfragen von Fast2test bereiten Sie sich gezielt auf die 1z0-064 Prüfung vor und konzentrieren sich auf genau die Inhalte, die in der Oracle Database 12c: Performance Management and Tuning tatsächlich gefragt sind.

Oracle 1z0-064 Prüfungsübersicht:

Oracle 1z0-064 Prüfungsthemen:

Ihre Fragen zur 1z0-064 Prüfung – kompakt beantwortet

Oracle Database 12c: Performance Management and Tuning 1z0-064 Prüfungsfragen mit Lösungen

Frage #1

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

A. regathering statistics on the CUSTOMERS table
B. creating a histogram on the COUNTRY_ID column
C. increasing the size of the PGA
D. creating a bitmap index on the COUNTRY_ID column
E. creating a KEEP cache
F. creating a SQL profile

Frage #2

You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have already created a test system with the upgrades to be made to the production database. As part of the testing, you want to:
analyze and compare the overall database workload with concurrency and transaction characteristics find SQL statements that might get regressed because of the upgrade analyze execution plans for SQL statements for which performance might get regressed analyze the impact of new schema objects on database performance Which two tools would you recommend to achieve the objective? (Choose two.)

A. SQL Performance Analyzer
B. Database Replay
C. SQL Access Advisor
D. SQL Tuning Advisor
E. Automatic Database Diagnostic Monitor (ADDM) compare periods report
F. Automatic Workload Repository (AWR) compare periods report

Frage #3

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

A. Configure shared server mode.
B. Identify the packages or procedures that are causing the "ORA-04031:unable to allocate....bytes of shared memory" error and use the DBMS_SHARED_POOL.KEEP to keep them in the shared pool.
C. Standardize the type, size, and naming conventions for bind variables and spacing conventions for SQL statements and PL/SQL blocks.
D. Use more anonymous procedures.
E. Use DBMS_SHARED_POOL.KEEP to keep the SYS.STANDARD, SYS.DBMS_STANDARD, and SYS.DIUTIL packages and frequently executed compiled triggers.
F. Configure the Server Result Cache.

Frage #4

You want to set a priority for the workloads generated by the applications in your database instance such that report-generating tasks are assigned a lower priority.
How would you do this?

A. by using services for the applications and creating job classes associated with each service
B. by creating an active session pool using the Resource Manager
C. by using services that are assigned different priorities with the Resource Manager
D. by using job classes with the Resource Manager

Frage #5

Your database supports multiple applications. The applications run on the middle tier and use connection 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?

A. 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.
B. 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.
C. Create services for the applications and set a relative priority by assigning them to application users.
D. Create services for the applications and set the relative priority of services within an instance by mapping the services directly to consumer groups.

Fragen und Antworten: