Weekend 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

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events? (Choose three.)

Options:

A.

The size of the shared pool is too small.

B.

Cursors are not being shared.

C.

A large number COMMITS are being performed.

D.

There are frequent logons and logoffs.

E.

The buffers are being read into the buffer cache, but some other session is changing the buffers.

Buy Now
Question 2

Your database is running an ARCHIVELOG mode.

The following parameters are set in your database instance:

Which statement is true about the archived redo log files?

Options:

A.

They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

B.

They are created only in the Fast Recovery Area because configuring the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters automatically enables flashback for the database.

C.

They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

D.

They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the location specified by the DB_RECOVERY_FILE_DEST parameter.

Question 3

You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours.

For which three reasons would you use the Compare Period ADDM report after the replay? (Choose three.)

Options:

A.

to check the database time consumed for the two time periods

B.

to review the change in the initialization parameters between the two runs

C.

to find the resource consumption by SQL statements that are common to both periods

D.

to check the performance improvement and degradation caused during the change

E.

to review the hardware resources used during the two runs

F.

to compare the performance change of top SQL statements for the two runs