1Z0-053 | The Secret of Oracle 1Z0-053 braindumps


Q251. Examine the following scenario:

The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:

RMAN> RUN

{

ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;

DUPLICATE TARGET DATABASE TO auxdb;

}

Which statement is true about the duplicate database in this scenario?

A. It contains data till the last backup

B. It contains all data from target database until the current time

C. It contains all data from only the committed transactions in the target database

D. It contains all data except that which is used by the transactions in the current online redo file of target database

Answer: D

Q252. How is block-change tracking enabled?

A. With alter database enable block change tracking

B. With alter system enable block change tracking

C. With an init.ora parameter change

D. With an spfile parameter change

Answer: A

Q253. Within a resource-plan definition, what differentiates a top-level plan from a subplan?

A. A subplan has the PLAN_SUB parameter value set to SUB.

B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition.

C. There is no difference in the resource-plan definition.

D. A subplan always has the CPU_MTH parameter value set to RATIO.

E. The string TOP_LEVEL is appended to the name of top-level resource plans.

Answer: C

Q254. You want to migrate your database to ASM, so you've done a clean shutdown, made a closed backup of the entire database, noted the location of your control files and online redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion. Using the following steps, what is the correct order in which the following RMAN commands should be executed?

1. STARTUP NOMOUNT

2. ALTER DATABASE OPEN RESETLOGS

3. SQL "ALTER DATABASE RENAME `logfile1 path' TO `+dgrp4 `" # plus all other logfiles

4. SWITCH DATABASE TO COPY

5. BACKUP AS COPY DATABASE FORMAT `+dgrp4'

6. ALTER DATABASE MOUNT

7. RESTORE CONTROLFILE FROM `controlfile_location'

A. 2, 5, 3, 1, 7, 6, 4

B. 1, 7, 6, 5, 4, 3, 2

C. 5, 1, 2, 7, 4, 6, 3

D. 7, 3, 1, 5, 6, 2, 4

Answer: B

Q255. You issued the following commands to configure setting in RMAN;

RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Then you issued the following command to take the backup:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of the above command?

A. The backup will terminate because the FORMAT clause was not configured for the channel

B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

Answer: D

Q256. Which of the following statements is true regarding implementing a Flashback Table recovery?

A. An SCN is never used to perform a Flashback Table recovery.

B. If a significant number of changes have been made to the table, row movement must be enabled.

C. The tablespace must be offline before performing a Flashback Table recovery.

D. Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.

Answer: D

Q257. The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?

A. owner

B. touser

C. attach

D. remap_schema

Answer: D

Q258. You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

Answer: C

Q259. The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?

A. The tape I/O performed is asynchronous

B. The tape buffer is allocated from the System Global Area (SGA)

C. The tape buffer is allocated from the Program Global Area (PGA)

D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

Answer: C

Q260. Which of the following statements are true about the BACKUP command? (Choose all that apply.)

A. The BACKUP command can not be used to make image copies of a datafile.

B. The BACKUP command can improve performance by multiplexing backup files.

C. The BACKUP can take advantage of the block-change tracking capability.

D. The BACKUP command cannot store data in incremental backups.

E. The BACKUP command can store data in cumulative incremental backups only.

Answer: BC