Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 401:

  What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

  A. An upper limit on how far you can flash back the database, depending on the information in the redo logs
  B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace
  C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
  D. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space
  C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

• Question 402:

  As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query? (Choose two.)

  SQL> select group_number, name, state from v$ASM_DISKGROUP;

  GROUP_NUMBER NAME STATE ============ ======= ========== 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTED

  A. The DGROUP1 disk group was unmounted by another DBA.
  B. A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
  C. One of the redundant disks (DGROUP1) has been lost in a disk group.
  D. This query has no meaning in an ASM instance.
  E. A disk associated with a disk group was discovered after the ASM instance initially opened.
  A. The DGROUP1 disk group was unmounted by another DBA.
  E. A disk associated with a disk group was discovered after the ASM instance initially opened.

• Question 403:

  Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)

  A. It is a copy or a subset of the target database.
  B. It is opened in RESTRICT mode after a duplicating operation.
  C. It is created by using backups and archived redo log files from the target database.
  D. It is created with the same database identifier (DBID) as that of target database.
  A. It is a copy or a subset of the target database.
  C. It is created by using backups and archived redo log files from the target database.

• Question 404:

  Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)

  A. SORT_AREA_SIZE
  B. HASH_AREA_SIZE
  C. BITMAP_MERGE_AREA_SIZE
  D. CREATE_BITMAP_AREA_SIZE
  E. PGA_AGGREGATE_TARGET
  A. SORT_AREA_SIZE
  B. HASH_AREA_SIZE
  C. BITMAP_MERGE_AREA_SIZE
  D. CREATE_BITMAP_AREA_SIZE

• Question 405:

  Which command will result in a trace file being created with the create controlfile command contained in it?

  A. alter database backup controlfile;
  B. alter database backup controlfile to trace;
  C. alter database controlfile backup;
  D. alter database controlfile backup to '/ora01/oracle/ctrl_backup.ctl';
  E. alter database begin controlfile backup;
  B. alter database backup controlfile to trace;

• Question 406:

  You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?

  A. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE.
  B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE.
  C. Use compression when performing tape backups.
  D. Configure multiple SBT channels.
  B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE.

• Question 407:

  Examine the following set of RMAN commands:

  RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT '/u02/backup/%U'; RMAN> RUN (

  ALLOCATE CHANNEL Chi DEVICE TYPE DISK;

  EXECUTE SCRIPT full_backup;

  )

  Which statement is true when the RMAN RUN block is executed?

  A. The execution of the script fails because multiple channels cannot coexist.
  B. The script is executed and both the channels are used for the script execution.
  C. The new channel 'CHI' is Ignored because a channel has been configured already.
  D. configuration parameter dc1 is overridden because a new channel is allocated in RMAN RUN block.
  D. configuration parameter dc1 is overridden because a new channel is allocated in RMAN RUN block.

• Question 408:

  What is the result of this command?

  RMAN> Report need backup days 3;

  A. Lists all datafiles created in the last three days that are not backed up.
  B. Lists all datafiles not recoverable based on the current retention criteria.
  C. Lists all datafiles not backed up in the last three days. The datafile is not recoverable.
  D. Lists all datafiles that need to be backed up due to unrecoverable operations.
  E. Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.
  E. Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.

• Question 409:

  You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.)

  A. The au_size disk group attribute determines the size of allocation units in the disk group.
  B. The allocation unit size may vary but the extent size is fixed.
  C. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
  D. Extent management is completely automated.
  A. The au_size disk group attribute determines the size of allocation units in the disk group.
  D. Extent management is completely automated.

• Question 410:

  View the Exhibit to observe the error.

  You receive this error regularly and have to shutdown the database instance to overcome the error.

  Automatic Shared Memory Management is configured for the instance.

  What can you do to reduce the chance of this error in the future?

  Exhibit:

  

  A. Increase the value of SGA_MAX_SIZE
  B. Enable automatic memory management
  C. Set the PRE_PAGE_SGA parameter to true
  D. Lock the System Global Area (SGA) in memory
  B. Enable automatic memory management