Latest Oracle 1z1-064 Actual Free Exam Questions & Community Discussion, Page 1

Question #1

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

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

D. Create services for the applications and set the relative priority of services within an instance by mapping the services directly to consumer groups.

Discussion 0

Correct Answer: C Vote an answer

Question #2

Examine the partial PLAN_TABLE output:

Which is the correct sequence of execution? (Choose the best answer.)

A. 0, 4, 1, 3, 2, 1

B. 0, 1, 2, 3, 4, 1

C. 3, 2, 1, 4, 0

D. 3, 2, 4, 1, 0

E. 3, 2, 4, 1, 0, 2

Discussion 0

Correct Answer: C Vote an answer

Question #3

Examine the parameters set for your database instance:

You are administering a database that supports an OLTP workload. Users complain about the degraded performance of some queries. While diagnosing, you notice a large number of hard parses occurring for several syntactically almost identical SQL statements that differ only in literal values in the WHERE clause.
Which two actions would you recommend to improve performance? (Choose two.)

A. Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.

B. Create the KEEP cache and cache the tables used in the queries.

C. Create SQL plan baselines for the almost identical SQL statements and load them into the cursor cache.

D. Set the CURSOR_SHARING parameter to FORCE.

E. Use bind variables instead of literals.

Discussion 0

Correct Answer: A,D Vote an answer

Question #4

Examine the initialization parameters set for a database instance:

The database supports an OLTP workload. Applications connect to the instance using shared server connections and perform small, random I/Os. All the data files are on the same disk. You notice free buffer wait events for sessions in the database instance.
To solve the problem, you increase the size of the buffer cache. But after some time, you notice sessions waiting again on free buffer waits.
What will you recommend to alleviate the issue? (Choose the best answer.)

A. Configure dedicated server connections for the applications.

B. Configure the database instance to make asynchronous I/O available to DBWR.

C. Run the I/O calibration tool.

D. Spread the data files over multiple disks, controllers, and I/O buses to ensure that there are no hotspots in the I/O subsystem.

Discussion 0

Correct Answer: B Vote an answer

Question #5

Which two are prerequisites for running the I/O calibration tool? (Choose two.)

A. The database instance must be started using an SPFILE.

B. For determining latency time, the STATISTICS_LEVEL parameter must be set to TYPICAL or ALL.

C. The disks to be tested must be configured to use asynchronous I/O for data files.

D. The database should be opened in restricted mode.

E. The database must be in MOUNT state.

Discussion 0

Correct Answer: A,E Vote an answer

Question #6

Which three statements are true about the interpretation of an execution plan? (Choose three.)

A. A TABLE ACCESS FULL in the Operation column for a query with a WHERE clause occurs only if no index exists for the filter column.

B. The cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU resources.

C. An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be returned.

D. A HASH JOIN in the Operation column always implies that two tables are joined by using an equijoin.

E. The ROWS column indicates the cardinality of each operation and is always calculated by dividing the total number of rows in the table by the number of distinct values in the column used in the WHERE clause predicate.

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #7

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

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

B. They are always logged in the alert log.

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

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

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

Discussion 0

Correct Answer: A,D Vote an answer

Question #8

You recently joined a new team administering a database.
You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job.
You decide that performance problems are caused by a misconfiguration of factors affecting full table scans.
Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)

A. value of DB_FILE_MULTIBLOCK_READ_COUNT

B. setting of the DISK_ASYNC_IO parameter to TRUE

C. setting of the OPTIMIZER_MODE parameter to ALL_ROWS

D. use of parallel queries

E. storing query results in the result cache

F. block size of the tablespaces in which the tables being scanned are stored

G. value of the OPTIMIZER_DYNAMIC_SAMPLING parameter

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #9

Which two statements are true about ADDM or Real-Time ADDM? (Choose two.)

A. ADDM can be run manually by selecting any range of AWR snapshots available within the AWR retention period, provided they do not cover a time period when the instances were restarted.

B. ADDM runs in Partial mode to analyze any hung database issues.

C. Real-Time ADDM can proactively detect and diagnose transient performance issues that last for a few seconds.

D. Real-Time ADDM is automatically invoked by ADDM at the end of every hour.

Discussion 0

Correct Answer: B,C Vote an answer

Question #10

You are administrating a database that supports a mixed workload. Applications are running on a middle tier and use connection pooling to connect to the database instance. You want to trace all applications and modules that use the ORCL1 service to connect to the database instance.
How would you consolidate the SQL statements for sessions that are connected by using the ORCL1 service?

A. by using the DBMS_TRACE package to enable tracing and the tkprof utility to consolidate and interpret trace files

B. by setting TRACE_ENABLED = TRUE and using the tkprof utility to consolidate and interpret trace files

C. by using the DBMS_MONITOR package to enable tracing, the trcsess utility to consolidate trace files, and the tkprof utility to interpret trace files

D. by setting SQL_TRACE = TRUE and using the tkprof utility to consolidate and interpret trace files

E. by using the DBMS_MONITOR package to enable tracing, the tkprof utility to consolidate trace files, and the trcsess utility to interpret trace files

Discussion 0

Correct Answer: D Vote an answer

Oracle 1z1-064 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1z1-064 Demo