testking oracle 10g 1z0-043
Visited 1506 times, 3 so far today
Exam 1z0-043: Oracle Database 10g: Administration II
Exam Number: 1Z0-043
Associated Certifications: Oracle Database 10g Database Administrator Oracle Certified Professional
Exam Price: $125.00 USD
Exam Registration: Register
Duration: 90 minutes
Number of Questions: 70
Passing Score: 70%
Recommended Training and Preparation
Oracle Database 10g: Administration Workshop II
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: Administration Workshop II 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-043 Oracle Database 10g: Administration II
Oracle authorized practice exam from Transcender: DBCert: Database 10g: Administration II
Oracle 10g Database Administrator Candidate Guide
Exam Retake Policy
Sample Questions
Exam Topics
Using Globalization Support Objectives
[ ] Customize language-dependent behavior for the database and individual sessions
[ ] Specify different linguistic sorts for queries
[ ] Use datatime datatypes
[ ] Query data using case insensitive and accent insensitive searches
[ ] Obtain Globalization support configuration information
Configuring Recovery Manager
[ ] Configure database parameters that affect RMAN operations
[ ] Change RMAN default settings with CONFIGURE
[ ] Manage RMAN’s persistent settings
[ ] Start RMAN utility and allocate channels
Recovering from User Errors
[ ] Recover a dropped table using Flashback technology
[ ] Perform Flashback table operation
[ ] Manage the recycle bin
[ ] Recover from user errors using Flashback versions query
[ ] Perform transaction level recovery using Flashback Transaction query
Dealing with Database Corruption
[ ] Define block corruption and list its causes and symptoms
[ ] Detect database corruptions using the following utilities: ANALYZE
DBVERIFY
[ ] Detect database corruptions using the dbms_repair package
[ ] Implement the DB_BLOCK_CHECKING parameter to detect corruptions
[ ] Repair corruptions using RMAN
Automatic Database Management
[ ] Use the Database Advisors to gather information about your database
[ ] Use the SQL Tuning Advisor to improve database performance
[ ] Use automatic undo retention tuning
Using Recovery Manager
[ ] Use the RMAN BACKUP command to create backup sets and image copies
[ ] Enable block change tracking
[ ] Manage the backups and image copies taken with RMAN with the LIST and REPORT commands
Recovering from Non-Critical Losses
[ ] Recover temporary tablespaces
[ ] Recover a redo log group member
[ ] Recover index tablespaces
[ ] Recover read-only tablespaces
[ ] Recreate the password file
Monitoring and Managing Storage
[ ] Tune redo writing and archiving operations
[ ] Issue statements that can be suspended upon encountering space condition errors
[ ] Reduce space-related error conditions by proactively managing tablespace usage
[ ] Reclaim wasted space from tables and indexes using the segment shrink functionality
[ ] Estimate the size of new table and indexes
[ ] Use different storage options to improve the performance of queries
[ ] Rebuild indexes online
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
Monitoring and Managing Memory
[ ] Implement Automatic Shared Memory Management
[ ] Manually configure SGA parameters for various memory components in the SGA
[ ] Use Automatic PGA Memory Management
Database Recovery
[ ] Recover the control file
[ ] Explain reasons for incomplete recovery
[ ] Perform incomplete recovery using EM
[ ] Perform incomplete recovery using RMAN
[ ] Perform incomplete recovery using SQL
[ ] Perform database recovery following a RESETLOGS operation
Flashback Database
[ ] Determine which flashback technology to use for each recovery situation
[ ] Configure and use Flashback Database
[ ] Monitor the Flashback Database
[ ] Use the Enterprise Manager Recovery Wizard to flashback database
[ ] Manage (or maintain) the Flash Recovery Area
Managing Resources
[ ] Configure the Resource Manager
[ ] Assign users to Resource Manager groups
[ ] Create resource plans within groups
[ ] Specify directives for allocating resources 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
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.
PassGuide offers free demo for Certification Exams You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products. Download links:http://demo.passguide.com/downloadRecommended Training about 1z0-043 exam PDF
The following courses are the recommended training for 1z0-043 exam PDF.
1z0-043 Q & A with Explanations
1z0-043 Audio Exam
1z0-043 Study Guide
1z0-043 Preparation Lab
1z0-043 Exam: Freetestking’s oracle database 10g:administration ii PDF
The oracle database 10g:administration ii PDF for preparing for the 1z0-043 exam – Freetestking’s oracle database 10g:administration ii. 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:
You observe that a database performance has degraded over a period of time. While investigating the
reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.
Which advisory component would you refer to, in order to determine that required size of the database buffer cache?
A.Memory Advisor B.Segment Advisor C.SQL Tuning Advisor D.SQL Access Advisor
E.Automatic Database Diagnostic Monitor (ADDM) Answer: A
QUESTION 2:
Exhibit
In your production database, the total waits and the time waited for log file parallel write are
significantly high. While investigating the reason, you find that there are three redo log groups with two members in each group, and all redo log members are places on a single physical disk.
What action would you take to minimize the waits? A.start the log writer slave processes
B.increase the number of redo log files
C.increase the size of the redo log buffer
D.place the redo log files on the different disks
E.increase the number of log writer processes
Answer: D
TK
1Z0-043
QUESTION 3:
One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file.
Which operation do you need to perform after re-creating the control file and opening the database? A.drop and re-create the read-only tablespaces
B.rename the read-only data files to their correct file names
C.change the tablespace status from read/write to read-only
D.re-create the read-only tablespace because it is automatically removed
Answer: B
QUESTION 4:
You have set some of the initialization parameters as: DB_BLOCK_SIZE = 8KB
SGA_MAX_SIZE = 2GB SGA_TARGET = 0
SHARED_POOL_SIZE = 120MB DB_CACHE_SIZE = 896MB STREAM_POOL_SIZE = 0
LARGE_POOL_SIZE = 110 MB
Which two statements are correct? (Choose two.)
A.You cannot set a value for theDB_8K_CACHE_SIZEparameter.
B.If you increase the size of the large pool to 120 MB, then the memory allocated to the shared poll will be reduced to 110 MB.
C.If the value forSGA_TARGETis changed to 1 GB andSHARED_POOL_SIZEis set to 120 MB, then memory cannot be taken from the shared pool, even if the shared pool has free space available.
D.If an application attempts to allocate more than 120 MB from the shared pool and free space is available in the buffer pool, then the free space from the buffer pool is allocated to the shared pool.
Answer: A, C
QUESTION 5:
You are performing a block media recovery on thetools01.dbfdata file in theSALESdatabase using
RMAN. Which two statements are correct in this scenario? (Choose two.) A.You must ensure that the SALES database is mounted or open.
B.You must restore a backup control file to perform a block media recovery.
C.You must take thetools01.dbfdata file offline before you start a block media recovery.
D.You must put the database inNOARCHIVELOGmode to perform a block media recovery.
E.You can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.
Answer: A, E
TK
1Z0-043
QUESTION 6:
Exhibit
You executed the following command to perform a backup of theUSERStablespace: RMAN>BACKUP TABLESPACE USERS;
Which type of backup would this command perform? A.backup set
B.image copy
C.incremental backup
D. None; the user receives on error indicating that the backup must be specified. Answer: A
QUESTION 7:
In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure?
How would you recover the lost redo log member? A.import the database from the last export
B.restore all the members in the group from the last backup
C.drop the lost member from the database and then add a new member to the group D.restore all the database files from the backup and then perform a complete recovery E.restore all the database files from the backup and then perform an incomplete recovery
Answer: C
QUESTION 8:
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true? A.You do not need to restore all the data files.
B.You do not need to open the database with theRESETLOGSoperation
C.You do not need to perform a full backup after theRESETLOGSoperation.
D.You do not need to recover all the data files to the same system change number (SCN). Answer: C
QUESTION 9:
Exhibit
In order to pass this test you would need to go beyond the basics of using Oracle. You will need to show how to set up the database to respond to different languages. You will show how to configure the recovery manager, and how to recover from errors that should occur. You will also need to show how to deal with database corruption. You will show how to set up the database to work automatically when in management mode.
The test has about 70 questions and takes roughly 90 minutes to complete. You would need a passing score of 70% to pass and get your certification.
Whether you are a technician, network administrator, or database administrator, if you take and pass the 1z0-043: Oracle Database 10g: Administration II exam, you will provide proof you know about Oracle 10g, how to use, manage, and administer it, as well as how to overcome errors when they develop. This will give you an advantage that will set you above the rest of those in similar positions. 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 Oracle 10g.
Oracle Certification benefits include:
Dowload PassGuide Practice Test Questions
6 Comments on “testking oracle 10g 1z0-043”