1Z0-052 Oracle Database 11g: Administration I

Exam Number: 1Z0-052
Exam Title: Oracle Database 11g: Administration I
Associated Certification Paths Oracle Database 11g Administrator Certified Associate
Duration: 90 minutes
Number of Questions: 70
Passing Score: 66%
View passing score policy
Validated Against: The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0.
Format: Multiple Choice

Complete Recommended Training

Complete the training below to prepare for your exam (optional):

Oracle Database 11g: Administration Workshop I

Additional Preparation and Information

A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Exam Preparation Seminar
Certification Exam Preparation Seminar: Oracle Database 11g Administration I
Exam Prep Seminar Package: Oracle Database Administration I

Practice Exams
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: Oracle Database 11 g: Administration I
Sample Questions

Additional Training
Training Opportunities for Oracle Partner Network Members (available to partners only)
OPN Guided Learning Path: Oracle Database 11g Implementation Specialist (available to partners only)
Training Resources by Exam Topics (available to partners only)

Exploring the Oracle Database Architecture
Explain the Memory Structures
Describe the Process Structures
Overview of Storage Structures

Preparing the Database Environment
Identify the tools for Administering an Oracle Database
Plan an Oracle Database installation
Install the Oracle software by using Oracle Universal Installer (OUI)

Creating an Oracle Database
Create a database by using the Database Configuration Assistant (DBCA)

Managing the Oracle Instance
Setting database initialization parameters
Describe the stages of database startup and shutdown
Using alert log and trace files
Using data dictionary and dynamic performance views

Configuring the Oracle Network Environment
Configure and Manage the Oracle Network
Using the Oracle Shared Server architecture

Managing Database Storage Structures
Overview of tablespace and datafiles
Create and manage tablespaces
Space management in tablespaces

Administering User Security
Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles

Managing Data and Concurrency
Monitor and resolve locking conflicts
Manage data using DML

Managing Undo Data
Overview of Undo
Transactions and undo data
Managing undo

Implementing Oracle Database Security
Database Security and Principle of Least Privilege
Work with Standard Database Auditing

Database Maintenance
Use and manage optimizer statistics
Use and manage Automatic Workload Repository (AWR)
Use advisory framework
Manage Alerts and Thresholds

Performance Management
Use Automatic Memory Management
Use Memory Advisors
Troubleshoot invalid and unusable objects

Intelligent Infrastructure Enhancements
Use the Enterprise Manager Support Workbench
Managing Patches

Backup and Recovery Concepts
Identify the types of failure that can occur in an Oracle database
Describe ways to tune instance recovery
Identify the importance of checkpoints, redo log files, and archived log files
Overview of flash recovery area
Configure ARCHIVELOG mode

Performing Database Backups
Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Manage backups, view backup reports and monitor the flash recovery area

Performing Database Recovery
Overview of Data Recovery Advisor
Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)

Moving Data
Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
Explain the general architecture of Oracle Data Pump
Use Data Pump Export and Import to move data between Oracle databases

QUESTION 1
You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)

A. Disable automatic checkpoint tuning
B. Check the size of the redo log file size and increase the size if it is small
C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
D. Decrease the number of redo log members if there are more than one redo log members
available in each redo log group

Answer: B,C

Explanation:

QUESTION 2
Identify the memory component from which memory may be allocated for:
Session memory for the shared server Buffers for I/O slaves Oracle Database Recovery Manager
(RMAN) backup and restore operations

A. Large Pool
B. Redo Log Buffer
C. Database Buffer Cache
D. Program Global Area (PGA)

Answer: A

Explanation:

QUESTION 3
You executed the following command to create a tablespace called SALES_DATA:
SQL> CREATE TABLESPACE sales_data
DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES_DATA tablespace? (Choose two)

A. The database automatically determines the extent-sizing policy for the tablespace.
B. The segments are automatically shrunk when the contents are removed from them.
C. The allocation of extents within the tablespace is managed through the dictionary tables.
D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E. The space utilization description of the data blocks in segments is managed through free lists.

Answer: A,D

Explanation:

QUESTION 4
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

Answer: B,E

Explanation:

QUESTION 5
You want to enable archiving on your database. Presently, the database is running in
NOARCHIVELOG mode.
Given below are the steps to accomplish the task in random order:
1. Shut down the instance.
2. Execute the ALTER DATABASE ARCHIVELOG command.
3. Start up the instance and mount the database.
4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task?

A. 4, 1, 3, 2, 5
B. 1, 3, 4, 5, 2
C. 1, 3, 2, 5; 4 not required
D. 4, 1, 5, 2; 3 not required
E. 1, 3, 4, 5; 2 not required

Answer: C

Explanation:

Click here to view complete Q&A of 1Z0-052 exam
Certkingdom Review, Certkingdom PDF Torrents