Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 1:

  Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:

  ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;

  What would be the outcome of this command?

  A. It produces an error because data already exists in the table
  B. It produces an error because compression can be enabled at table creation only
  C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately
  D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data
  C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately

• Question 2:

  See the exhibit to examine the parameters set for your database instance:

  

  You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:

  

  Which statement describes the consequence?

  A. The command produces an error
  B. The calibration process runs successfully and populates all the bind variables
  C. The calibration process runs successfully but the latency time is not computed
  D. The calibration process runs successfully but only the latency time is computed
  A. The command produces an error

• Question 3:

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

  Examine the following PL/SQL block: Which statement describes the effect of the execution of the above PL/SQL block?

  

  A. The plan baseline are verified with the SQL profiles
  B. All fixed plan baselines are converted into nonfixed plan baselines
  C. All the nonaccepted SQL profiles are accepted into the plan baseline
  D. The nonacccepted plans in the SQL Management Base are verified with the existing plan baselines
  D. The nonacccepted plans in the SQL Management Base are verified with the existing plan baselines

• Question 5:

  You have three production databases, HRDB, FINDB and ORGDB that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance.

  SQL> shutdown immediate;

  What is the result of executing this command?

  A. The ASM instance is shut down, but the other instances are still running
  B. It results in an error because other database instances are connected to it
  C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode
  D. HRDB, FINDB and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode
  B. It results in an error because other database instances are connected to it

• Question 6:

  What are the advantages of variableextent size support for large ASM files? (Choose two.)

  A. It improves performance in the extended cluster configuration by reading from a local copy of an extent
  B. It improves resync operations when the disk comes online after being taken offline for memory that is required to store file extents
  C. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents
  D. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool
  C. This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents
  D. Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool

• Question 7:

  While performing the backup of theflash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?

  A. The backup succeeds but it would be without the missing archived log
  B. The backup fails because one of the archived redo log files is missing
  C. The backup succeeds because it fails over to one of the alternative archived redo log destinations
  D. During backup, you are prompted for the alternative destination for the missing archived redo log file
  C. The backup succeeds because it fails over to one of the alternative archived redo log destinations

• Question 8:

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

  See the exhibit:

  

  You start a session and issue the following command:

  SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;

  What is the outcome of the above command?

  A. The index is not used by the optimizer but is maintained during DML operations
  B. The index is not used by the optimizer and is not maintained during DML operations
  C. The index is used by the optimizer only if a hint specified in the query statement and is maintained during DML operations
  D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations
  A. The index is not used by the optimizer but is maintained during DML operations

• Question 10:

  You set to the following parameters in the parameter file and restarted the test database: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M

  Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.)

  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
  B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually
  C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero
  D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TRAGET parameters are set to 90MB and 270 MB respectively
  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
  D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TRAGET parameters are set to 90MB and 270 MB respectively