Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 71:

  See the Exhibit: Exhibit 1:

  

  Exhibit 2:

  

  The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit 1 less time than the process in exhibit2. What is the reason for this?

  A. It creates less metadata for the jobs
  B. It creates jobs temporarily in memory only
  C. It writes the job metadata to disk in compressed format
  D. It updates several tables in the SYSTEM tablespace instead of creating new tables
  A. It creates less metadata for the jobs

• Question 72:

  See the following PL/SQL block:

  DECLARE

  my_plans pls_integer,

  BEGIN

  My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sql_id=> >9twu5t2dn5xd?;

  END;

  Which statement is true about the plan being loaded into the SQL plan baseline by the above command?

  A. It is loaded with the FIXED status
  B. It is loaded with the ACCEPTED status
  C. It is not loaded with the ENABLED status
  D. It is not loaded with the ACCEPTED status
  B. It is loaded with the ACCEPTED status

• Question 73:

  In which two aspects does hotpatching differ from conventional patching? (Choose two.)

  A. It consumes more memory compared with conventional patching
  B. It can be installed and uninstalled via OPatch unlike conventional patching
  C. It takes more time to install or uninstall compared with convetinal patching
  D. It does not require down time to apply or remove unlike conventional patching
  E. It is not persistent across instance startup and shutdown unlike conventional patching
  A. It consumes more memory compared with conventional patching
  D. It does not require down time to apply or remove unlike conventional patching

• Question 74:

  The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?

  A. Create two custom ADDM tasks
  B. Modify the AWR snapshot time interval to two hours
  C. Create a new scheduler window for a time period to two hours
  D. Modify the Automatic Workload Repository(AWR) snapshot retention period to two hours
  B. Modify the AWR snapshot time interval to two hours

• Question 75:

  See the exhibit:

  

  To examine the error while executing the REPARI FAILURe command in an RMAN session. What is the reason for this error?

  A. Another repair session is running concurrently
  B. The failure ID has not been mentioned in the command for data file5.
  C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).
  D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.
  A. Another repair session is running concurrently

• Question 76:

  See the following PL/SQL block:

  DECLARE

  my_plans pls_integer,

  BEGIN

  My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sql_id=> >9twu5t2dn5xd?;

  END;

  Which statement is true about the plan being loaded into the SQL plan baseline by the above command?

  A. It is loaded with the FIXED status
  B. It is loaded with the ACCEPTED status
  C. It is not loaded with the ENABLED status
  D. It is not loaded with the ACCEPTED status
  B. It is loaded with the ACCEPTED status

• Question 77:

  Examine the following values of the initialization parameters in the database having the SID ORCL:

  

  The environment variables have the following value:

  

  What is the location of the Automatic Diagnostic Repository (ADR) home?

  A. /u01/app/oracle
  B. $ORACLE_HOME/log
  C. $ORACLE_HOME/bdump
  D. /u01/app/oracle/product/11.1.0/db_1
  A. /u01/app/oracle

• Question 78:

  The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)

  A. The optimizer adds the new plan to the plan history
  B. The optimizer selects the new plan for the execution of the SQL statement
  C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan
  D. The optimizer adds the new plan to the SQL baseline but not in the ENABLED state
  E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost
  A. The optimizer adds the new plan to the plan history
  E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost

• Question 79:

  You plan to set up the automaticWorkload Repository (AWR) baseline metric threshold for moving window baseline. Which action would you take before performing this task?

  A. Compute the baseline statistics
  B. Take an immediate AWR snapshot
  C. Decrease the window size for the baseline
  D. Decrease the expiration time for the baseline
  A. Compute the baseline statistics

• Question 80:

  See the Exhibit:

  

  You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign?

  A. 90 MB
  B. 272 MB
  C. 362 MB
  D. 1440 MB
  C. 362 MB