testking oracle 10g 1z0-045
Visited 1507 times, 1 so far today
Exam 1z0-045: Oracle10g DBA New Features for Oracle8i OCPs
Exam Number: 1Z0-045
Associated Certifications: Oracle8i OCPs to Oracle Database 10g
Exam Price: $125 USD
Exam Registration: Register
Duration: 2 hours
Number of Questions: 78
Passing Score: 73%
Recommended Training and Preparation
The exam has been validated against Oracle Database 10g and Oracle Database 10g R2 and is compatible with both. Classroom training, practice and experience on either release is suitable preparation.
Oracle Database 10g: New Features for Oracle8i DBAs
Additional Information & Resources
Practice Exams
Oracle authorized practice exam from Self Test Software. 1Z0-045 Oracle Database 10g DBA New Features for Oracle8i OCPs
Oracle authorized practice exam from Transcender: DBCert: Oracle Database 10g DBA New Features for Oracle8i OCPs
Oracle 10g DBA Candidate Guide
Exam Retake Policy
Exam Topics
Oracle Server Security
[ ] Explain the privileged connection options
General High Availability Technology
[ ] Explain the Oracle Flashback feature
[ ] Describe Resumable Space Allocation
Oracle LogMiner Enhancements
[ ] Explain LogMiner new features: DDL statement support, dictionary staleness detections, ability to use an online dictionary, ability to skip log corruptions
Backup and Recovery
[ ] Describe new RMAN manageability features: backup enhancements, restore/recovery enhancements
[ ] Describe new RMAN reliability features: Block media recovery (BMR), Trial Recovery
[ ] Block media recovery (BMR), Trial Recovery
Database Resource Manager Enhancements
[ ] Automatically limit resource consumption other than CPU and DOP
Online Operations
[ ] Describe online table redefinitions
[ ] Describe the use of the Server Parameter File (SPFILE)
Segment Management (Part II)
[ ] Explain and use the new Automatic Segment-Space Management functionality
Performance Improvements
[ ] Describe the cursor sharing enhancements
File Management
[ ] Create and manage OMF files
Tablespace Management
[ ] Create and maintain UNDO tablespaces
Memory Management
[ ] Set parameters to enable automatic and dynamic sizing of SQL working areas
Globalization Support
[ ] Describe the Unicode enhancements
[ ] Use the Character Set Scanner
Installation
[ ] Describe installation new features support
[ ] Describe installation performance enhancements
Server Configuration
[ ] Simplify instance configuration using a subset of initialization parameters
[ ] Use policy-based database configuration framework
[ ] View database usage statistics through EM
Load and Unload Data
[ ] Transport tablespaces across different platforms
[ ] Explain Data Pump architecture
[ ] Monitor a Data Pump job
[ ] Use Data Pump export and import
[ ] Create external tables for data population
[ ] Define your external table properties
Automatic Management
[ ] Use Automatic Database Diagnostic Monitor
[ ] Use Automatic Shared Memory Management
[ ] Use Automatic Optimizer Statistics Collection
[ ] Use Automatic Undo Retention Tuning
Manageability Infrastructure
[ ] Monitor and maintain the AWR
[ ] Use the Active Session History (ASH)
[ ] Monitor and manage server-generated alerts
[ ] Explain the automated tasks feature
[ ] Describe the advisory framework
Application Tuning
[ ] Use the new optimizer statistics
[ ] Use the SQL Tuning Advisor
[ ] Use the SQLAccess Advisor
[ ] Use the performance pages of Database Control
Support for Analytical Applications
[ ] Write MERGE statements with the new conditions and extensions
[ ] Use partitioned outer join syntax for densification
[ ] Use interrow calculations to enhance SQL for analytical capabilities
System Resource Management
[ ] Automatically switch a session back to the original consumer group at the end of the top call
[ ] Set idle time-outs for consumer groups
[ ] Create mappings for the automatic assignment of sessions to consumer groups
Automating Tasks with the Scheduler
[ ] Simplify management tasks by using the Scheduler
[ ] Create a job, program, schedule and window
[ ] Reuse scheduler components for similar tasks
[ ] View information about job executions and job instances
Space Management
[ ] Reduce space related error conditions through proactively managing tablespace usage
[ ] Reclaim wasted space from tables and indexes using the segment shrink functionality
[ ] Use the Segment Advisor
[ ] Use the Undo Advisor
[ ] Use sorted hash clusters
Improved VLDB Support
[ ] Create and maintain bigfile tablespaces
[ ] Create temporary tablespace groups
[ ] Assign temporary tablespace groups to users
[ ] Skip unuseable indexes
[ ] Specify storage characteristics for index partitions in the table partition DML commands
[ ] Create hash-partitioned global indexes
[ ] Maintain hash-partitioned global indexes
Backup and Recovery Enhancements
[ ] Simplify file management for all recovery-related files
[ ] Reduce restore time by applying incremental backups to data file image copies
[ ] Simplify recovery after opening the database with the RESETLOGS option
[ ] Speed backup times by creating faster incremental backups
Flashback Any Error
[ ] Configure and use Flashback Database
[ ] Recover dropped tables with the Flashback Drop feature
[ ] Retrieve row history information with the Flashback Versions Query feature
[ ] Audit or recover FROM transactions with the Flashback Transaction Query feature
[ ] Recover tables to a point in time with the Flashback Table feature
General Storage Enhancement
[ ] Create the SYSAUX tablespace
[ ] Relocate SYSAUX occupants
[ ] Rename tablespaces
[ ] Create a default permanent tablespace
[ ] Copy files using the Database Server
[ ] Use the Redo Logfile Size Advisor
Automatic Storage Management
[ ] Describe Automatic Storage Management
[ ] Set up initialization parameter files for ASM and database instances
[ ] Execute SQL commands with ASM file names
[ ] Start up and shut down ASM instances
[ ] Administer ASM disk groups
[ ] Use RMAN to migrate your database to ASM
Maintain Software
[ ] Understand the supported upgrade paths to Oracle Database 10g
[ ] Use new utility to perform pre-upgrade validation checks
[ ] Use simplified upgrade process that automatically determines components to be upgraded
[ ] Start up the database using a new mode when upgrading
Miscellaneous New Features
[ ] Provide greater flexibility by enabling resumable timeout at the instance level
[ ] Use regular expression support in SQL and PL/SQL for string searching, matching and replacing
[ ] Use additional linguistic comparison and sorting methods in SQL
[ ] Use SQL to flush the buffer cache
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate’s Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate’s employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle’s authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
Recommended Training about 1z0-045 exam PDF
The following courses are the recommended training for 1z0-045 exam PDF.
1z0-045 Q & A with Explanations
1z0-045 Audio Exam
1z0-045 Study Guide
1z0-045 Preparation Lab
1z0-045 Exam: Freetestking’s oracle database 10g:new features for oracle8i ocps PDF
The oracle database 10g:new features for oracle8i ocps PDF for preparing for the 1z0-045 exam – Freetestking’s oracle database 10g:new features for oracle8i ocps. Freetestking is your premier source for practice tests, and true testing environment. Nothing will prepare you for your next exam like a Freetestking. You find it all here at certbible.org.
QUESTION 1:
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?
A. PMON B. SMON C. MMNL D. MMAN E. MMON
Answer: D
The Automatic Shared Memory Management feature uses a new background process named Memory Manager (MMAN). MMAN serves as the SGA Memory Broker and
coordinates the sizing of the memory components. The SGA Memory Broker keeps track
of the sizes of the components and pending resize operations
REF.: Metalink Note:268197.1: New Background Processes In 10g
QUESTION 2:
Which six files are maintained in the Flash Recovery Area? (Choose six.) A. control file
B. RMAN files
C. password file D. parameter file E. flashback logs F. data file copies G. core dump files
H. archived log files
I. RMAN recovery scripts
J. control file autobackpus
Answer: A, B, E, F, H, J
The Flash Recovery Area is a unified storage location for all recovery-related files and activities in an Oracle Database. It includes Control File, Archived Log Files, Flashback Logs, Control File Autobackups, Data Files, and RMAN files.
QUESTION 3:
Consider the following scenario:
You have a directory, data, under the disk group tdgroup
A. You want to create an
alias for one of the data files and you execute the following command: ALTER DISKGROUP tdgroupA
TK
1Z0-045
ADD ALIAS ‘+tdgroupA/data/datafile.dbf’
FOR ‘+tdgroupA.231.45678′;
Which task would be accomplished by the command?
A. The command drops the file +tdgroupA.231.45678
B. The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
C. The command creates a copy of the +tdgroupA.231.45678 file and places it in
+tdgroupA/data after remaining the file to datafile.dbf.
D. The command creates a synonym, datafile.dbf, and places it in +tdgroupA/data and does not remove the +tdgroupA.231.45678 file.
E. The command creates a file, datafile.dbf, in +tdgroupA/ data and removes the references for +tdgroupA.231.45678 from the data dictionary views.
Answer: D
Alias names (or just “aliases”) are intended to provide a more user-friendly means of referring to ASM files, rather than using the system-generated filenames. You can create
an alias for a file when you create it in the database, or you can add an alias to an existing file using the ADD ALIAS clause of the ALTER DISKGROUP statement. You can
create an alias in any system-generated or user-created ASM directory. You cannot create
an alias at the root level (+), however. The following statement adds a new alias name for
a system-generated file name: ALTER DISKGROUP dgroup1
ADD ALIAS ‘+dgroup1/mydir/second.dbf’
FOR ‘+dgroup1/sample/datafile/mytable.342.3′; REF.: Oracle(r) 10g Administrator Guide, 12-28
QUESTION 4:
Exhibit
One the evening of April 22, you are working on a database created using Oracle Database 10g. This database operates in the ARCHIVELOG mode. You discover that you need crucial data that was dropped from the database at 8:00 a.m. No full backup has been taken after April 15.
What would you do?
A. recover the database until April 10
B. recover the database until April 15
C. recover the database until 22 7:59 a.m.
As a technician or database administrator, if you have worked with any older versions of Oracle, you will probably recognize new changes to the database in Oracle8i. These new features include Oracle server security, better backup and recovery functionality, resource manager enhancements, performance improvements in the database, better file management, better installation support, and so9 much more. As a technician, network administrator, or database manager, it will be your job to not only know how Oracle 8i OCP ticks, you will also describe all the new features of Oracle8i and how they work together to get the database to do what it does best – work as a database.
The test has about 78 questions and takes roughly 2 hours to complete. You would need a passing score of 73% to pass and get your certification.
As a technician, or database administrator, by taking the 1z0-045: Oracle10g DBA New Features for Oracle8i OCP, you can add that certification to your resume and have added credentials, which in turn add to your list of skills. Once you take and pass the test from TestKing, and get certified, you will now be able to show your boss that you have the skills to handle the new features assigned to Oracle8i OCP.
Oracle Certification benefits include:
Dowload PassGuide Practice Test Questions
7 Comments on “testking oracle 10g 1z0-045”