CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Oracle Database 12c Changed 1z0-060 Questions

Page: 2 / 8
Total 208 questions
Get 1z0-060 Full Access Download 1z0-060 PDF

Upgrade to Oracle Database 12c Questions and Answers

Question 5

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

Question 6

Which two statements are true about the installation modes in Oracle Database 12c?

Options:

A.

Response file mode is useful when you require multiple Oracle Homes with variation in some of the installation parameters for each home.

B.

In Interactive mode, parameter values are read from a response file and can be changed during installation.

C.

In response file mode, you can Include responses for some or all prompts.

D.

In silent mode installation, you can validate the parameter values on Installation screens for which you have provided information in the response file.

Question 7

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

Options:

A.

tracking the most recent read time for a table segment in a user tablespace

B.

tracking the most recent write time for a table segment in a user tablespace

C.

tracking insert time by row for table rows

D.

tracking the most recent write time for each block in a table segment

E.

tracking the most recent read time for a table segment in the SYSAUX tablespace

F.

tracking the most recent write time for a table segment in the SYSAUX tablespace

Question 8

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

Page: 2 / 8
Total 208 questions
Get 1z0-060 Full Access Download 1z0-060 PDF