CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Database 12c 1z0-067 Release Date

Page: 3 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF

Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP Questions and Answers

Question 9

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.

Examine the steps to recover this table from an RMAN backup:

1.Determine which backup contains the table that needs to be recovered.

2.Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.

3.Import the Data Pump export dump file into the auxiliary instance.

4.Create a Data Pump export dump file that contains the recovered table on a target database.

Identify the required steps in the correct order.

Options:

A.

1, 4, 3

B.

1, 2

C.

1, 4, 3, 2

D.

1, 2, 4

Question 10

Which two statements describe the relationship between a window, a resource plan, and a job class?

Options:

A.

A window specifies a Resource Manager plan that is automatically activated when the windows opens.

B.

A window specifies a job class that will be activated when that window opens.

C.

A job class specifies a window that will be open when that job class becomes active.

D.

A window and the job class associated with a job controls resource allocation for that job.

E.

A window and the Resource Manager plan that is active when a job runs determine the job class for the job.

Question 11

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

Which method or feature should you use?

Options:

A.

Compare Period ADDM report

B.

AWR Compare Period report

C.

Active Session History (ASH) report

D.

taking a new snapshot and comparing it with a preserved snapshot

Question 12

Identify three benefits of unified auditing.

Options:

A.

Decreased use of storage to store audit trail rows in the database.

B.

It guarantees zero-loss auditing.

C.

The audit trail cannot be easily modified because it is read-only

D.

It improves overall auditing performance.

E.

It automatically audits Recovery Manager (RMAN) events.

Page: 3 / 10
Total 263 questions
Get 1z0-067 Full Access Download 1z0-067 PDF