PassGuide oracle 1z0-053 demo

Oracle Certification Program
Oracle Database 11g: Administration II
Printer View
Exam Number: 1Z0-053
Associated Certifications: Oracle Database 11g Administrator Certified Professional
Exam Price: $125 US
Exam Registration: Register

Duration: 105 minutes
Number of Questions: 80
Passing Score: 66%
Beta exam score reports have been posted and mailed.
Passing score subject to change. View Details

Recommended Training and Preparation Additional Information & Resources Exam Topics Fraudulent Activity Policy

Recommended Training and Preparation
Oracle Database 11g: Administration Workshop II

The exam has been validated only against Oracle Database 11g Release 1. When the exam has been validated against Oracle Database 11g: Release 2, this page will be updated to reflect that information.

Additional Information & Resources
oracle Practice Exams
Oracle authorized practice exam from Self Test Software: 1Z0-053 Oracle Database 11g: Administration II
Oracle authorized practice exam from Transcender: Cert-1Z0-053 DBCert: Oracle Database 11g: Administration II

1. Which of the following advisors within the Oracle advisory framework will analyze a single SQL
statement and make recommendations for performance improvement?
A: SQL Repair Advisor
B: SQL Optimizer
C: SQL Access Advisor
D: SQL Tuning Advisor

Answer:D

Explanation: Answer option D is correct.
The SQL Tuning Advisor takes one or more SQL statements and performs an analysis to determine what can be done to improve the performance of the SQL statement(s). Recommendations include rewriting the SQL statement, adding indexes, or even changing initialization parameters or
memory component sizes such as the SGA size or buffer cache.
The SQL Tuning Advisor is accessed via tools such as Top SQL, the Automatic SQL Tuning Advisor,
or the Top Sessions interface from within EM.
In contrast, the SQL Access Advisor takes a broader view of SQL tuning. It considers a larger
subset of SQL statements, such as all SQL statements run within a specified time period or from a SQL Tuning Set (STS). The SQL Access advisor may recommend additional indexes as well as materialized views to improve performance.

The SQL Repair Advisor analyzes a SQL statement that causes a critical error and records the results in the Automatic Diagnostic Repository (ADR). It may recommend a patch to fix the problem, or may provide an alternate execution plan to avoid causing an error in the future.

Other advisors within the advisory framework include memory advisors that monitor usage of the SGA and PGA and recommend optimal settings for these memory structures including the sub- structures within them, such as the library cache and the large pool.

Answer option A is incorrect. The SQL Repair Advisor only makes recommendations for SQL
statements that cause a critical error in the ADR.

Answer option B is incorrect. There is no such advisor such as the SQL Optimizer, although the
Oracle optimizer uses statistics to determine the best execution plan.

Answer option C is incorrect. The SQL Access Advisor analyzes groups of SQL statements that run during the same time period, not one or two SQL statements in isolation as the SQL Tuning
Advisor does.

Chapter 12: Database Maintenance
Oracle Database Performance Tuning Guide 11g Release 1 (11.1) Part Number B28274-02

http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE

2. Brenda works as a Database Administrator for uCertify Inc. The company uses an Oracle
database. Brenda wants to specify a number of locations to which the redo logs should be archived before an error occurs. Which of the following initialization parameters will she use to accomplish this?
A: LOG_ARCHIVE_DEST_STATE_n
B: LOG_ARCHIVE_DEST_n
C: LOG_ARCHIVE_DUPLEX_DEST
D: LOG_ARCHIVE_MIN_SUCCEED_DEST

Answer:D

Explanation: Answer option D is correct.
The LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter is used along with the
LOG_ARCHIVE_DUPLEX_DEST and LOG_ARCHIVE_DEST_n parameters. This parameter specifies the number of archive destinations to which the redo logs must be written before an error occurs.
Answer option A is incorrect. The LOG_ARCHIVE_DEST_STATE_n parameter specifies whether or not the archive destination accepts writing of redo logs. This parameter takes on three values,
ENABLE, DEFER, and ALTERNATE. The value ENABLE indicates that redo logs can be written to the archive destination. The value DEFER indicates that the archive destination is temporarily
disabled. The value ALTERNATE indicates that the archive destination is an alternative that can accept writing of redo logs to the archive destination only when its parent destination fails. This parameter is used along with the LOG_ARCHIVE_DEST_n parameter.
Answer option C is incorrect. The LOG_ARCHIVE_DUPLEX_DEST parameter specifies that the redo logs be written to both the archive destinations.
Answer option B is incorrect. The LOG_ARCHIVE_DEST_n parameter specifies multiple archive destinations.

Donwload Free PassGuide Braindumps-The Most Realistic Practice Questions and Answers,Help You Pass any Exams

Reference: Oracle 9i Online Documentation, Contents: “Managing Archived Redo Logs: Specifying the Minimum Number of Successful Destinations”

3. Which of the following statements about conventional tablespaces (non-locally managed
tablespaces) are true?
Each correct answer represents a part of the solution. Choose two
A: Conventional tablespaces use data dictionary tables for storage space management.
B: Conventional tablespaces use bitmaps for storage space management.
C: In case of conventional tablespaces, Oracle reflects the allocation of a new extent by updating th associated segment header and the data dictionary table.
D: In case of conventional tablespaces, Oracle reflects the allocation of a new extent by updating th associated segment header and the bitmap.

Answer:AC

Explanation: Answer options A and C are correct.
In case of conventional tablespaces (the approach of Oracle7i and below), Oracle uses data dictionary tables to manage storage space. When a new extent is allocated to a segment under a conventional tablespace, its allocation is reflected by updating the corresponding segment header and the associated data dictionary tables.
Answer options B and D are incorrect. In case of a locally managed tablespace, Oracle uses a bitmap for managing the storage space.
4. Which of the following determines the location of the Automatic Diagnostic Repository (ADR)?
A: ADR_BASE directory
B: DIAGNOSTIC_DEST instance parameter
C: Flashback Recovery Area
D: ADR_BASE environment variable

Answer:B

Explanation: Answer option B is correct.

Automatic Diagnostic Repository (ADR) is a special central storage point for all diagnostic reports.
It is automatically maintained into memory by Oracle 11g. It enables database components to capture diagnostic data at its first failure for critical errors. It is a file base storage point. All instances such as RDBMS and ASM instances maintain a separate directory structures within ADR.
The DIAGNOSTIC_DEST instance parameter determines the location of the Automatic Diagnostic
Repository (ADR).
Answer options C, A, and D are incorrect. Flash Recovery Area is used to store backup and recovery data, and not problem diagnosis data. ADR_BASE is neither a directory nor an environment variable

5. Which of the following statements about a recovery catalog are true?
Each correct answer represents a complete solution. Choose two.
A: A recovery catalog should not be created in the target database.
B: The information in the recovery catalog is obtained from the target database’s control file.
C: In case of multiple target databases, a recovery catalog schema must be created for each target database.
D: Recovery Manager (RMAN) must have a recovery catalog for its normal functioning.

Answer:AB

Explanation: Answer options A and B are correct.
A recovery catalog is a set of tables and views that Recovery Manager (RMAN) uses to store metadata (information about a database structure, archived redo logs, backup sets, and data file copies) about a target database (database that RMAN backups or restores). RMAN uses this metadata to conduct its backup, recovery, and maintenance operations. Recovery catalog is optional, i.e., if a recovery catalog is not created, RMAN uses the target database’s control file to store the metadata about the target database. Although RMAN can conduct all major backup and recovery operations by using the control file, some RMAN commands work only if a recovery catalog exists.

A recovery catalog is solely managed by RMAN. RMAN propagates information about the database structure, archived redo logs, backup sets, and data file copies into the recovery catalog from the target database’s control file.

A recovery catalog can be used to store metadata about multiple target databases. The tables and views constituting a recovery catalog are owned by a recovery catalog schema. Oracle
recommends creating a recovery catalog schema in a separate dedicated database and not in the target database. A database containing a recovery catalog schema is called a recovery catalog database.

Answer option C is incorrect. A single recovery catalog schema can store metadata about any number of target databases.

6. Which of the following Dynamic Performance views contain information relevant to SQL Tuning?
Each correct answer represents a part of the solution. Choose all that apply.
A: V$SQLSTATS
B: V$SQLAREA
C: V$SQL_BIND_DATA
D: V$SQL

Answer:DBA

PassGuide Cisco Exams Questions & Training Materials

  1. Free Oracle Database 11g New Features
  2. Free 1z0-053
  3. Free Oracle study materails
  4. Free 1Z0-042 Oracle Database 10g DBA OCA : Oracle Database 10g: Administration I
  5. Free Oracle 10g.part1 To 5
  6. Free passguide-oracle-8i DBA-exams
  7. Free passguide-oracle-8i DBA-exams
  8. Free OCP Oracle Database 11g: New Features for Administrators Exam Guide (Exam 1Z0-050 (Osborne Oracle Press)
  9. Free Oracle 1z0-311 Exam Demo
  10. Free preplogic oracle 1z0-042
  11. Free Oracle Populer Dumps + Oracle Books
  12. Free passguide-oracle-9i DBA-exams

About the Author

PassGuide Free Certification Exam Download has written 6442 stories on this site.

If you have any doubts about legality of content or you have another suspicions, feel free to contact us:CertGuard@Gmail.com

Write a Comment

Gravatars are small images that can show your personality. You can get your gravatar for free today!

You must be logged in to post a comment.

Copyright © 2017 CertBible – IT certifications Exams,Study Guide,Practice Test,Training Materials.. PassGuide,Testinside,Pass4side,Certifyme,Transcender,Examworx,Topcerts,Actualtests. microsoft Comptia MCSE Oracle hp ibm citrix Sitemap