Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 141:

  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 older than three years is purged from the flashback archive FLA1
  C. All historical data is purged and the new flashback data archives are maintained for three years
  D. All historical data is retained but the subsequent flashback data archives are maintained for only three years
  B. All historical data older than three years is purged from the flashback archive FLA1

• Question 142:

  Which statements are true regardingsystem-partitioned tables? (Choose all that apply.)

  A. Only a single partitioning key column can be specified
  B. All DML statements must use partition-extended syntax
  C. The same physical attributes must be specified for each partition
  D. Unique local indexes cannot be created on a system-partitioned table
  E. Traditional partition pruning and partitionwise joins are not supported on these tables
  D. Unique local indexes cannot be created on a system-partitioned table
  E. Traditional partition pruning and partitionwise joins are not supported on these tables

• Question 143:

  Which two statements are trueregarding the SQL Repair Advisor? (Choose two.)

  A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements
  B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash
  C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement
  D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR
  B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash
  D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR

• Question 144:

  Which two statements aboutthe SQL Management Base (SMB) are true? (Choose two.)

  A. It contains only SQL profiles generated by SQL Tuning Advisor
  B. It stores plans generated by the optimizer using a stored outline
  C. It is part of the data dictionary and stored in the SYSAUX tablespace
  D. It is part of the data dictionary and stored in the SYSTEM tablespace
  E. It contains the statement log, the plan history, plan baselines and SQL profiles
  C. It is part of the data dictionary and stored in the SYSAUX tablespace
  E. It contains the statement log, the plan history, plan baselines and SQL profiles

• Question 145:

  You are managing an Oracle Database 11ginstance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup. You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of these methods would you use to achieve this? (Choose all that apply.)

  A. Restore metadata in an existing disk group by passing the existing disk name as an input parameter
  B. Restore the disk group with changed disk group specification, failure group specification, disk group name and other disk attributes
  C. Restore the disk group with the exact configuration as the backed-up disk group, using the same group name, same set of disks and failure group configurations
  D. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations and data on the disk group
  A. Restore metadata in an existing disk group by passing the existing disk name as an input parameter
  C. Restore the disk group with the exact configuration as the backed-up disk group, using the same group name, same set of disks and failure group configurations

• Question 146:

  See the Exhibit:

  

  To examine the error obtained during the I/O calibration process.

  There are no data files on raw devices. What is the reason for this error?

  A. The DISK_ASYNCH_IO parameter is set to TRUE
  B. The FILESYSTEMIO_OPTIONS parameter is set to NONE
  C. Another session runs the I/O calibration process concurrently
  D. The pending area has not been created before running the I/O calibration process
  B. The FILESYSTEMIO_OPTIONS parameter is set to NONE

• Question 147:

  You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?

  A. The tuned plan is not added to the SQL plan baseline
  B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan
  C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan
  D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan
  C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan

• Question 148:

  While deploying a newapplication module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

  A. The plan baselines can be evolved over time to produce better performance
  B. The newly generated plans are directly placed into the SQL plan baseline without being verified
  C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration
  D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported
  A. The plan baselines can be evolved over time to produce better performance
  C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration

• Question 149:

  Identify two situations in whichyou can use Data Recovery Advisor for recovery. (Choose two.)

  A. The database files are corrupted when the database is open
  B. The archived log files are missing for which backup is not available
  C. The user has dropped an important table that needs to be recovered
  D. You are not able to start up the database instance because the required database files are missing
  A. The database files are corrupted when the database is open
  D. You are not able to start up the database instance because the required database files are missing

• Question 150:

  Which three statements are true regardingpersistent lightweight jobs? (Choose three.)

  A. The user cannot set privileges on persistent lightweight jobs
  B. The use of a template is mandatory to create persistent lightweight jobs
  C. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo
  D. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
  E. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently
  A. The user cannot set privileges on persistent lightweight jobs
  B. The use of a template is mandatory to create persistent lightweight jobs
  D. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time