How to Boost Score on Oracle Database 11g (1Z0-050) Certification Exam

1Z0-050 Oracle Database 11g - New Features for Administrators Exam Summary – Syllabus – Questions

1Z0-050 Sample Questions and Exam Summary ____________________________________________________________________________________

Table of Contents Introduction to 1Z0-050 Exam on Oracle Database 11g - New Features for Administrators ................................................................................................ 2 Oracle 1Z0-050 Certification Details: ............................................................ 2 Oracle 1Z0-050 Exam Syllabus: .................................................................... 3 1Z0-050 Sample Questions: ......................................................................... 4 Answers to 1Z0-050 Exam Questions: .......................................................... 6

____________________________________________________________________________________ 1Z0-050 - Oracle Database 11g - New Features for Administrators

pg. 1

1Z0-050 Sample Questions and Exam Summary ____________________________________________________________________________________

Introduction to 1Z0-050 Exam on Oracle Database 11g - New Features for Administrators You can use this exam guide to collect all the information about Oracle Database 11g New Features for Administrators (1Z0-050) certification. The Oracle 1Z0-050 certification is mainly targeted to those candidates who has some experience or exposure of Oracle Database 11g and want to flourish their career with Oracle Database 11g Administrator Certified Professional (OCP) credential. The Oracle Database 11g New Features for Administrators certification exam validates your understanding of the Oracle Database 11g technology and sets the stage for your future progression. Your preparation plan for Oracle 1Z0-050 Certification exam should include hands-on practice or on-the-job experience performing the tasks described in following Certification Exam Topics table.

Oracle 1Z0-050 Certification Details: Exam Name

Oracle Database 11g New Features for Administrators

Exam Code

1Z0-050

Exam Product Version Oracle Database 11g Exam Price

USD $245 (Pricing may vary by country or by localized currency)

Duration

105 minutes

Number of Questions

77

Passing Score

61%

Validated Against

The exam has been validated against OracleÂŽ Database 11g Release 2 version 11.2.0.1.0.

Format

Multiple Choice

Recommended Training

Oracle Database 11g: New Features for Administrators Release 2

Schedule Exam

Pearson VUE - Oracle

Recommended Practice 1Z0-050 Online Practice Exam

____________________________________________________________________________________ 1Z0-050 - Oracle Database 11g - New Features for Administrators

pg. 2

1Z0-050 Sample Questions and Exam Summary ____________________________________________________________________________________

Oracle 1Z0-050 Exam Syllabus: Installation and Upgrade Enhancements

-

Install Oracle Database 11g Upgrade your database to Oracle Database 11g Oracle Direct NFS Use online patching

Storage Enhancements

-

Setup ASM fast mirror resynch Understand scalability and performance enhancements Setup ASM disk group attributes Use various new manageability options Use the md_backup, md_restore, and ASMCMD extensions

-

Creating and using AWR baselines Setting AWR Baseline Metric Thresholds Control Automated Maintenance Tasks Using Database Resource Manager New Features Using new scheduler features ADDM Enhancements Setup Automatic Memory Management Enhancements in statistics collection

-

Implement the new partitioning methods Employ Data Compression SQL Access Advisor Overview Create SQL Access Advisor analysis session using PL/SQL

-

Managing Archive logs Duplicating a Database Back up large files in multiple sections Perform Archival Backups Manage Recovery Catalogs Create a virtual private catalog for RMAN Overview of Flashback Data Archive Manage Flashback Data Archive Back-out transactions using Flashback Transaction Working with Logminer Setup Automatic Diagnostic Repository Use Support Workbench Run health checks Use SQL Repair Advisor Overview of Workload Capture and Replay Using Workload capture and replay Overview of Data Recovery Advisor Repairing data failures using Data Recovery Advisor Perform proactive health check of the database

Intelligent Infrastructure Enhancements Performance Enhancements Partitioning and Storage-Related Enhancements

Using RMAN Enhancements

Using Flashback and Logminer Diagnosability Enhancements Database Replay Using the Data Recovery Advisor Security: New Features

- Configure the password file to use case sensitive passwords - Encrypt a tablespace - Configure fined grained access to network services

____________________________________________________________________________________ 1Z0-050 - Oracle Database 11g - New Features for Administrators

pg. 3

1Z0-050 Sample Questions and Exam Summary ____________________________________________________________________________________ Oracle SecureFiles

- Configure the password file to use case sensitive passwords Encrypt a tablespace - Configure fined grained access to network services

Miscellaneous New Features

- Describe and use the enhanced online table redefinition - Enhanced finer grained dependency management - Use Enhanced DDL - Apply the improved table lock mechanism, Create invisible indexes - Use Query Result Cache and PL/SQL Result Cache - Adaptive Cursor Sharing - Temporary Tablespace Enhancements

SQL Performance Analyzer

SQL Plan Management Automatic SQL Tuning -

Overview of SQL Performance Analyzer Using SQL Performance Analyzer SQL Plan Baseline Architecture Set up SQL Plan Baseline Using SQL Plan Baseline Setup and modify Automatic SQL Tuning Interpret reports generated by Automatic SQL Tuning

1Z0-050 Sample Questions: 01) You have an Oracle Database 11g instance with ASM storage. Your ASM instance is running.

You execute the following command: ASMCMD> lsdsk Which two statements are true? (Choose two.) a) Disk information is displayed for all available ASM disk groups b) Disk information is obtained from the V$ASM_DISK_STAT and V$ASM_DISK dynamic views of the ASM instance c) Disk information is obtained by scanning disk headers d) An error occurs because you did not specify the -d flag 02) Which two statements about a fixed SQL plan baseline are true? (Choose two.) a) A fixed SQL plan baseline contains one or more enabled fixed plans. b) A fixed SQL plan baseline evolves over time in the same way a non-fixed plan does. c) A fixed SQL plan baseline cannot have new plans added. d) The optimizer automatically adds new plans to the fixed SQL plan baseline. e) If you accept a SQL profile recommended by STA for a SQL statement that has a fixed SQL plan baseline, the plan is added to the fixed SQL plan baseline as a non-fixed plan.

03) You use the LOAD_PLANS_FROM_CURSOR_CACHE procedure of the DBMS_SPM package to load a plan into the SQL plan baseline. With which status is it loaded by default? a) FIXED b) ENABLED c) ACCEPTED ____________________________________________________________________________________ 1Z0-050 - Oracle Database 11g - New Features for Administrators

pg. 4

1Z0-050 Sample Questions and Exam Summary ____________________________________________________________________________________ d) DISABLED 04) You want to use SecureFiles in your Oracle 11g database. Which two statements about using SecureFiles versus BasicFiles are true? (Choose two.) a) SecureFiles can detect and automatically eliminate duplicate LOB data. b) SecureFiles are more secure, but BasicFiles offer better disk utilization. c) SecureFiles can be used in partitioned and nonpartitioned tables in an ASSM tablespace. d) BasicFiles offer better performance because they support data compression.

05) You are installing Oracle Database 11g and want to comply with Optimal Flexible Architecture (OFA) guidelines. Which action is recommended to ensure OFA compliance? a) setting up the flash recovery area and datafiles on the same physical disk b) locating your datafiles under the Oracle base c) explicitly setting the ORACLE_HOME environment variable d) setting up the flash recovery area under the Oracle home 06) With Oracle 11g, which new recommendations does the SQL Access Advisor generate? a) partitioning recommendations b) index creation recommendations c) materialized view recommendations d) materialized view log recommendations 07) You want to use automatic plan capture to automatically capture SQL plan history information for repeated SQL statements. Which action should you take? a) Execute the CONFIGURE procedure of the DBMS_SPM package. b) Set OPTIMIZER_USE_SQL_PLAN_BASELINES to FALSE. c) Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE. d) Execute the LOAD_PLANS_FROM_SQLSET function of the DBMS_SPM package.

08) Which statements about using Enterprise Manager Support Workbench are true? (Choose all that apply.) a) Support Workbench can only be used to package and upload incident data b) Support Workbench can only be used to track Service Requests c) Support Workbench can be accessed using the ADRCI command-line utility d) Support Workbench allows you to collect diagnostic data for one or more problems into an incident package e) Support Workbench allows you to add additional diagnostic data to an incident package 09) Your cat02 database contains an Oracle 11g recovery catalog schema owned by cat011, and your cat01 database contains an Oracle 10g recovery catalog schema owned by cat010. You want to merge the cat010 recovery

____________________________________________________________________________________ 1Z0-050 - Oracle Database 11g - New Features for Administrators

pg. 5

1Z0-050 Sample Questions and Exam Summary ____________________________________________________________________________________ catalog schema into the cat011 recovery catalog schema using the IMPORT CATALOG RMAN command to use a single catalog schema for both the cat02 and cat01 databases.

Connected to the destination catalog, you execute the following RMAN command: IMPORT CATALOG cat010/oracle@cat01; Which two statements are true? (Choose two.) a) All databases registered in the cat010 catalog remain registered b) All databases registered in the cat010 catalog are unregistered c) All databases registered in the cat011 catalog will be registered in the cat010 catalog d) If a database named prod is registered in both the source and destination recovery catalogs, the statement fails, and the import is rolled back 10) You have enabled Direct NFS to maximize I/O performance. You want to specify additional NFS settings for a single database, and allow other Oracle 11g databases to use different settings. In which location should you create the oranfstab file? a) /etc b) $ORACLE_HOME/dbs c) $ORACLE_HOME/lib d) /etc/mtab

Answers to 1Z0-050 Exam Questions: QUESTION: 01 Answer: a, b

QUESTION: 02 Answer: a, e

QUESTION: 03 Answer: c

QUESTION: 04 Answer: a, c

QUESTION: 05 Answer: b

QUESTION: 06 Answer: a

QUESTION: 07 Answer: c

QUESTION: 08 Answer: d, e

QUESTION: 09 Answer: b, d

QUESTION: 10 Answer: b

Note: If you find any typo or data entry error in these sample questions, we request you to update us by commenting on this page or write an email on feedback@oraclestudy.com

____________________________________________________________________________________ 1Z0-050 - Oracle Database 11g - New Features for Administrators

pg. 6