CertsTopics Logo

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

Pass Using 1z0-062 Exam Dumps

Page: 9 / 14
Total 379 questions
Get 1z0-062 Full Access Download 1z0-062 PDF

Oracle Database 12c: Installation and Administration Questions and Answers

Question 33

You want a job that performs a bulk insert as soon as the loader file arrives on the local file system.

Which two would you do to accomplish this? (Choose two.)

Options:

A.

Create a file watcher

B.

Create a bulk loader watcher

C.

Create a light weight job for bulk insert

D.

Create an event-based job for bulk insert

E.

Create a job chain with a step for bulk insert

Question 34

Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)

Options:

A.

All administration tasks must be done to a specific pluggable database.

B.

The pluggable databases increase patching time.

C.

The pluggable databases reduce administration effort.

D.

The pluggable databases are patched together.

E.

Pluggable databases are only used for database consolidation.

Question 35

Your database is configured in ARCHIVELOG mode.

Examine the RMAN configuration parameters:

Examine the command:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which two are true? (Choose two.)

Options:

A.

It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command

B.

It creates image copies of the archivelogs

C.

It creates a backupset of archive log files

D.

It creates image copies of the database files

E.

It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command

Question 36

You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:

– Applications will connect to the database via a middle tier.

– The number of concurrent user connections will be high.

– The database will have mixed workload, with the execution of complex BI queries scheduled at night.

Which DBCA option must you choose to create the database?

Options:

A.

a General Purpose database template with default memory allocation

B.

a Data Warehouse database template, with the dedicated server mode option and AMM enabled

C.

a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled

D.

a default database configuration

Page: 9 / 14
Total 379 questions
Get 1z0-062 Full Access Download 1z0-062 PDF