Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 131:

  See the Exhibit: In the CUSTOMERS_OBE table, when the value of COST_STATE_PROVINCE is "CA", the value of COUNTRY_ID is "US". See the exhibit to examine the commands and query plans. The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table. What can you do to make the optimizer detect the actual selectivity?

  

  A. Set the STATISTICS_LEVEL parameter to TYPICAL
  B. Change the STALE_PERCENT value for the CUSTOMERS_OBE table
  C. Set the OPTIMIZER_USE_PENDiNG_STATISTICS parameter to FALSE
  D. Create extended statistics for the CUST_STATE_PROVINCE and COUNTRY_ID columns
  D. Create extended statistics for the CUST_STATE_PROVINCE and COUNTRY_ID columns

• Question 132:

  You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:

  ALTER TABLE employees SHRINK SPACE CASCADE;

  Which statement is correct in this scenario?

  A. The EMPLOYEES table will be changed to read-only mode during the shrink operation
  B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over
  C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation
  D. Data manipulation language (DML) operations will not be possible on the EMPLOYYES table during the COMPACTION phase of the shrink operation
  C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation

• Question 133:

  You need to create a partitioned table to store historical data and you issued the following command:

  

  What is the outcome of the above command?

  A. It returns an error because the range partitions P1 and P2 should be of the same range
  B. It creates two range partitions (P1,P2), within each range partition, it creates month wise subpartitions
  C. It creates two range partitions of varying range. For data beyond `1-1-2007', it creates partitions with a width of one month each
  D. It returns an error because the number of tablespace (TBS1,TBS2,TBS3) specified does not match the number of range partitions (P1,P2) specified
  C. It creates two range partitions of varying range. For data beyond `1-1-2007', it creates partitions with a width of one month each

• Question 134:

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

  You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command:

  RMAN> CHANGE BACKUPSET 231 NOKEEP;

  What is the implication of this command?

  A. The backup is deleted
  B. The backup is marked unavailable
  C. The backup overrides the backup retention policy
  D. The backup becomes eligible for deletion according to the existing retention policy
  D. The backup becomes eligible for deletion according to the existing retention policy

• Question 136:

  Which two statements regardinga SQL profile are true? (Choose two.)

  A. It is built by Automatic Tuning Optimizer
  B. It cannot be stored persistently in the data dictionary
  C. It can be used by the query optimizer automatically
  D. It can be created manually by using the CREATE PROFILE command
  A. It is built by Automatic Tuning Optimizer
  C. It can be used by the query optimizer automatically

• Question 137:

  Your system has been upgradedfrom Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running

  the SQL Performance Analyzer, you observed performance regression for a few SQL statements.

  What would you do with these SQL statements?

  A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans
  B. Capture the plans from the previous version using STS and then load them into the stored outline
  C. Capture the plan from the previous version using STS and then load them into SQL Management Base (SMB)
  D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline
  C. Capture the plan from the previous version using STS and then load them into SQL Management Base (SMB)

• Question 138:

  Your company wants to upgrade the current production database to the RAC environment, To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on test machine. Note the following steps that you may require to replay the database workload:

  Preprocess the captured workload Restart the database in RESTRICTED mode Set up the Replay Clients Restore the test database to the point when the capture started Remap connections

  Arrange the steps required in the correct sequence to accomplish this task on the test machine.

  A. 2,1,5,3,4
  B. 1,2,4,5,3
  C. 1,4,5,3 (2 is not required)
  D. 1,2,4,5(3 is not required)
  E. 1,4,3,5(2 is not required)
  C. 1,4,5,3 (2 is not required)

• Question 139:

  Evaluate the following SQL statement used to create the PRODUCTS table:

  

  Which statement is true regarding this command?

  A. It executes successfully but partition pruning cannot happen for this partition key
  B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key
  C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key
  D. It executes successfully but the values in the TOTAL_VLAUE column would not be physically stored in the partitions
  D. It executes successfully but the values in the TOTAL_VLAUE column would not be physically stored in the partitions

• Question 140:

  There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?

  A. Enable Flashback Data Archive for the tables
  B. Enable supplemental logging for the database
  C. Specify undo retention guarantee for the database
  D. Create Flashback Data Archive on the tablespace on which the tables are stored
  E. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size
  A. Enable Flashback Data Archive for the tables