Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 111:

  Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

  A. Flashback query
  B. Distributed transactions
  C. Logging in and logging out of sessions
  D. All DDL statements having bind variables
  E. Direct path load of data from external files
  C. Logging in and logging out of sessions
  D. All DDL statements having bind variables

• Question 112:

  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 113:

  Which two are the uses of theASM metadata backup and restore (AMBR) feature? (Choose two.)

  A. It can be used to backup all data on ASM disks
  B. It can be used to re-create the ASM disk group with its attributes
  C. It can be used to recover the damaged ASM disk group along with the data
  D. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates and alias directory structure
  B. It can be used to re-create the ASM disk group with its attributes
  D. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates and alias directory structure

• Question 114:

  Which two statements are true with respectto the maintenance window? (Choose two.)

  A. A DBA can enable or disable an individual task in all maintenance windows
  B. A DBA cannot change the duration of the maintenance window after it is created
  C. In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours
  D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window
  A. A DBA can enable or disable an individual task in all maintenance windows
  D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window

• Question 115:

  Which statements are true regarding thesystem-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

  A. It does not allow you to change the moving window size
  B. Adaptive threshold functionalities use it by default to compute statistics
  C. It is created by default with the window size being equal to the AWR retention time
  D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR)
  B. Adaptive threshold functionalities use it by default to compute statistics
  C. It is created by default with the window size being equal to the AWR retention time

• Question 116:

  See the Exhibit:

  

  As shown in exhibit examine the Data Pump architecture:

  Identify the numbered components:

  A. 1 - Oracle Loader, 2 ?Oracle Data Pump, 3 ?Direct Path API
  B. 1 - Oracle Data Pump, 2 ?Direct Path API, 3 ?Oracle Loader
  C. 1 - Direct Path API, 2 ?Oracle Loader, 3 ?Oracle Data Pump
  D. 1 - Oracle Loader, 2 ?Direct Path API, 3 ?Oracle Data Pump
  A. 1 - Oracle Loader, 2 ?Oracle Data Pump, 3 ?Direct Path API

• Question 117:

  Which two initialization parameterswould you set to enable Automatic Shared Memory Management? (Choose two.)

  A. SET SHARED_POOL_SIZE to zero
  B. Set STATISTICS_LEVEL to BASIC
  C. SET SGA_TARGET to a non-zero value
  D. Set DB_CACHE_SIZE to a non-zero value
  E. Set STATISTICS_LEVEL to TYPICAL or ALL
  C. SET SGA_TARGET to a non-zero value
  E. Set STATISTICS_LEVEL to TYPICAL or ALL

• Question 118:

  Which statements are true regarding thesystem-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

  A. It does not allow you to change the moving window size
  B. Adaptive threshold functionalities use it by default to compute statistics
  C. It is created by default with the window size being equal to the AWR retention time
  D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR)
  B. Adaptive threshold functionalities use it by default to compute statistics
  C. It is created by default with the window size being equal to the AWR retention time

• Question 119:

  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 120:

  In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file.

  You issued the following command:

  SQL> SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt) from sales group by sale_category;

  Where would the result of this query be stored?

  A. PGA
  B. Large Pool
  C. Shared Pool
  D. Database buffer cache
  C. Shared Pool