Question No 1

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.)

Choose the Choices:

Create a file watcher

Create a bulk loader watcher

Create a light weight job for bulk insert

Create an event - based job for bulk insert

Create a job chain with a step for bulk insert

Question No 2

Which four are true about creating and running a remote database scheduler jobs? (Choose four.)

Choose the Choices:

A database destination must exist or be created for the remote database

It must run as a user that is defined on the remote database

Remote database jobs always run as the same user who submits the job on the local database

A credential is optional for a remote database job

A credential must be created to define the remote user

A database destination group must exist or be created for a job to run on multiple remote databases

A destination is optional for a remote database job because DB links can be used instead

Question No 3

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.)

Choose the Choices:

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

It creates image copies of the archivelogs

It creates a backupset of archive log files

It creates image copies of the database files

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

Question No 4

Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

Choose the Choices:

It loads data faster than conventional SQL*Loader

No data file needs to be specified

It can load data in parallel

It loads data more efficiently than conventional SQL*Loader

It requires Enterprise Manager Express to be configured

Question No 5

Which are two ways for a database service to be recognized by a listener in Oracle Database 12c? (Choose two.)

Choose the Choices:

Dynamic Registration by the LREG process

Dynamic Registration by the SMON process

Static registration in the listener.ora file using the GLOBAL_DBNAME parameter

Dynamic Registration by the PMON process

Static registration in the listener.ora file using the SERVICE_NAME parameter

Practice Oracle 1Z0-062 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

1Z0-062 Exam Features

1Z0-062 PDF Dumps