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

Note! Following 1z0-062 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

Oracle Database 12c: Installation and Administration Questions and Answers

Question 1

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

Options:

A.

You can detach from a data pump export job and reattach later.

B.

Data pump uses parallel execution server processes to implement parallel import.

C.

Data pump import requires the import file to be in a directory owned by the oracle owner.

D.

The master table is the last object to be exported by the data pump.

E.

You can detach from a data pump import job and reattach later.

Buy Now
Question 2

You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.

Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.)

Options:

A.

Archived redo log files that have multiple copies in a different archive location

B.

user-managed backups of data files and control files

C.

RMAN backups that are obsolete

D.

flashback logs

Question 3

A senior DBA asked you to execute the following command to improve performance:

SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);

You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.

What could be a reason for this recommendation?

Options:

A.

The keep pool is not configured.

B.

Automatic Workarea Management is not configured.

C.

Automatic Shared Memory Management is not enabled.

D.

The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

E.

All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.