Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 121:

  You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.

  Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task? (Choose all that apply.)

  A. SYSTEM
  B. SYSAUX
  C. UNDO
  D. USERS
  E. TEMP
  F. This restore is not possible.
  A. SYSTEM
  B. SYSAUX
  C. UNDO
  D. USERS

• Question 122:

  Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space;

  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE =============== =============== =============== ========== LMTEMP 250609664 101048576 149561088

  Which two statements correctly interpret the output? (Choose two.)

  A. FREE_SPACE indicates only the space that is currently unallocated.
  B. ALLOCATED_SPACE indicates only the space currently allocated and in use.
  C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.
  D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
  E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
  D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.
  E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

• Question 123:

  You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?

  A. Set a threshold for the default system-defined moving window baseline.
  B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).
  C. Modify the profile for the targeted users for which control needs to be imposed.
  D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
  D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

• Question 124:

  Which two statements are true about an image copy backup? (Choose two.)

  A. It may only be taken to disk.
  B. It will contain only the used blocks.
  C. It will contain all used and unused blocks.
  D. It can be performed on disk as well as on tape.
  A. It may only be taken to disk.
  C. It will contain all used and unused blocks.

• Question 125:

  Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)

  A. Schedule objects
  B. Program arguments
  C. Job classes
  D. Job arguments
  E. All of the above
  A. Schedule objects
  B. Program arguments
  D. Job arguments

• Question 126:

  You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):

  RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

  Identify the statement that correctly describes the implications of this command.

  A. when there are already three backups, for the fourth backup RMAN removes the oldest backup.
  B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.
  C. the number of backups that are retained is equal to three and it includes full, incremental, and cumulative backups.
  D. when there are already three backup, one of the existing backups must be removed manually before taking the fourth backup.
  B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.

• Question 127:

  A schedule defined entirely within the confines of a Scheduler job object is known as a (n) ________________.

  A. Fixed schedule
  B. Inline schedule
  C. Stored schedule
  D. Hard-coded schedule
  E. None of the above
  B. Inline schedule

• Question 128:

  A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?

  A. backup database all
  B. backup compressed database
  C. backup as compressed backupset database;
  D. backup as compressed backup database plus archivelog all;
  E. backup as compressed backupset database plus compress archivelog all;
  A. backup database all

• Question 129:

  You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?

  A. Restore and recover the datafile.
  B. Restore and recover the tablespace.
  C. Restore and recover the database.
  D. Restore and recover the control file.
  E. Restore and recover the parameter file.
  A. Restore and recover the datafile.

• Question 130:

  Which two statements about workload capture and replay operations are true? (Choose two.)

  A. The clients must be created manually on the test machines to perform more realistic testing.
  B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
  C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
  D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
  C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
  D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.