Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 41:

  Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG mode database.

  a: restore database;

  b: recover database;

  c: shutdown immediate

  d: startup

  e: restore archivelog all;

  f:

  alter database open

  A. a, b, c, d, e, f
  B. c, b, a, d, e, f
  C. c, b, a, d, f
  D. c, a, b, d
  E. c, a, e, b, d, f
  E. c, a, e, b, d, f

• Question 42:

  You executed the following commands in a database session:

  

  What could have caused the recycle bin to clean up?

  A. There is demand for space from the new table
  B. The undo tablespace does not have sufficient free space
  C. The new table name is the same as the table name in the recycle bin
  D. The temporary tablespace that is assigned to you does not have sufficient free space
  A. There is demand for space from the new table

• Question 43:

  Which three elements can a job chain process involve? (Choose three)

  A. an event
  B. a schedule
  C. a program
  D. another chain
  E. a lightweight job
  B. a schedule
  D. another chain
  E. a lightweight job

• Question 44:

  Which of these represent the main components of Database Resource Manager? (Choose all that apply.)

  A. Resource consumer groups
  B. Resource plans
  C. Resource-plan groups
  D. Resource-plan directives
  E. All of the above
  A. Resource consumer groups
  B. Resource plans
  D. Resource-plan directives

• Question 45:

  Identify the three predefined server-generated alerts. (Choose three.)

  A. Drop User
  B. Tablespace Space Usage
  C. Resumable Session Suspended
  D. Recovery Area Low On Free Space
  E. SYSTEM Tablespace Size Increment
  B. Tablespace Space Usage
  C. Resumable Session Suspended
  D. Recovery Area Low On Free Space

• Question 46:

  How long will this backup be allowed to run?

  Backup as compressed backupset duration 2:00 minimize load database;

  A. 2 minutes
  B. 2 hours
  C. 2 days
  D. The command will generate an error.
  E. This backup is not constrained by any time limitation.
  B. 2 hours

• Question 47:

  How many individual archive-log destination directories are supported by Oracle Database11g?

  A. 7
  B. 1
  C. 10
  D. 11
  E. 21
  C. 10

• Question 48:

  What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?

  A. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA
  B. CONFIGURE DEFAULT DEVICE TYPE TO TAPE
  C. CONFIGURE DEFAULT DEVICE TYPE TO SBT
  D. CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE
  C. CONFIGURE DEFAULT DEVICE TYPE TO SBT

• Question 49:

  Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.)

  A. a job
  B. a program
  C. a schedule
  D. a PL/SQL procedure
  A. a job
  B. a program
  C. a schedule

• Question 50:

  The following query will provide what information about transportable tablespaces for the current database? (Choose all that apply.)

  

  A. The list of target platforms having the same endian format as the source database
  B. The list of target platforms requiring endian conversion
  C. The list of target platforms that will not require endian conversion
  D. The list of all target platforms that can receive transportable tablespaces from the source database
  E. None of the above
  A. The list of target platforms having the same endian format as the source database
  C. The list of target platforms that will not require endian conversion