Archive for the ‘OCA DBA 10g’ category

What is locking?

October 26th, 2009

Locking is a mechanism implemented either on an entire table or a row. Locking avoids the destruction done by the transactions accessing the same resource. The resource may be data in a table or rows in a data dictionary.

This is a preview of What is locking?. Read the full post (127 words, estimated 30 secs reading time)

Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.

No comments »

Posted in OCA DBA 10g, OCP DBA 10g, Oracle Certified Master 10g, RAC Certified Expert 10g

Tags: 1Z0-042

OCP 1z0-047 Short Notes: Exam passing tips

October 3rd, 2009

Retrieving data using the SQL SELECT statement and using single row functions to customize the output

/*…*/ and — are used to put comments in an Oracle program.

The CREATE TABLE does not end immediately with a semicolon, and a column name cannot start with a numeric value. However, a numeric value can be used in between a column name.

This is a preview of OCP 1z0-047 Short Notes: Exam passing tips. Read the full post (692 words, estimated 2:46 mins reading time)

No comments »

Posted in OCA DBA 10g, OCA DBA 11g, OCA DBA 9i, OCA PL/SQL Developer, OCP DBA 10g, OCP DBA 11g, OCP DBA 9i, OCP PL/SQL Developer, Oracle Certified Master 10g, Oracle PL/SQL Developer, Performance Tuning Expert 11g, RAC Certified Expert 10g, SQL Certified Expert 10g, SQL Certified Expert 11g

Tags: 1Z0-047 1Z0-051

What is the DBVERIFY utility?

October 2nd, 2009

DBVERIFY is an Oracle external command-line utility that performs a physical data structure integrity check. This utility is used on backup files, online databases, and offline databases. The utility is executed by issuing the DBV command at the command prompt.

This is a preview of What is the DBVERIFY utility?. Read the full post (236 words, estimated 57 secs reading time)

No comments »

Posted in OCA DBA 10g, OCP DBA 10g, Oracle Certified Master 10g, RAC Certified Expert 10g

Tags: 1Z0-042 1Z0-043

Automatic Storage Management

October 1st, 2009

Enterprises are preferably switching from old existing Oracle versions, such as Oracle 8i and Oracle 9i, to Oracle 10g to have various additional profitable features. They often employ the Automatic Storage Management (ASM) option to enhance the manageability and consolidation of a database.

Oracle 10g

This is a preview of Automatic Storage Management. Read the full post (715 words, 2 images, estimated 2:52 mins reading time)

No comments »

Posted in OCA DBA 10g, OCP DBA 10g, Oracle Certified Master 10g, RAC Certified Expert 10g

Tags: 1Z0-042

What is the n-tier architecture?

October 1st, 2009

The n-tier architecture is the most advanced type of architecture for a network configuration. This architecture introduces middleware components, such as application servers and Web servers between clients and the database server.

An example of the n-tier architecture is the Internet. The n-tier architecture is the most preferred architecture for an enterprise network. This architecture reduces processing load on the server.

Download practice question and study guide for rac-administrator-certified-experts-10g for exam. Become Oracle Oracle Database 10g: Admin - I certified.

Permanent link to this post (82 words, estimated 20 secs reading time)

No comments »

Posted in OCA DBA 10g, OCP DBA 10g, Oracle Certified Master 10g, RAC Certified Expert 10g

Tags: 1Z0-042

What is an implicit lock in Oracle 10g?

October 1st, 2009

An implicit lock is a lock that a row or a table acquires automatically, depending on the database operations such as ALTER TABLE, UPDATE, SELECT etc.

Click here to get free rac-administrator-certified-experts-10g RAC Certified Expert 10g exam practice questions. Click here to download 1Z0-042 test study guide and practice question.

Permanent link to this post (52 words, estimated 12 secs reading time)

No comments »

Posted in OCA DBA 10g, OCP DBA 10g, Oracle Certified Master 10g, RAC Certified Expert 10g

Tags: 1Z0-042

What is the REMOTE_OS_AUTHENT parameter?

September 30th, 2009

The REMOTE_OS_AUTHENT parameter in the parameter file of the database specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter or not. The type of the REMOTE_OS_AUTHENT parameter is Boolean, the default value is false, and the parameter class is static. The REMOTE_OS_AUTHENT parameter is case sensitive on some operating systems. The flow diagram below may help a user understand the role of the REMOTE_OS_AUTHENT parameter for a remote database:

This is a preview of What is the REMOTE_OS_AUTHENT parameter?. Read the full post (239 words, 1 image, estimated 57 secs reading time)

No comments »

Tags: 1Z0-042 1Z0-047

What is a deadlock and where are deadlocks encountered?

September 30th, 2009

A deadlock refers to a condition, in which, two or more processes simultaneously wait for each other to complete, as a result of which both, or all of them, as the case may be, hang. Deadlocks are generally encountered in multitasking, multiprocessing, and client-server environments.

This is a preview of What is a deadlock and where are deadlocks encountered?. Read the full post (106 words, estimated 25 secs reading time)

No comments »

Posted in OCA DBA 10g, OCP DBA 10g, Oracle Certified Master 10g, RAC Certified Expert 10g

Tags: 1Z0-042

What is DBMS_SESSION PL/SQL package?

September 8th, 2009

The DBMS_SESSION PL/SQL package is used to provide access to the ALTER SESSION and ALTER SYSTEM statements. This package is also used for gathering session related information. The DBMS_SESSION PL/SQL package uses the privileges of the user executing this package, instead of using privileges of the user SYS.

Become Oracle OCA DBA 10g certified.
Click here to download oca-dba-11g test study guide and practice question.
Download practice question and study guide for oca-dba9i for exam.
Download free practice test for Oracle OCA PL/SQL Developer exam.
Best exam simulation Oracle ocp-dba10g download free trial.
Download practice question and study guide for ocp-dba-11g for exam.
Get certified in first attempt download ocp-dba9i - OCP DBA 9i simulation.
Best exam simulation Oracle ocp-pl-sql download free trial.
Pass Oracle Certified Master 10g in first attampt.
Download free practice test for Oracle Oracle PL/SQL Developer exam.
Get certified in first attempt download performance-tuning-certified-expert-11g - Performance Tuning Expert 11g simulation.
Best exam simulation Oracle rac-administrator-certified-experts-10g download free trial.
Click here to download sql-certified-expert-10g test study guide and practice question.
Download free practice test for sql-certified-expert-11g SQL Certified Expert 11g exam.
Download practice question and study guide for 1Z0-033 for exam.
Click here to download 1Z0-042 test study guide and practice question.
Click here to download 1Z0-047 test study guide and practice question.
Download practice question and study guide for 1Z0-051 for exam.

Permanent link to this post (227 words, estimated 54 secs reading time)

No comments »

Tags: 1Z0-033 1Z0-042 1Z0-047 1Z0-051

How are archive destinations specified?

September 3rd, 2009

When archiving redo logs, it must be decided whether to archive them to a single archive destination or multiplex them. When the archived redo logs are multiplexed, they are archived to more than one archive destination. The following two methods can be used to specify archive destinations:

This is a preview of How are archive destinations specified?. Read the full post (521 words, estimated 2:05 mins reading time)

No comments »

Posted in OCA DBA 10g, OCP DBA 10g, OCP DBA 9i, Oracle Certified Master 10g, RAC Certified Expert 10g

Tags: 1Z0-032 1Z0-042