1Z0-053 | A Review Of Realistic 1Z0-053 exam question


Q201. View the Exhibit.

As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals.

Which background process performs this activity?

A. CKPT

B. SMON

C. MMON

D. DBWR

Answer: C

Q202. You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command:

RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS;

After configuring the recovery window, you performed the database backup as follows:

A. Backup RB1 at log sequence number 12871 on 5th Jan

B. Backup RB2 at log sequence number 15622 on 12th Jan

C. Backup RB3 at log sequence 16721 on 15th Jan

D. On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.

Answer: D

Q203. View the Exhibit and examine the Data Pump architecture.

Identify the numbered components.

A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API

B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader

C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump

D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump

Answer: A

Q204. The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?

A. to prevent the creation of an excessive number of scheduler job classes

B. to allow the Automated Maintenance Tasks to use system resources without any restriction

C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window

D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

Answer: D

Q205. If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that apply.)

A. The next time you back up the database when you are also connected to the recovery catalog and the target database

B. The next time you are connected to the target database and the recovery catalog database and issue the resync command

C. The next time you connect RMAN to just the recovery catalog

D. The next time you connect to the recovery catalog and the target database with RMAN

E. Connecting to the recovery catalog and issuing the resync all databases command

Answer: AB

Q206. If a job references a schedule that has been disabled, what will be the result?

A. The job will be automatically disabled.

B. The job will never execute.

C. The job will attempt to execute but will fail.

D. The job will inherit the DEFAULT_SCHEDULE schedule.

E. A schedule object cannot be disabled.

Answer: E

Q207. Which of the following statements best describes Flashback Versions Query?

A. Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.

B. Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.

C. Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.

D. Flashback Versions Query is used to view all version changes on rows that existed between two points in time.

Answer: D

Q208. You issued the following command to mount the DATA disk group in restricted mode:

ALTER DISKGROUP data MOUNT RESTRICT;

What is the implication of this command?

A. The client RDBMS instance can access the file as a read-only file.

B. A new disk cannot be added to a disk group.

C. A disk in a disk group can be taken offline.

D. The client RDBMS instance cannot access the files in the disk group.

Answer: D

Q209. Which command do you use to create a recovery-catalog schema?

A. create recovery catalog

B. create catalog

C. build catalog

D. catalog create

E. mount catalog

Answer: B

Q210. What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?

A. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA

B. CONFIGURE DEFAULT DEVICE TYPE TO TAPE

C. CONFIGURE DEFAULT DEVICE TYPE TO SBT

D. CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE

Answer: C