Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 631:

  You create a new Automatic Database Diagnostic Monitor (ADDM) task:

  instance_analysis_mode_task. To view the ADDM report, you use the following command:

  SQL> SELECT dbms_addm.get_report('my_instance_analysis_mode_task') FROM dual;

  You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments.

  What would you do to achieve this?

  A. Add a finding directive for the ADDM task.
  B. Add a segment directive for the ADDM task.
  C. Add a parameter directive for the ADDM task.
  D. Disable the Segment Advisor from the Automatic Maintenance Task.
  B. Add a segment directive for the ADDM task.

• Question 632:

  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.
  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.

• Question 633:

  Which is not a valid locale definition file type?

  A. Language
  B. Linguistic sort
  C. Calendar
  D. Territory
  E. Character set
  C. Calendar

• Question 634:

  View the Exhibit and examine the steps that you executed to create a database resource plan.

  Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( ); What could be the reason?

  

  A. The pending area is automatically submitted after the plan creation
  B. The procedure must be executed before creating the resources plan directive
  C. The SYS_GROUP resource consumer group is not included in the resource plan directive
  D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
  D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

• Question 635:

  Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS, which statement is true?

  A. You cannot perform the TSPITR with the constraints enabled.
  B. You must perform the TSPITR recovery of both tablespaces for it to be successful.
  C. You can perform TSPITR only on the USERS tablespace.
  D. RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
  E. The TSPITR will only be successful if the constraint is enabled.
  B. You must perform the TSPITR recovery of both tablespaces for it to be successful.

• Question 636:

  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
  A. Schedule object
  D. Resource plan

• Question 637:

  Which two statements are true regarding hot patching? (Choose two.)

  A. It requires relinking of the Oracle binary.
  B. It does not require database instance shutdown.
  C. It can detect conflicts between two online patches.
  D. It is available for installing all patches on all platforms.
  E. It works only in a single database instance environment.
  B. It does not require database instance shutdown.
  C. It can detect conflicts between two online patches.

• Question 638:

  Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN. (Choose all that apply.)

  A. Backup retention policy
  B. Default backup device type
  C. Default destinations for backups
  D. Multiple backup device types for single backup
  E. Default section size for backups
  A. Backup retention policy
  B. Default backup device type
  C. Default destinations for backups

• Question 639:

  You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?

  A. Set metric threshold
  B. Implement Database Resource Manager
  C. Enable resumable timeout for user sessions
  D. Add directives to Automatic Database Diagnostic Monitor (ADDM)
  B. Implement Database Resource Manager

• Question 640:

  Which command do you use to create a recovery-catalog schema?

  A. create recovery catalog
  B. create catalog
  C. build catalog
  D. catalog create
  E. mount catalog
  B. create catalog