[Free] Download New Updated (December) Oracle 1Z0-054 Exam Questions 41-50

Ensurepass

QUESTION 41

You analyze an Automatic Database Diagnostic Monitor (ADDM) report to identify the component that contributes most to the database time. Which is the correct description of database time?

 

A.

It is the sum of the CPU time of all nonidle sessions.

B.

It is the sum of wait time and the CPU time of all nonidle sessions.

C.

It is the time spent in processing the input/output (I/O) request by users.

D.

It is the difference between the wait time and the CPU time of all nonidle sessions.

 

Correct Answer: B

 

 

QUESTION 42

You are working as a DBA in ABC Corp. You are working on online transaction processing (OLTP) system. The database uses ASM storage. One of the ASM disk goes offline because of hardware failure. When the disk is added back again after the fix, because the database is active, rebalance operations impact the I/O subsystem.Which two recommendations would you give to lower the impact on the I/O subsystem? (Choose two.)

 

A.

Increase the number of ASMB processes.

B.

Increase the number of DBWR_IO_SLAVES.

C.

Decrease the value for the ASM_POWER_LIMIT parameter.

D.

Increase the value for the ASM_POWER_LIMIT parameter.

E.

Set the DISK_REPAIR_TIME disk attribute to a lower value.

F.

Specify the POWER clause with a lower value in an ALTER DISKGROUP statement.

 

Correct Answer: CF

 

 

QUESTION 43

You are managing an online transaction processing (OLTP) system. The database is supporting a large number of applications using connection pools to connect to the database.Which method would you use for performance management?

 

A.

Service aggregation for action within application module

B.

Monitoring individual sessions by querying V$SESSION_LONGOPS

C.

Monitoring individual sessions in an application by querying V$SESSION

D.

Mapping the sessions for an application to one resource consumer group


 

Correct Answer: A

 

 

 

 

 

 

QUESTION 44

You noticed a high number of SQL statements with the same PLAN_HASH_VALUES. View Exhibit1 to see the details.

 

clip_image002

 

View Exhibit2 to see the details of the SQL text for the statements.

 

clip_image003

 

What do you infer from the results?

 

A.

The statements are using the same cursor.

B.

The statements are not using the same cursor.

C.

Removing the bind variable would improve performance.

D.

The cursor for the statement is aging out of the shared pool very quickly.

 

Correct Answer: B

 

 

QUESTION 45

You work as a DBA and have the responsibility of managing a large online transaction processing (OLTP) system. You used the following query during the performance tuning activity:

 

SQL> SELECT (1-((phy.value-phyd.value) / (cur.value + con.value))) * 100

 

2 “Cache Hit ratio”

 

3 FROM v$sysstat cur, v$sysstat con, v$sysstat phy, v$sysstat phyd

 

4 WHERE cur.name = ‘db block gets’

 

5 AND con.name = ‘consistent gets’

 

6 AND phy.name = ‘physical reads’

 

7 AND phyd.name = ‘physical reads direct’;

 

Cache Hit Ratio

 

————–

 

98.43

 

What can you conclude based on this ratio?

 

A.

The database performance is very good because of reduced logical I/Os.

B.

The database performance cannot be determined based only on this ratio.

C.

Good database performance is guaranteed because very few physical I/Os are performed.

D.

The database performance is very good because most of the requested data blocks are found in the buffer cache.

 

Correct Answer: B

 

 

QUESTION 46

You work as a DBA and have the responsibility of managing a large online transaction processing (OLTP) system. You used three queries to check the database performance as shown in the Exhibit.View the Exhibit and analyze the output. What conclusion can you draw from this?

 

clip_image005

A.

There are many physical I/Os happening.

B.

There are many full table scans happening.

C.

The data blocks are aging out of the buffer cache very fast.

D.

There are many cursors trying to access the same data blocks.

E.

The DBWn processes are not freeing sufficient buffers to meet the demand.

 

Correct Answer: D

 

 

QUESTION 47

View the Exhibit and examine the result of Automatic SQL Tuning for a period.None of the recommended SQL profiles are implemented. What would you do to allow the Automatic SQL Tuning implement the SQL profiles automatically?

 

clip_image007

 

A.

Set the OPTIMIZER_MODE parameter to ALL_ROWS for the database instance.

B.

Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.

C.

Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE for the database instance.

D.

Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to TRUE.

 

Correct Answer: D

 

 

QUESTION 48

You used SQL Tuning Advisor for a long-running SQL statement that suggested a SQL profile which can be used by the query subsequently for better execution plan. View the Exhibit. But youwant certain user sessions not to use this SQL profile for their queries. How would you implement this?

 

clip_image009

 

A.

Alter the SQL profile to change the category of the SQL profile.

B.

Set the OPTIMIZER_USE_PENDING_STATISTICS to TRUE the desired sessions.

C.

Use database resource manager to prevent the use of the SQL profile by these user sessions.

D.

Use database resource manager to preUse the resource management feature in profiles of these users to prevent the use of the SQL profile.

 

Correct Answer: A

 

 

QUESTION 49

You work for a small manufacturing company as a DBA. The company has various applications to manage the details of its business and customer base. The company has only one sales outlet where the operator updates the SALES table in the sales application with the details when a product is sold. The company has many other applications for various other businesses that use the same database.

 

The sales operator, while generating a report, noticed that there are some gaps generated in the serial number in the SLNO column during peak hours of business.

 

On investigating, you find that the SLNO column in the SALES table uses the SLNSEQ sequence to generate the serial numbers when a record is inserted.

 

During peak hours, you noticed the following:

 

When the operator entered the sales details the last time, the sequence number was 1056300, but when you checked the sequence as follows, you found a gap of 100 numbers:

 

SQL> SELECT sequence_name, last_number FROM user_sequences WHERE

 

sequence_name=’SLNSEQ’;

 

SEQUENCE_NAME LAST_NUMBER

 

—————————– ———–

 

SLNSEQ 1056400

 

You observed this behavior many times and only during peak hours.

 

What could be the problem and solution for this?

 

A.

The reserved pool is not configured. Configure the reserved pool.

B.

The keep buffer pool is not configured. Configure the keep buffer pool.

C.

The sequence was created with a CACHE of 100 numbers. Re-create the sequence with a higher CACHE number.

D.

The sequence is aging out of the shared pool. Keep the sequence in the shared pool using the DBMS_SHARED_POOL.KEEP procedure.

 

Correct Answer: D

 

 

QUESTION 50

View the Exhibit and examine the Automatic Database Diagnostic Monitor (ADDM) performance analysis. Identify the correct description of the Impact(%) column in the Exhibit.

 

clip_image010

 

A.

It is the time consumed by the corresponding issue compared with the database time for the analysis period.

B.

It is the time consumed by the corresponding issue compared with the response time for the analysis period.

C.

It is the workload volume by the corresponding issue compared with theSYSTEM_MOVING_WINDOW baseline for the analysis period.

D.

It is the resource consumed by the corresponding issue compared with the SYSTEM_MOVING_WINDOW baseline for the analysis period.

 

Correct Answer: A

 

Free VCE & PDF File for Oracle 1Z0-054 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

This entry was posted in 1Z0-054 Exam Questions (December) and tagged , , , , , , . Bookmark the permalink.