Articles & Tutorial for OCP DBA 10g certification
All articles for OCP DBA 10g certification
Tips and How Tos for OCP DBA 10g certification
!:3701667
in OCP DBA 10g
Everything you want to know about the 1z0-043 test.
Question: Q. What is the pre-requisite for taking the 1z0-043 test?
Answer: A. The 1z0-042 test is the pre-requisite for Oracle Database 10g OCP credential. Additionally, it also requires a hands-on experience to obtain the be...
continue reading "!:3701667" »
Database Resource Manager (DRM).
in OCP DBA 10g
Definition
The Database Resource Manager (DRM) is a DBA tool available in Oracle 10g. It helps to allocate resources to various resource consumer groups based on the criticality of a particular task. It also gives the Oracle database server more control over resource management decisions....
continue reading "Database Resource Manager (DRM)." »
OCP 1z0-043 Short Notes: Exam passing tips
in OCP DBA 10g
Configuring Recovery Manager The control file, target database catalog, and Recovery catalog is used to store the RMAN's persistent settings.
The alert log file is used to find out the values of the changed parameters at the time of instance startup.
The NLS_LANG parameter must be set...
continue reading "OCP 1z0-043 Short Notes: Exam passing tips" »
Skills required for Oracle test 1Z0-043
in OCP DBA 10g
Oracle has specified 59 objectives under 14 topics for 1Z0-043 (Oracle 10g Administration-II). A candidate is required to have an excellent command over the following areas to qualify the test:
Knowing about RMAN. Starting RMAN. Configuring RMAN. Using RMAN commands. Knowing about...
continue reading "Skills required for Oracle test 1Z0-043" »
The Recycle Bin
in OCP DBA 10g
Introduction
The recycle bin is a feature in Oracle 10g that assists the database user and the DBA. Database users now do not have to pay attention to the operations that were unwillingly performed, as Oracle 10g provides a facility to recover the dropped database objects at any later...
continue reading "The Recycle Bin" »
Things to practice for Oracle test 1Z0-043.
in OCP DBA 10g
The certification test for Oracle 10g Administration-II (1Z0-043) requires thorough understanding of administrative tasks of a database. To clear the 1Z0-043 exam, a candidate must be well versed with the objectives specified for the test. Before taking the test, you should practice the...
continue reading "Things to practice for Oracle test 1Z0-043." »
Tip on Database Resource Manager.
in OCP DBA 10g
If a scheduler window specifying a resource plan is open then the Resource Manager gets automatically activated.
continue reading "Tip on Database Resource Manager." »
Tip on incomplete recovery.
in OCP DBA 10g
Backups and archive logs of a database have a unique incarnation. Therefore, the backups and archive logs generated by an incarnation must be kept separately from those generated by previous incarnations.
continue reading "Tip on incomplete recovery." »
Tip on SAVE_CONFIG.
in OCP DBA 10g
The SAVE_CONFIG command helps the DBA to save all the runtime configuration changes to the listener.ora file, which can be useful for saving changed encrypted passwords.
continue reading "Tip on SAVE_CONFIG." »
Tips on granting and revoking the system privileges.
in OCP DBA 10g
The GRANT and REVOKE statements cannot be used to grant or revoke the ADMINISTER_RESOURCE_MANAGER system privilege. In order to grant and revoke the system privilege, use the DBMS_RESOURCE_MANAGER_PRIVS package.
continue reading "Tips on granting and revoking the system privileges." »
