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

Ensurepass

QUESTION 71

In your organization, there are two key databases. One of them is used primarily for an online transaction processing (OLTP) application and is directly accessed by the users in a client/server configuration. The application must process an average of 4,000 small transactions per day. The users enter frequent queries on whose results they depend for completing their transactions. One of the SLA requirements is that any query or transaction processing in the OLTP system should not exceed 15 seconds. The second database supports a decision support system (DSS) as well as batch report programs. It is accessed by client-side users, who submit ad hoc queries through SQL*Plus and by a browser-based,third party application that provides pooled connections for a large user base. Thequeries vary: some fetch only a few records, whereas others fetch and sort hundreds of records from several tables. As per the SLA specification the average turnaround time for a query on the DSS returning 10000 records should be 24 hours. For both the systems, the number of users is not consistent and may vary from time to time.The management wants to ensure maximum resource usage is allocated for the OLTP processing. Which two considerations should you give priority to when tuning these databases? (Choose two.)

 

A.

Minimize parallelism for the OLTP systems.

B.

Maximize throughput for batch processing.

C.

Minimize the response time for OLTP users.

D.

Maximize parallelism for the decision support systems.

E.

Minimize response time for the decision support systems.

 

Correct Answer: BC

 

 

QUESTION 72

What type of redundancy would you recommend for the Automatic Storage Management (ASM) of a file system based on RAID level 1 for the optimum performance of database using ASM storage?

 

A.

high redundancy

B.

normal redundancy

C.

external redundancy

D.

use both ASM mirroring and hardware mirroring

 

Correct Answer: C

 

 

QUESTION 73

View the Exhibit and analyze the output of a query executed on the V$MEMORY_RESIZE_OPS view. Why do INITIAL_SIZE, TARGET_SIZE, and FINAL_SIZE columns have the value zero for some of the components?

 

clip_image002

 

A.

because they are the only components that are auto-tuned

B.

because they are the only components that are not auto-tuned

C.

because they are the only components that have not undergone any manual resizing

D.

because they are the only components that do not have a default size or their respective parameters are not set in the initialization parameter file

 

Correct Answer: D

 

 

QUESTION 74

Your database has the ACCTG service configured for an accounting application that runs on a middle tier. The application has three modules LEDGER, ACCOUNTS, and BILLING. You enabled tracing at the service level by executing the following command:

 

SQL> exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(‘ACCTG’);

 

Which statement is true?

 

A.

A single trace file would be created for all the sessions for the service.

B.

Three trace files would be created for the three modules in the application.

C.

The trace file would not be created because the module name is not specified.

D.

A trace file is created for each session that uses the service, regardless of the module and action.

 

Correct Answer: D

 

 

QUESTION 75

View the Exhibit and examine the content of the V$PGA_TARGET_ADVICE_HISTOGRAM view. What would you infer from this?

 

clip_image004

 

A.

If the PGA size is set to 4 MB, then all the work areas would execute in optimal mode.

B.

If the PGA size is doubled, then all the work areas that are less than 2 MB would execute in optimal mode.

C.

If the PGA size is set to 32 MB, then the number of work areas would reduce. So it is the appropriate size for PGA.

D.

If the size of the Program Global Area (PGA) is set to more than 64 MB, then all the work areas would execute in optimal mode. So it is the appropriate size for PGA.

 

Correct Answer: B

 

 

QUESTION 76

View the Exhibit and examine portions of two ASH reports generated for the same time period. The second report was generated after the ASH data is flushed to disk.Why is the sample count reduced in the second report?

 

clip_image005

 

A.

because the AWR is not able to store all the samples.

B.

because the samples
have been filtered from ASH buffer.

C.

because a portion of the ASH rolling buffer has been overwritten.

D.

because the shared pool size is not enough to hold ASH information.

 

Correct Answer: B

 

 

QUESTION 77

You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP) system.The applications running on the database use connection pooling to connect to the database to perform transactions. The company wants to upgrade the CPU and the memory for the machine on which the database isrunning. To test the realistic workload on the new machine with increased CPU and memory, you identified the peak workload time for the database and captured the workload on the production system. You set up the test machine with the upgraded CPU and memory and installed the database with the same version as production. Which three actions would you perform to accomplish the realistic replay of the peak workload on the test machine? (Choose three.)

 

A.

Preprocess the captured workload for the specified target database version.

B.

Set up as many replay clients as there are actual clients to the production system.

C.

Set up all the replay clients on the same machine on which the test database is running.

D.

Resolve all external references such as database links, external tables, and directory objects.

E.

Restore the replay database to match the capture database at the start of the workload capture.

 

Correct Answer: ADE

 

 

QUESTION 78

For which two systems would you recommend configuring DBWR I/O slaves instead of multiple database writer processes? (Choose two.)

 

A.

for systems where you have a single CPU

B.

for systems where asynchronous I/O is not available

C.

for systems with multiple CPUs or multiple processor groups

D.

for systems where asynchronous I/O is available and configured

E.

for systems where throughput is an important performance consideration

 

Correct Answer: AB

 

 

QUESTION 79

You are working on an online transaction processing (OLTP) system. The CUST table in the SH schema was populated by direct load and after that it has gone through a lot of updates and deletions. The statistics for the CUST and SALES tables were updated recently.View the Exhibit and examine the query plan.The query is performing a lot of I/O for a query that fetches only 168 rows. To investigate further, you queried the ALL_TABLES view to find out PCTUSED, PCTFREE, and the number of rows in the CUST table, as given below:

 

SQL> SELECT table_name ,blocks, pct_used, pct_free, num_rows

 

2 FROM all_tables

 

3 * WHERE table_name = ‘CUST’;

 

TABLE_NAME BLOCKS PCT_USED PCT_FREE NUM_ROWS

 

——— ———- ———- ———- ———-

 

CUST 13768 80 111060

 

What would you recommend to reduce the I/O?

 

clip_image007

 

A.

reorganizing the table to use fewer blocks

B.

rebuilding the index on the CUST_FIRST_NAME column

C.

increasing the value for the PCTFREE attribute for the CUST table

D.

increasing the value for the PGA_AGGREGATE_TARGET initialization parameter

 

Correct Answer: A

 

 

 

 

 

 

 

 

 

 

QUESTION 80

View the Exhibit and examine the details of the Top 5 Timed Events from an Automatic Workload Repository (AWR) report.What can be the three possible causes for the latch- related wait events? (Choose three.)

 

clip_image009

 < /font>

A.

Shared pool size is too small.

B.

Cursors are not being shared.

C.

There are frequent logons/logoffs.

D.

A large number of COMMITs are being performed.

E.

A large number of data definition language (DDL) and query statements are being executed simultaneously by different sessions.

 

Correct Answer: ABC

 

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 …