1Z0-053 | how many questions of 1Z0-053 dumps?


Q301. Which of the following are correct about block media recovery? (Choose all that apply.)

A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION.

B. Logical corruptions are repairable by BMR.

C. Physical corruptions are repairable by BMR.

D. RMAN can use any backup for a BMR restore.

E. ARCHIVELOG mode is not required if you have both a full and incremental backup for restore.

Answer: AC

Q302. AUM has been retaining about 15 minutes' worth of undo. You want to double the retention period, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes' worth of undo. What is the problem? (Choose the best answer.)

A. You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.

B. You need to increase the size of the undo tablespace.

C. The undo tablespace is not set to auto-extend.

D. You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.

Answer: C

Q303. Which two statements are true with respect to the maintenance window? (Choose two.)

A. A DBA can enable or disable an individual task in all maintenance windows.

B. A DBA cannot change the duration of the maintenance window after it is created.

C. In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.

D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

Answer: AD

Q304. The RVPC user can do which of the following? (Choose all that apply.)

A. Register databases if granted the register database privilege

B. See all databases in the recovery-catalog schema

C. See all database-related metadata in the recovery catalog if they are granted access to that database

D. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant command

E. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

Answer: AC

Q305. Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)

A. ALTER DISKGROUP misc MOUNT;

B. ALTER DISKGROUP misc DROP DISK misc2;

C. ALTER DISKGROUP misc CHECK ALL NOREPAIR;

D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;

E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*'

Answer: AC

Q306. What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?

A. The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.

B. The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.

C. The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.

D. There is no ASM_POWER_LIMIT setting used in ASM.

E. None of the above

Answer: C

Q307. Examine the following values of the initialization parameters in the database having the SID ORCL:

BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump

USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump

CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump

DIAGNOSTIC_DEST=

The environment variables have the following value:

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1

What is the location of the Automatic Diagnostic Repository (ADR) home?

A. /u01/app/oracle/product/11.1.0/db_1

B. /u01/app/oracle

C. $ORACLE_HOME/bdump

D. $ORACLE_HOME/log

Answer: B

Q308. View the Exhibit and examine the output.

You execute the following RMAN command to perform the backup operation:

RMAN> RUN {

ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8;

BACKUP DATABASE FILESPERSET 4;

}

What is the multiplexing level in the preceding backup process?

A. 4

B. 8

C. 7

D. 0

Answer: A

Q309. Which of the following objects can be directly referenced by a window object? (Choose all that apply.)

A. Schedule object

B. Program object

C. Job object

D. Resource plan

E. Resource consumer group

Answer: AD

Q310. When a job exceeds the date specified in its END_DATE attribute, which of the following will happen? (Choose all that apply.)

A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.

B. The job will only be disabled if the value of the AUTO_DROP attribute is FALSE.

C. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE.

D. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE.

E. The STATE column of the job table will be set to COMPLETED for the job.

Answer: ABE