Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 21:

  You want to convert you existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

  A. Data Pump Export and Import
  B. Conventional export and import
  C. The COVERT command of RMAN
  D. The BACKUP AS COPY..... command of RMAN
  D. The BACKUP AS COPY..... command of RMAN

• Question 22:

  See the Exhibit: Which statement is true regarding the status of the incident?

  

  A. The DBA is working on the incident and prefers that the incident be kept in the ADR
  B. The incident is now in the does state and the ADR can select the incident to be purged
  C. The incident has been newly created and is in the process of collecting diagnostic information
  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support
  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support

• Question 23:

  When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)

  A. It produces less accurate results of the comparison analysis
  B. It automatically calls the SQL Tuning Advisor for recommendations
  C. It shortens the time of execution and reduces the impact on system resources
  D. Only the changes in the execution plan and not performance regression, are detected
  A. It produces less accurate results of the comparison analysis
  C. It shortens the time of execution and reduces the impact on system resources

• Question 24:

  What two statements are trueregarding the recommendations received from the SQL Access Advisor? (Choose two.)

  A. It can recommend partitioning only on tables that have at least 10,000 rows
  B. It cannot generate recommendations that support multiple workload queries
  C. It can recommend only B-tree indexes and not bitmap or function-based indexes
  D. It can recommend partitioning on table provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type
  A. It can recommend partitioning only on tables that have at least 10,000 rows
  D. It can recommend partitioning on table provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type

• Question 25:

  You are using Recovery Manager(RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)

  A. You are backing up to tape and your tape device performs its own compression
  B. You are making image copies and you have not enabled tablespace compression
  C. You are using disk-based backups and disk space in you Flash Recovery Area or other disk-based backup destinations are limited
  D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage
  E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage
  C. You are using disk-based backups and disk space in you Flash Recovery Area or other disk-based backup destinations are limited
  D. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage
  E. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage

• Question 26:

  See the Exhibit:

  

  What is the implication for setting the values for replay parameters? (Choose all that apply.)

  A. The COMMIT order in the captured workload is preserved during replay
  B. The value 100 in the THIN_TIME_SCALE parameter attempts to make replay client shorten the think time between calls
  C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured
  D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying
  E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins
  A. The COMMIT order in the captured workload is preserved during replay
  C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured
  D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying

• Question 27:

  Evaluate the following code:

  SQL>VARIABLE task_name VARCHAR2(255)'

  SQL>VARIABLE sql_stmt VARCHAR2(4000);

  SQL>BEGIN

  : sql_stmt:= `SELECT COUNT (*) FROM customers WHERE cust_state_province ="CA";

  :task_name := `MY_QUICKTUNE_TASK';

  DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR, :task_name,:sql_stmt);

  END;

  What is the outcome of this block of code?

  A. It creates a task and workload and executes the task
  B. It creates a task and workload but does not execute the task
  C. It produces an error because a template has not been created
  D. It produces an error because the SQL Tuning Set has not been created
  A. It creates a task and workload and executes the task

• Question 28:

  You are managing an Oracle Database 11g database with the ASMstorage. The database is having big file tablespace. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.)

  A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0
  B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0
  C. Set the COMPATIBLE initlization parameter for the ASM instance to 11.1.0
  D. Set the COMPATIBLE initialization parameter for the database instance 11.1.0
  A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0
  D. Set the COMPATIBLE initialization parameter for the database instance 11.1.0

• Question 29:

  Examine the following PL/SQL blocks:

  

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

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

• Question 30:

  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