Articles for MCSE, MCSD, MCAD, CIW, CompTIA, Oracle, SCJP Certifications
All articles for OCP DBA 9i certification
Tips and How Tos for OCP DBA 9i certification
Skills required for Oracle test 1Z0-033.
in OCP DBA 9i
Oracle has specified around 70 objectives for this test under 15 topics. Following are the important areas in which an individual should possess good knowledge before taking the O1Z0-033 test:
PL/SQL programming language. Knowledge of database concepts. Knowledge of backup and recovery...
continue reading " Skills required for Oracle test 1Z0-033." »
Study tips for Oracle test 1Z0-033.
in OCP DBA 9i
The objective of this test is to test the analytical skills of the user as a Database Administrator, using Oracle9i as the back-end tool. The test requires a thorough grasp of database concepts, familiarity with the GUI tools, scripts, views, and packages available in Oracle9i. This includes...
continue reading "Study tips for Oracle test 1Z0-033." »
Things to practice for Oracle test 1Z0-033.
in OCP DBA 9i
This test requires a thorough knowledge of administrative tasks for managing the database for optimal performance. The candidate appearing in this test should have a sound knowledge of various tools available in Oracle9i for managing different issues in the database. This includes identifying...
continue reading "Things to practice for Oracle test 1Z0-033." »
How are materialized views managed?
in OCP DBA 9i
Materialized views can be created either through the CREATE MATERIALIZED VIEW statement or the Oracle Enterprise Manager (OEM). The CREATE MATERIALIZED VIEW statement can also be used for populating the materialized views. A materialized view can be derived from an existing user-defined...
continue reading "How are materialized views managed?" »
What is a naming method?
in OCP DBA 9i
A naming method is a names resolution method that a client application uses to resolve a connect identifier to a connect descriptor when attempting to connect to a database service.
Users initiate a connection request to a database service by providing a connect string with the CONNECT...
continue reading "What is a naming method?" »
What is an RMAN channel?
in OCP DBA 9i
An RMAN channel represents one stream of data to a device type and corresponds to one server session. It establishes a connection from the RMAN executable to a target database instance by starting a new server session on the instance. The server session then performs the backup, restore, and...
continue reading "What is an RMAN channel?" »
What is backup retention policy?
in OCP DBA 9i
The Recovery Manager (RMAN) provides the CONFIGURE RETENTION POLICY command to create a persistent and automatic backup retention policy for controlling how long backups and copies should be retained. When a backup retention policy is in effect, RMAN considers the backups and copies of data...
continue reading "What is backup retention policy?" »
What is the Oracle Net stack communication architecture?
in OCP DBA 9i
The Oracle Net software is comprised of certain communication layers (programs), collectively known as a stack, which enable clients and database servers to share, modify, and manipulate data. The stack architecture is based on the Open Systems Interconnection (OSI) model.
On the client side,...
continue reading "What is the Oracle Net stack communication architecture?" »
How does Database Resource Manager perform database resource management?
in OCP DBA 9i
The Database Resource Manager (DRM) is a tool, which handles the resource allocation issues in a more efficient way than can probably be done by the operating system itself. Such issues include equal distribution of resources by the operating system to every active process, inability of the...
continue reading "How does Database Resource Manager perform database resource management?" »
How does Instance Manager kill a session causing lock contention?
in OCP DBA 9i
The Instance Manager tool of the Oracle Enterprise Manager can be used for killing a user session that is causing lock contention. The user session can be killed in the following manner: By expanding the session branch on the left hand side of the Instance Management window. By clicking the...
continue reading "How does Instance Manager kill a session causing lock contention?" »
