Month End Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Note! Following 1z0-060 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

Upgrade to Oracle Database 12c Questions and Answers

Question 1

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.

What should you use to achieve this?

Options:

A.

Database replay

B.

SQL Tuning Advisor

C.

SQL Access Advisor

D.

SQL Performance Analyzer

E.

Automatic Workload Repository compare reports

Buy Now
Question 2

Identify the prerequisite for configuring and accessing Enterprise Manager (EM) express for an Oracle 12c database.

Options:

A.

Create a SYSMAN user with the SYSDBA role as an administrator for EM express.

B.

Configure the DISPATCHERS initialization parameter such that at least one dispatcher is configured for the XMLDB service with the TCP protocol.

C.

Install the Oracle HTTP Server.

D.

Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure port number 5500 for the HTTP server.

Question 3

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.

Examine the following command and its output:

What does this imply?

Options:

A.

When you start an instance on a host with SQL*Plus, the dependent listeners and ASM disk groups are automatically started.

B.

When a database instance is started by using the SRVCTL utility and the listener startup fails, the instance is still started.

C.

When a database is created by using SQL*Plus, it is automatically added to the Oracle Restart configuration.

D.

When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.