Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 91:

  Which two kinds of failures makethe Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

  A. Failures because a data file is renamed by error
  B. Failures when no standby database is configured
  C. Failures that require no archive logs to be applied for recovery
  D. Failures due to loss of connectivity-for example, an unplugged disk cable
  A. Failures because a data file is renamed by error
  D. Failures due to loss of connectivity-for example, an unplugged disk cable

• Question 92:

  Which statements is true regardingthe VALIDATE DATABASE command executed in RMAN session?

  A. It checks the database for intrablock corruptions only
  B. It checks for block corruption in the valid backups of the database
  C. It checks the database for both intrablock and interblock corruputions
  D. It checks for only those corrupted blocks that are associated with data files
  A. It checks the database for intrablock corruptions only

• Question 93:

  You are managing an Oracle database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:

  RMAN>BACKUP SECTION SIZE 300M TABLESPACE users;

  What configuration should be effected to accomplish faster and optimized backups by using the above command?

  A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB
  B. The SBT channels must be configured, with the parallelism setting for the SBT device set to 3
  C. The COMPATIBLE intialization parameterfor the database instance must be set to at least 10.0
  D. The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1
  B. The SBT channels must be configured, with the parallelism setting for the SBT device set to 3

• Question 94:

  You enabled Flashback DataArchive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?

  A. Drop the table
  B. Partition the table
  C. Truncate the table
  D. Add a column to the table
  E. Rename a column in the table
  D. Add a column to the table

• Question 95:

  Identify the activities performedas part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)

  A. Generating the SQL profile
  B. Testing and accepting the SQL profile
  C. Generating a list of candidate SQLs for tuning
  D. Adding tuned SQL plans into the SQL plan baseline
  E. Tuning each SQL statement in the order of importance
  F. Generating baselines that include candidate SQL statement for tuning
  A. Generating the SQL profile
  B. Testing and accepting the SQL profile
  C. Generating a list of candidate SQLs for tuning
  E. Tuning each SQL statement in the order of importance

• Question 96:

  You are working on a CATDB database that contains an Oracle Database Version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user

  RCAT10.

  You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10 into the recovery catalog owned by RCO11. You executed the following RMAN commands:

  RMAN> CONNECT CATALOG rco11/password@catdb

  RMAN>IMPORT CATALOG rcat10/oracle@inst1;

  What happens when you execute the above commands? (Choose all that apply.)

  A. They deregister all databases registered in the RCAT10 catalog
  B. They import metadata for all registered databases in the RCAT10 database
  C. They register all the RCAT10 catalog registered databases in the RCO11 catalog
  D. They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog
  A. They deregister all databases registered in the RCAT10 catalog
  B. They import metadata for all registered databases in the RCAT10 database
  C. They register all the RCAT10 catalog registered databases in the RCO11 catalog

• Question 97:

  USER_DATA is anonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

  A. Use Data Pump to transfer the existing data to a new encrypted tablespace
  B. User ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace
  C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace
  D. Enable row movement for each table to be encrypted and then use ALTER TABLESAPCE to encrypt the tablespace
  E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
  A. Use Data Pump to transfer the existing data to a new encrypted tablespace
  B. User ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace
  C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace

• Question 98:

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

  Which three are the validstatements in relation to SQL plan baselines? (Choose three.)

  A. The plans can be manually loaded to the SQL plan baseline
  B. The plans in the SQL plan baseline are verified and accepted plans
  C. The plans generated for every SQL statement are stored in the SQL plan baseline by default
  D. The plan baselines are stored temporarily in the memory as long as the database instance is running
  E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online
  A. The plans can be manually loaded to the SQL plan baseline
  B. The plans in the SQL plan baseline are verified and accepted plans
  E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online

• Question 100:

  You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are in this scenario for the features enabled for ASM? (Choose two.)

  A. The ASM-preferred mirror read feature is enabled
  B. The ASM supports variable size of extents of 1,8 and 64 allocation units
  C. The ASM disk is dropped immediately from a disk group when it becomes unavailable
  D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group
  A. The ASM-preferred mirror read feature is enabled
  B. The ASM supports variable size of extents of 1,8 and 64 allocation units