Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 81:

  See the series of commands to be executed:

  

  An index is then created on the ADMIN_WORK_AREA temporary table.

  Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)

  A. It stores only the temporary table but not its indexes
  B. It stores both the temporary table as well as its indexes
  C. It must be a nondefault temporary tablespace for the database
  D. It can be a default or nondefault temporary tablespace for the database
  E. It must be default temporary tablespace of the user who issues the command
  B. It stores both the temporary table as well as its indexes
  D. It can be a default or nondefault temporary tablespace for the database

• Question 82:

  Which statement about the enabling of tablecompression in Oracle Database 11g is true?

  A. Compression can be enabled at the table, tablespace or partition level for direct loads only
  B. Compression can be enabled only at the table level for both direct loads and conventional DML
  C. Compression can be enabled at the table, tablespace or partition level for conventional DML only
  D. Compression can be enabled at the table, tablespace or partition level for both direct loads and conventional DML
  D. Compression can be enabled at the table, tablespace or partition level for both direct loads and conventional DML

• Question 83:

  You plan to collect theAutomatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

  A. Create a repeating baseline template
  B. Insert a finding directive for future ADDM tasks
  C. Create and populate a SQL Tuning Set from the AWR on every Monday
  D. Change the RETENTION setting for the AWR snapshots to 7 days on Monday
  A. Create a repeating baseline template

• Question 84:

  You perform the followingactivities during the database upgrade from Oracle Database 10g to Oracle Database 11g;

  Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade Load these plans from the STS into the SQL plan baseline immediately after the upgrade

  What is the reason for performing these activities?

  A. To minimize plan regression due to the use of a new optimizer version
  B. To completely avoid the use of new plans generated by a new optimizer version
  C. To prevent plan capturing when the SQL statement is executed after the database upgrade
  D. To keep the plan in the plan history so that is can be used when the older version of the optimizer is used
  A. To minimize plan regression due to the use of a new optimizer version

• Question 85:

  See the Exhibit:

  

  You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:

  RMAN> REPAIR FAILURE;

  Which statement describes the consequence of the command?

  A. The command performs the recovery and closes the failures
  B. The command only displays the advice and the RMAN script required for repair
  C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command
  D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository(ADR)
  C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command

• Question 86:

  What is the advantage of settingthe ASM-preferred mirror read for the Stretch cluster configuration?

  A. It improves resync operations
  B. This feature enables much faster file opens
  C. It improves performance as fewer extent pointers are needed in the shared pool
  D. It improves performance by reading from a copy of an extent closet to the node
  D. It improves performance by reading from a copy of an extent closet to the node

• Question 87:

  Evaluate the following block of code: What is the outcome of the above code?

  

  A. It produces an error because a fully qualified host name needs to be specified
  B. It produces an error because the range of ports associated with the hosts has not bee specified
  C. It creates an access control lists (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges
  D. It creates an access control list (ACL) with the user ACCT_MGR who get the CONNECT privilege but not the RESOLVE privilege
  C. It creates an access control lists (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges

• Question 88:

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

  An online tablespace, TEST_TBS is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

  A. TEST_TBS is a small file tablespace
  B. TEST_TBS is a bigfile tablespace (BFT)
  C. TEST_TBS is the default temporary tablespace
  D. TEST_TBS is a dictionary-managed tablespace
  D. TEST_TBS is a dictionary-managed tablespace

• Question 90:

  The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:

  LOG_ARCHIVE_DEST_1 = `LOCATION = /disk1/archive'

  LOG_ARCHIVE_DEST_2 = `SERVICE = stdb1'

  DB-RECOVERY_FILE_DEST = `/u01/oradata'

  Examine the following RMAN command is used to set the deletion policy for archived log files:

  RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED up 2 TIMES TO sbt;

  Which statement is true regarding what this command accomplishes?

  A. All archived redo log files backed up at least twice to tape are deleted
  B. All archived redo log files backed up at least once to tape are eligible for deletion
  C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area
  D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion
  D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion