testking oracle 10g 1z0-040
Visited 2006 times, 3 so far today
Exam 1z0-040: Oracle Database 10g: New Features for Administrators
Exam Number: 1Z0-040
Associated Certifications: Oracle9i DBA OCPs to Oracle Database 10g
Exam Price: $125.00 USD
Exam Registration: Register
Duration: 105 minutes
Number of Questions: 60
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 Administrators
Oracle Database 10g: New Features for Administrators Release 2
View additional 10g New Features Preparation.
Oracle Database 10g New Features for Administrators Self-Study CD Course (NETg Oracle)
Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only.
Additional Information & Resources
Practice Exams
Oracle authorized practice exam from Self Test Software. 1Z0-040 10g New Features for Administrators
Oracle authorized practice exam from Transcender: Cert-1Z0-040 :: DBCert: 10g Database: New Features for Administrators
Oracle 10g DBA Candidate Guide
Exam Retake Policy
Sample Questions
Exam Topics
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
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
[ ] Minimize load requirements by specifying limits in backup time windows
[ ] Save storage space through writing compressed backup sets
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
Security
[ ] Apply a column level VPD policy
[ ] Apply static and non-static policies
[ ] Share VPD policy functions
[ ] Use the unified audit trails
[ ] Use fine-grained auditing for DML statements
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-040 exam PDF
The following courses are the recommended training for 1z0-040 exam PDF.
1z0-040 Q & A with Explanations
1z0-040 Audio Exam
1z0-040 Study Guide
1z0-040 Preparation Lab
1z0-040 Exam: Freetestking’s oracle database 10g:new features for adminsitrators PDF
The oracle database 10g:new features for adminsitrators PDF for preparing for the 1z0-040 exam – Freetestking’s oracle database 10g:new features for adminsitrators. 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 three methods can you use to run an Automatic Database Diagnostic
Monitor (ADDM) analysis over a specific time period? (Choose three.)
A. Enterprise Manager GUI
B. DBMS_TRACE package APIs
C. DBMS_ADVISOR package APIs
D. DBMS_MONITOR package APIs
E. $ORACLE_HOME/rdbms/admin/addmrpt.sql script
Answer: A, C, E Explanation:
—————–
To make use of ADDM, a PL/SQL interface called DBMS_ADVISOR has been implemented. This PL/SQL interface may be called through the supplied
$ORACLE_HOME/rdbms/admin/addmrpt.sql script, called directly, or used in combination with the Oracle Enterprise Manager application. Besides this
PL/SQL package a number of views (with names starting with the DBA_ADVISOR_ prefix) allow retrieval of the results of any actions performed with the DBMS_ADVISOR API. The preferred way of accessing ADDM is through the Enterprise Manager interface, as it shows a complete performance overview
including recommendations on how to solve bottlenecks on a single screen.
When accessing ADDM manually, you should consider using the ADDMRPT.SQL
script provided with your Oracle release, as it hides the complexities involved in accessing the DBMS_ADVISOR package.
QUESTION 2:
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
TK
1Z0-040
QUESTION 3:
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 4:
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
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
TK
1Z0-040
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 5:
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.
D. recovery is not possible; manually re-create the object
Answer: C
RMAN simplifies recovery operations using backups taken from earlier database incarnation so that it is easy as recovering a backup from the same incarnation. The simplified recovery through RESETLOGS feature is an enhancement to recovery operations so that previous incarnation backups can be used for recovery of the current database incarnation. You use this feature when you have performed an incomplete recovery (or a recovery using a backup control file) and opened the database with the RESETLOGS option.
To perform incomplete recovery, use the SET UNTIL command to specify the time,
SCN, restore point, or log sequence number at which recovery terminates. Alternatively, specify the UNTIL clause on the RESTORE and RECOVER commands.
REF.: Oracle(r) Database 10g: New features for Oracle 8i, 18-21 and Oracle(r) 10g Backup and Recovery
Basics, 3-4
QUESTION 6:
Interactive Testing 10g 1z0-040 Engine Included!
200 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Exam Number/Code:1z0-040
Exam Name: oracle database 10g:new features for adminsitrators
Testking 1z0-040 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 1z0-040 exam?Searching 1z0-040 Test Questions,
1z0-040 Practice Exam,1z0-040 Braindumps ? 1z0-040 practice exam covers all the practice test objectives to pass 1z0-040 exam.
Pass your exam at first attempt with our Testking 1z0-040 study guide,1z0-040 Braindumps, As well Audio exam, Realistic Practice Labs, and Interactive Testing Engine.
Our Testking practice test covers the information associated with each 1z0-040 exam topics in details and includes information found in no other practice test sites on the web.
Our challenging questions with Correct Answers built to simulate the actual exam. Unlimited, FREE auto-updates so you’re never behind on any topic. The whole package comes as an automatic download so there’s no waiting or shipping. Our most questions and answers along with explanations. Our practice test will determine you to take your 1z0-040 certification exam and pass the official exam on your first try, guaranteed
Now guaranteed Testking 1z0-040 exam training is available in various formats to best suit your needs and learning style. Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Real-Exams has the 1z0-040 pdf vce format resources that will enable you to pass your 1z0-040 test with flying colors.
Comprehensive questions with complete explanations about actualtests 1z0-040 exam
download 1z0-040 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
1z0-040 exam questions updated on regular basis
Oracle 1z0-040 Transcender Torrent
Oracle 1z0-040 P4S
Oracle 1z0-040 Study Guide
Oracle 1z0-040 Exams
Oracle 1z0-040 Braindumps
Oracle 1z0-040 Pass4sure
Oracle 1z0-040 Real Exams
Oracle 1z0-040 Exam
Oracle 1z0-040 Actual Tests
Oracle 1z0-040 Pdf
1z0-040 also gives new editions of Real Exams 1z0-040 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-710 are useful for understanding 1z0-040 exam terminologies and these brain dumps also very useful for enhancing people brain power. These Testking Real Practice Questions 1z0-040 are prepare by highly qualified and 1z0-040 professionals. 1z0-040 Certification experts’ teams always try to give you real exam environment in these 4shared training materials links.
QUESTION 1:
Which three methods can you use to run an Automatic Database Diagnostic
Monitor (ADDM) analysis over a specific time period? (Choose three.)
A. Enterprise Manager GUI
B. DBMS_TRACE package APIs
C. DBMS_ADVISOR package APIs
D. DBMS_MONITOR package APIs
E. $ORACLE_HOME/rdbms/admin/addmrpt.sql script
Answer: A, C, E
Explanation:
—————–
To make use of ADDM, a PL/SQL interface called DBMS_ADVISOR has been
implemented. This PL/SQL interface may be called through the supplied
$ORACLE_HOME/rdbms/admin/addmrpt.sql script, called directly, or used in
combination with the Oracle Enterprise Manager application. Besides this
PL/SQL package a number of views (with names starting with the DBA_ADVISOR_
prefix) allow retrieval of the results of any actions performed with the
DBMS_ADVISOR API. The preferred way of accessing ADDM is through the
Enterprise Manager interface, as it shows a complete performance overview
including recommendations on how to solve bottlenecks on a single screen.
When accessing ADDM manually, you should consider using the ADDMRPT.SQL
script provided with your Oracle release, as it hides the complexities
involved in accessing the DBMS_ADVISOR package.
QUESTION 2:
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 3:
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 4:
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
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 5:
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.
D. recovery is not possible; manually re-create the object
Answer: C
Testking 1z0-040
TK Questions&Answers(Q & As with Expert Explanations): 200 Q&A
Update: 13/11/2008
Free Down: Testking 1z0-040
Free Down: Pass4sure 1z0-040
Dowload PassGuide Practice Test Questions
12 Comments on “testking oracle 10g 1z0-040”