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

Selected 1z0-062 Oracle Database 12c Questions Answers

Page: 12 / 14
Total 379 questions

Oracle Database 12c: Installation and Administration Questions and Answers

Question 45

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 46

Identify three uses of the CROSSCHECK command (Choose three.)

Options:

A.

to validate the database backup

B.

to synchronize logical backup records with physical files in backup storage

C.

to check the obsolete backups that can be deleted from the file system

D.

to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file

E.

to update the recovery catalog or control file if archived log files are deleted with operating system commands

Question 47

You have a production Oracle 12c database running on a host.

You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.

The steps in random order:

1. Create directory structures similar to the production database on all new machines.

2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.

3. Create a database clone template for the database.

4. Run the Database Configuration Assistant (DBCA) to create the database.

5. Run OUI in graphical mode on each machine.

6. Run OUI in silent mode using the OUI response file.

Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

Options:

A.

1, 5, and 4

B.

3, 1, 5, and 6

C.

2, 3, 6, and 4

D.

2, 1, 6, and 4

E.

2, 3, 1, and 6

Question 48

What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

Options:

A.

Optimizer statistics are collected automatically.

B.

Only timed operating system (OS) statistics and plan execution statistics are collected.

C.

Automatic Workload Repository (AWR) snapshots are not generated automatically.

D.

The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

Page: 12 / 14
Total 379 questions