Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 481:

  Why should you back up a duplicated tablespace after a TSPITR is complete?

  A. The tablespace cannot be duplicated or restored to any point in time after the duplication.
  B. The tablespace cannot be duplicated or restored to the point in time before the duplication.
  C. The entire database cannot be restored after a TSPITR, so a backup is required.
  D. You cannot bring the tablespace online until its been backed up.
  E. There is no requirement to do so, as RMAN will back up the tablespace after the TSPITR.
  B. The tablespace cannot be duplicated or restored to the point in time before the duplication.

• Question 482:

  The EMP table exists in your schema. You want to execute the following query:

  SELECT ename, sal

  FROM emp

  AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)

  WHERE ename = 'ALLEN';

  What are the minimum requirements for the statement to execute successfully? (Choose all that apply)

  A. ARCHIVELOG mode must be enabled
  B. Row Movement must be enabled for the table
  C. FLASHBACK must be set to ON for the database
  D. The UNDO_MANAGEMENT parameter must be set to AUTO
  E. The UNDO_RETENTION parameter must be set appropriately
  D. The UNDO_MANAGEMENT parameter must be set to AUTO
  E. The UNDO_RETENTION parameter must be set appropriately

• Question 483:

  Examine the following command:

  ALTER DISKGROUP data MOUNT FORCE;

  In which scenario can you use the above command to mount the disk group?

  A. when ASM disk goes offline
  B. when one or more ASM files are dropped
  C. when some disks in a disk group are offline
  D. when some disks in a failure group for a disk group are rebalancing
  C. when some disks in a disk group are offline

• Question 484:

  How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?

  A. Issue the grant command from the SYS user (or equivalent) of the target database.
  B. Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
  C. Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
  D. Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
  E. Issue the grant command from RMAN when connected to the target database.
  D. Issue the grant command from RMAN when connected to the recovery catalog-owning schema.

• Question 485:

  You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were

  asked to change the retention from 5 years to 3 years.

  To accomplish this, you issued the following command:

  ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;

  What is the implication of this command?

  A. The command produces an error because the retention time cannot be reduced.
  B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.
  C. All historical data is purged and the new flashback data archives are maintained for three years.
  D. All historical data older than three years is purged from the flashback archive FLA1.
  D. All historical data older than three years is purged from the flashback archive FLA1.

• Question 486:

  You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.

  The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.

  How would you create these jobs?

  A. Create both jobs by using events raised by the scheduler
  B. Create both jobs by using events raised by the application
  C. Create a job to rebuild indexes by using events raised by the application and then create another job to perform bulk load by using events raised by the scheduler
  D. Create a job to rebuild indexes by using events raised by the Scheduler and then create another job to perform bulk load by using events raised by the application
  D. Create a job to rebuild indexes by using events raised by the Scheduler and then create another job to perform bulk load by using events raised by the application

• Question 487:

  View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM). Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?

  A. Because the FRA disk group will not support dynamic rebalancing
  B. Because the FRA disk group is not configured to support mirroring
  C. Because disks in the FRA disk group are not formatted at this stage
  D. Because the FRA disk group will support only a single size of allocation unit
  B. Because the FRA disk group is not configured to support mirroring

• Question 488:

  The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements?

  A. Languages for server messages
  B. Day and month names and abbreviations
  C. Symbols to represent a.m., p.m., AD, and BC
  D. Affirmative and negative response strings (YES, NO)
  E. None of the above
  F. All of the above
  F. All of the above

• Question 489:

  The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode.

  What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table?

  A. Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially
  B. Shrink the BOOKINGS table by using the ALTER TABLE... SHRINK SPACE command
  C. Move the BOOKINGS table to a different location by using the ALTER TABLE... MOVE command
  D. Deallocate the space in the BOOKINGS table by using the ALTER TABLE ... DEALLOCATE UNUSED command
  B. Shrink the BOOKINGS table by using the ALTER TABLE... SHRINK SPACE command

• Question 490:

  What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?

  A. crosscheck
  B. list backup
  C. confirm
  D. resync
  E. backup validate
  A. crosscheck