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
Best Oracle 1Z0-052 Certification, Oracle 1Z0-052 Training at certkingdom.com
