Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 191:

  The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.

  Which statement is true in this scenario?

  A. The statistics collection continues until all objects are processed.

  B. The job is terminated and the statistics collected are restored to a time before the job started.

  C. This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.

  D. The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.

  Correct Answer: D

• Question 192:

  The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

  A. Inactive and current redo log files are required to accomplish recovery

  B. Online and archived redo files are required to accomplish instance recovery

  C. All redo log entries after the last checkpoint are applied from redo log files to data files

  D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

  Correct Answer: C

• Question 193:

  Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)

  A. An SPFILE is a binary file

  B. An SPFILE cannot reside on a client

  C. An SPFILE cannot contain static parameters

  D. An SPFILE can store changes persistently across instance restarts

  E. An SPFILE can be read by the database server, but it is not written to by the server

  F. An SPFILE must be created manually, before creating a database, even if you use the Database Configuration Assistant (DBCA) to create the database

  Correct Answer: ABD

• Question 194:

  Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.

  What would you do to recover the data file?

  A. Take the USERS tablespace offline and re-create the lost data file

  B. Shutdown the instance, restore the data file from the last consistent backup and restart the database instance

  C. Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance

  D. Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup and make the tablespace online

  Correct Answer: C

• Question 195:

  Examine the command: SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false'); Which statement describes the effect of the above command?

  A. Automatic statistics collection is stopped for the CUSTOMERS table

  B. Statistics for the CUSTOMERS table are locked and cannot be overwritten

  C. Existing statistics for the CUSTOMERS table become unusable for the query optimizer

  D. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

  Correct Answer: D

• Question 196:

  In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.

  What is the impact of this setting?

  A. Optimizer statistics are collected automatically.

  B. Only timed operating system (OS) statistics and plan execution statistics are collected.

  C. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.

  D. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.

  E. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

  Correct Answer: C

• Question 197:

  You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value.

  Which action would help to use the previous set of statistics on the objects?

  A. Restore statistics from statistics history.

  B. Reduce the optimizer statistics retention period by 2 days.

  C. Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.

  D. Reduce the Automatic Workload Repository (AWR) retention period by 2 days.

  Correct Answer: A

• Question 198:

  See the Exhibit:

  

  Which statements are true regarding the USERS tablespace? (Choose all that apply.)

  A. A bitmap is used to record free extents

  B. Free extents information is managed within the tablespace

  C. Free extents information is managed in the SYSAUX tablespace

  D. The data dictionary tables are updated when extents are allocated or deallocated

  Correct Answer: AB

• Question 199:

  Examine the values for the following initialization parameters:

  FAST_START_MTTR_TARGET=0

  LOG_CHECKPOINT_INTERVAL=0

  Which two will be the implications of these values in your database? (Choose two.)

  A. The SGA advisor will be disabled

  B. The MTTR advisor will be disabled

  C. Automatic checkpoint tuning will be disabled

  D. Checkpoint information will not be written to the alert log file

  Correct Answer: BC

• Question 200:

  In which of the scenario will the DBA perform recovery? (Choose all that apply.)

  A. The alert log file is corrupted

  B. A tablespace is accidentally dropped

  C. One of the redo log members is corrupted

  D. A database user terminates the session abnormally

  E. The hard disk on which the data files is stored is corrupted

  Correct Answer: BE