Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 391:

  Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?

  A. AWR baselines are always created as repeating baselines.

  B. AWR baselines can be created on the basis of two time values.

  C. AWR baselines are always created with infinite expiration duration.

  D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

  Correct Answer: B

• Question 392:

  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.

  Correct Answer: D

• Question 393:

  View the Exhibit to examine the metrics with a threshold.

  Which statement is true regarding the Number of Transactions (per second) metric?

  Exhibit:

  

  A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.

  B. The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.

  C. Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.

  D. The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.

  Correct Answer: A

• Question 394:

  Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

  A. ADR diagnostic files

  B. all the optimizer statistics

  C. initialization parameter settings

  D. PL/SQL functions, procedures, and packages

  E. the table and index definitions and actual data

  Correct Answer: BCD

  The information gathered by SQL Test Case Builder includes:

  the query being executed,

  table and index definitions (but not the actual data), PL/SQL functions, procedures, and packages,

  optimizer statistics,

  and initialization parameter settings.

• Question 395:

  You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.

  The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals: SQL> EXECUTE

  DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');

  You need statistics to be collected more quickly.

  What can you do to achieve this?

  A. Set DYNAMIC_SAMPLING to level 4.

  B. Set the STATISTICS_LEVEL parameter to BASIC.

  C. Set the INCREMENTAL value to TRUE for the partition table.

  D. Increase the value of STALE_PERCENT for the partition table.

  Correct Answer: C

  Oracle will update the global table statistics by scanning only the partitions that have been changed ead of the entire table if the following conditions hold:

  INCREMENTAL value for the partitioned table is set to TRUE PUBLISH value for the partitioned table is set to TRUE; User specifies AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT and AUTO for GRANULARITY when gathering statistics on the table If the INCREMENTAL value for the partitioned table was set to FALSE (default value), a full table scan is used to maintain the global statistics which is a much more resource intensive and time-consuming operation for large tables.

• Question 396:

  Examine the section of the Health Check report given below:

  DBMS_HM.GET_RUN_REPORT('HM_RUN_1061') Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode : REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time : 2007-05-12 22:11:20.835135 -07:00 Error Encountered : 0 Source Incident Id : 7418 Number of Incidents Created :0

  Which two statements are true regarding the Health Check report? (Choose two.)

  A. Health Check was performed manually.

  B. Health Check was performed to check the disk image block corruptions.

  C. Health Check was performed to check interblock and intersegment corruption.

  D. Health Check was performed to verify the integrity of database files and report failures.

  E. Health Check was performed by the Health Monitor automatically in response to a critical error.

  Correct Answer: AB

  About Health Monitor Checks

  Health Monitor checks (also known as checkers, health checks, or checks) examine various layers and components of the database. Health checks detect file corruptions, physical and logical block corruptions, undo and redo corruptions,

  data dictionary corruptions, and more. The health checks generate reports of their findings and, in many cases, recommendations for resolving problems. Health checks can be run in two ways:

  Reactive--The fault diagnosability infrastructure can run health checks automatically in response to a critical error.

  Manual--As a DBA, you can manually run health checks using either the DBMS_HM PL/SQL package or the Enterprise Manager interface. You can run checkers on a regular basis if desired, or Oracle Support may ask you to run a checker

  while working with you on a service request.

  Health Monitor checks store findings, recommendations, and other information in the Automatic Diagnostic Repository (ADR).

  Health checks can run in two modes:

  DB-online mode means the check can be run while the database is open (that is, in OPEN mode or MOUNT mode).

  DB-offline mode means the check can be run when the instance is available but the database itself is closed (that is, in NOMOUNT mode).

  All the health checks can be run in DB-online mode. Only the Redo Integrity Check and the DB Structure Integrity Check can be used in DB-offline mode.

  Types of Health Checks:

  Health monitor runs the following checks:

  DB Structure Integrity Check--This check verifies the integrity of database files and reports failures if these files are inaccessible, corrupt or inconsistent. If the database is in mount or open mode, this check examines the log files and data files

  listed in the control file. If the database is in NOMOUNT mode, only the control file is checked.

  Data Block Integrity Check--This check detects disk image block corruptions such as checksum failures, head/tail mismatch, and logical inconsistencies within the block. Most corruptions can be repaired using Block Media Recovery.

  Corrupted block information is also captured in the V$DATABASE_BLOCK_CORRUPTION view. This check does not detect inter- block or inter-segment corruption.

  Redo Integrity Check--This check scans the contents of the redo log for accessibility and corruption, as well as the archive logs, if available. The Redo Integrity Check reports failures such as archive log or redo corruption. Undo Segment

  Integrity Check--This check finds logical undo corruptions. After locating an undo corruption, this check uses PMON and SMON to try to recover the corrupted transaction. If this recovery fails, then Health Monitor stores information about the

  corruption in V$CORRUPT_XID_LIST.

  Most undo corruptions can be resolved by forcing a commit.

  Transaction Integrity Check--This check is identical to the Undo Segment Integrity Check except that it checks only one specific transaction. Dictionary Integrity Check--This check examines the integrity of core dictionary objects, such as tab$

  and col$. It performs the following operations:

  Verifies the contents of dictionary entries for each dictionary object. Performs a cross- row level check, which verifies that logical constraints on rows in the dictionary are enforced.

  Performs an object relationship check, which verifies that parent-child relationships between dictionary objects are enforced.

  The Dictionary Integrity Check operates on the following dictionary objects:

  tab$, clu$, fet$, uet$, seg$, undo$, ts$, file$, obj$, ind$, icol$, col$, user$, con$, cdef$, ccol$, bootstrap$, objauth$, ugroup$, tsq$, syn$, view$, typed_view$, superobj$, seq$, lob$, coltype$, subcoltype$, ntab$, refcon$, opqtype$, dependency$, access$, viewcon$, icoldep$, dual$, sysauth$, objpriv$, defrole$, and ecol$.

• Question 397:

  View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:

  SQL> startup

  ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

  Why did the instance fail to start?

  Exhibit:

  

  A. Because the PGA_AGGREGATE_TARGET parameter is not set

  B. Because the STATISTICS_LEVEL parameter is set to BASIC

  C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal

  D. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.

  Correct Answer: B

  Setting SGA Target Size

  You enable the automatic shared memory management feature by setting the SGA_TARGET parameter to a nonzero value. This parameter sets the total size of the SGA. It replaces the parameters that control the memory allocated for a

  specific set of individual components, which are now automatically and dynamically resized (tuned) as needed.

  Note:

  The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function.

• Question 398:

  Note the following parameter settings: Which setting is NOT allowed?

  

  A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;

  B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;

  C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;

  D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;

  Correct Answer: B

• Question 399:

  You want to enable automatic PGA memory management in your database.

  Which setting is required to achieve this?

  A. Set MEMORY_TARGET to zero

  B. Set the STATISTICS_LEVEL parameter to BASIC

  C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL

  D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

  Correct Answer: D

• Question 400:

  Examine the parameter setting in your database: Which statement is correct about the database?

  

  A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set

  B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set

  C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set

  D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup

  Correct Answer: D