Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 61:

  You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)

  A. The KEEP option overrides the configured retention policy
  B. The KEEP option is an attribute of an individual backup piece
  C. The backup contains only data files and archived redo log files
  D. The backup contains data files, the server parameter file and control file even if the control file autobackup is disabled
  A. The KEEP option overrides the configured retention policy
  D. The backup contains data files, the server parameter file and control file even if the control file autobackup is disabled

• Question 62:

  View the following SQL Statements: You want to back out transaction T2. Which option would you use?

  

  A. It is possible, but transaction T3 also backs out
  B. It is possible with the NOCASCADE_FORCE option
  C. It is possible with the NONCONFLICT_ONLY option
  D. It is not possible because it has conflicts with transaction T3
  B. It is possible with the NOCASCADE_FORCE option

• Question 63:

  Which setting enables the baselines by defaultin Oracle Database 11g?

  A. Setting the STATISTICS_LEVEL parameter to TYPICAL
  B. Adding filters to the Automatic Database Diagnostic Monitor (ADDM)
  C. Enabling Automated Maintenance Task using Oracle Enterprise Manager
  D. Setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
  A. Setting the STATISTICS_LEVEL parameter to TYPICAL

• Question 64:

  You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)

  A. ASM compatibility controls which features for the ASM will be enabled
  B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group
  C. The RDBMS compatibility settings for a disk group control the format of data structures of ASM metadata on the disk
  D. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances
  A. ASM compatibility controls which features for the ASM will be enabled
  B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group
  D. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances

• Question 65:

  The application tables ownedby the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?

  A. owner
  B. touser
  C. attach
  D. remap_schema
  D. remap_schema

• Question 66:

  Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

  A. Cursor cache
  B. Stored outline
  C. SQL Tuning Set
  D. Automatic Workload Repository (AWR) snapshots
  A. Cursor cache
  C. SQL Tuning Set

• Question 67:

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

  Which three statements are true regarding the function of the AutotaskBackground Process (ABP)? (Choose three.)

  A. It translates tasks into jobs for execution by the scheduler
  B. It creates jobs without considering the priorities associated with them
  C. It determines the list of jobs that must be created for each maintenance window
  D. It is spawned by the MMON background process at the start of the maintenance window
  E. It maintenance a repository in the SYSTEM tablespace to store the history of the execution of all tasks
  A. It translates tasks into jobs for execution by the scheduler
  C. It determines the list of jobs that must be created for each maintenance window
  D. It is spawned by the MMON background process at the start of the maintenance window

• Question 69:

  In you database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL

  and the password file have been configured.

  A user SCOTT with the SYSDBA privilege tried to connect to the database instance from a remote machine using the command:

  $ SQLPLUS scott/tiger@DB01 AS SYSDBA

  Where DB01 is the net service name.

  Which authentication method would be used first?

  A. Authentication by password file
  B. Authentication by using certificates over SSL
  C. Authentications by using the Oracle Internet Directory
  D. Authentication by using the local OS of the database server
  A. Authentication by password file

• Question 70:

  Which two are the prerequisitesto enable Flashback Data Archive? (Choose two.)

  A. Undo retention guarantee must be enabled
  B. Database must be running in archivelog mode
  C. Automatic undo management must be enabled
  D. The tablespace on which file Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM)
  C. Automatic undo management must be enabled
  D. The tablespace on which file Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM)