Oracle 1z1-064 실제 시험문제 및 답변

문제1
You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads.
Which action would you take to achieve this? (Choose the best answer.)

A. Create database services for the applications and assign different profiles to the sessions to set a relative priority for resource usage.

B. Assign profiles to users running the batch operations and make sure that a priority is set for resource limits in profiles.

C. Create database services for the applications, create a job class associated with the service, batch the jobs, and then create jobs by using the job class.

D. Create database services for the applications, assign individual sessions created by the applications to consumer groups, and then set a priority.

정답: A

문제2
Which four statements are true about Consolidated Database Replay?

A. Multiple database workloads can be replayed only if both the capture and replay databases are on the same operating system.

B. The replay starts simultaneously for all participating workload captures if no order is defined in the replay schedule.

C. A subset of the captured workload can be replayed on a test system.

D. The number of replay clients must be equal to the number of captured workloads.

E. Multiple replay schedules can be defined and any existing replay schedules can also be used.

F. Consolidated workloads from one or multiple databases can be replayed concurrently on a single system.

G. Multiple database workloads can be replayed only if both the capture and replay databases have the same database version.

정답: B,C,E,F

문제3
Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries.
You want to set a priority for the workload generated by the ERP application and optimize resource usage for them.
Which three objectives can be achieved by the Resource Manager? (Choose three.)

A. allocating a lower percentage of CPU to sessions used by the REPORTING apnplication than to those used by the ERP application

B. limiting the amount of undo generated by operations performed by sessions created by the ERP application

C. limiting the amount of time that a session is idle and blocking other sessions of the ERP application

D. creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload

E. limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database

정답: A,B,E

문제4
In your database, the locally managed tablespace, USERS, has the default space usage alert set to 85% for the warning level and 97% for the critical level.
Which two statements are true? (Choose two.)

A. Alerts are triggered when the space usage reaches the warning level, again when it reaches the critical level, and yet again when the space usage falls below the critical level.

B. Alert settings for the warning and critical levels must be disabled before taking the USERS tablespace offline.

C. Alerts that are triggered are automatically recorded in DBA_ALERT_HISTORY after they are cleared.

D. Alerts are recorded in both Oracle Enterprise Manager Cloud Control and DBA_OUTSTANDING_ALERTS only when the critical threshold is exceeded.

정답: B,D

문제5
Which two statements are true about server-generated alerts? (Choose two.)

A. They appear in the DBA_ALERT_HISTORY view whenever corrective action is taken for an alert.

B. They are generated only when the STATISTICS_LEVEL initialization parameter is set to ALL.

C. They are written to a trace file if the TRACE_ENABLED initialization parameter is set to TRUE.

D. They can be generated for user-defined metric thresholds.

E. They are always logged in the alert log.

정답: B,D

문제6
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. Configure the KEEP pool and cache the queried tables used in the KEEP pool.

B. Set the RESULT_CAHCE_MODE parameter to FORCE for the instance.

C. Use the result cache hint in the queries.

D. Set the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value.

E. Use bind variables for similar queries instead of literals.

정답: B,C

문제7
You execute this query twice in a session:

Then you query V$SQL_SHARED_CURSOR for details about child cursors as shown.

Which two statements are true? (Choose two.)

A. The second execution of the query was hard parsed because extended statistics were collected after the first execution of the query.

B. A subsequent execution of the query in this session is likely to undergo a soft parse.

C. A subsequent execution of the query in this session will undergo a hard parse.

D. The second execution of the query was hard parsed because the estimated cardinality was inaccurate.

E. No statistics were collected during the first execution of the query.

정답: B,D

문제8
Your database supports an OLTP 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 a series of INSERT, UPDATE, and DELETE operations on the table.
View the Exhibit to examine the query and its execution plan.

Which two options can improve the performance of the query without significantly slowing down the DML operations? (Choose two.)

A. regathering statistics on the CUSTOMERS table

B. creating a SQL profile

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 histogram on the COUNTRY_ID column

G. gathering statistics on the COUNTRY_IDX index

정답: D,F

문제9
A senior DBA asks you to decrease the values of the connect_time_scale and think_time_scale replay processing parameters to 50 to preprocess the workload for replay.
What three could be reasons for this change? (Choose three.)

A. to decrease the number of concurrent users during replay

B. to reduce the time of replay

C. to increase the number of concurrent users during replay

D. to decrease the wait for a query, caused by noncommitted transactions

E. to reduce the elapsed time between two successive user calls from a session.

정답: B,C,D

문제10
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. DBA_OUTSTANDING_ALERTS

B. DBA_ALERT_HISTORY

C. DBA_THRESHOLDS

D. Oracle Enterprise Manager Cloud Control

E. the alert log

F. DBA_ACTIVE_SESSION_HISTORY

정답: C,E

최신Oracle Database 12c: Performance Management and Tuning - 1z1-064무료샘플문제

자격증의 중요성:

ExamPassdump 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: